Message is stuck with ‘Ready to run’ status at send port to WCF-SQL Adapter

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Message is stuck with ‘Ready to run’ status at send port to WCF-SQL Adapter

Viewing 0 reply threads
  • Author
    Posts
    • #23439

      Hi, 
       I’m trying to transfer base64 encoded data to varbinary(max)
      field in SQL Server 2005 using LOB wcf-sql adapter-generated SetDocument
      procedure. When the message should be transfered to SQL Server noting
      happens, message stuck at send port: Message status – Queued(aw aiting processing), Service status – ready to run .

      My setings are:

      I’m getting necessary schema’s with add adapter metadata wizard, where i enter SQL server machine name(biztalk is on the same virtual machine) and the database name. Then I connect to SQL Server, add SetDocument procedure for necessary table and generate schema’s.

      Then i  create simple orchestration(it’s simplified to solve this particular error, my task is to transfer document from sharepoint library on the remote machine to the sql serer), messages, solicit-response port for wcf-sql, port to pick up XML with data and map.

      When configuring physical port I enter the same uri settings as for metadata wizard,  SOAP action look like ‘TableOp/WriteBinary/dbo/myDocTable/Document’

      I start application, put XML with base64 data  to the necessary folder, it disappears and then i get this ‘ready to run’ message.

      How could this be resolved?

Viewing 0 reply threads
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.