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?
|
No responses found. Be the first to respond and make money from revenue sharing program.
|