unable to get the data at the send location

I have configured a Receive port as SQL and a send port as a File and the data is getting transferred from the Database but i am unable to see the file at the send location after starting the application in the Administrative console. Pls Help

[244 byte] By [mallyk] at [2008-2-26]

«« Interop problem trying to use Dotnet as an Asycnchronous background worker
»» Leveraging CLR in a C++ COM+ DLL

# 1

Possibly numerous things could have gone wrong in your case, check the following.

1. Receive Location is enabled

2. Send port is elisted/started

3. Filter in the send port is configured to pick up messages coming via the SQL receive port (BTS.ReceivePortName == "Your receive port name")

4. Check the event viewer and admin console to see, if there are any suspended messages (with errors such a published but cannot be routed etc)

Regards,
Saravana Kumar
http://www.biztalk247.com/v1/
http://www.digitaldeposit.net/blog
[Please mark the response as "Answer" if it solves your problem.]

Saravana_Kumar at 2007-9-26 >

top of Msdn Tech,BizTalk Server,BizTalk R2 General...

# 2

Hi,

Good points above. If you are using a stored procedure, you may also want to check that you have removed the XMLDATA option. This is required for using the schema generator wizard, but it can cause problems when running the adapter.

Regards,

Alan

AlanSmithMVP at 2007-9-26 >

# 3

Saravana -

Thanks a lot. I just tried it but in the admin console i have an error with source and category as BizTalk Server 2006 and reports events as 5753 / 5719. What do i do?

Thanks,

Adi

Adi_CTS at 2007-9-26 >

# 4

Thanks Alan, I had done that.

Adi_CTS at 2007-9-26 >

# 5

An event 5753 is about the message is suspended.

Open this message in the BizTalk Server Administrative Console and get the information why is so. Look at the context properties.

Then check the subsriptions (Adm.console / Hub / 'Query Expression' tab / 'Search for' field = 'Subscriptions'

Regards,

Leonid Ganeline

http://geekswithblogs.net/leonidganeline/

LeonidGaneline at 2007-9-26 >

# 6

Also, you may want to check the permissions of the folder your port is pointing to. Make sure that you have permission to read/write to that folder. If your permissions are incorrect and the send port can't write to the folder, then you would get a dehydrated send port.

NickKoller-MSFT at 2007-9-26 >

BizTalk Server Hot Topic

BizTalk Server New Topic

BizTalk Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech