| Anunay 2004-03-30, 5:38 am |
| Hi,
I'm trying to invoke a stored procedure(SP) on a remote SQL server on a different domain using SQL Receive Function. I'm able to do this without any problems, if the SP is on my local machine, but i'm get following error in my event log when I try t
o invoke SP on the remote SQL Server. I'm also able to execute remote sp from my local machine using Query Anaylser, but not through biztalk. I've not ticked the Disassemble resultset option in my Job
Can someone help me to solve this problem ?
Thanks,
Anunay
-----------------------------------------
A worker thread reported a failure: [Error:] An error occurred in BizTalk Server.
Details:
------------------------------
The transaction has already been implicitly or explicitly committed or aborted
There was a failure creating the internal work item. Make sure that SQL Server is running.
[Source:] [HelpFile:] [HelpContext:] 0
Note: The Disassemble result set feature can not be used if the target SQL Server is the same one that BizTalk uses. In this case you must unselect the Disassemble Rresult Set feature.
The error code is shown in the data area below.
The operation was: ISQLWorker->Execute
The worker thread was working on:
Job Name: WS2JDA_POLL04_Job
SQL Script: Exec [SP_POSTransactionTenderDetails]
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.ability
|