| Ashwani Raghav 2004-07-09, 3:31 pm |
| Hi All,
I am using biztalk server to integrate MSGP with POS System. I am having
problems with POR documents only.
Although i am processing other docs with same biztalk configuration
successfully.
But for POR docs, the problem is, if i send a number of POR to biztalk
receive function, it only process a few documents and sends some to
suspended-Q.
From suspended-Q when i manually move those docs back to Work-Q, it
processes without any failure.
For example, if i send 100 POR docs to biztalk using file receive function,
it process 90 docs and moves rest 10 docs to suspended-Q.
Even if i send 50 docs, it process 40-45 docs and rest moves to suspended-Q.
I read a lot of articles and everywhere it says that this can be because of
biztalk settings?
But other docs like SOP, PO docs are working fine.
Can anybody encountered this problem? Can anybody help me in this?
The error message in event log is like this.
==================================
The method "Resubmit" of the WMI class
"MicrosoftBizTalkServer_SuspendedQueue" cannot be executed by the BizTalk
Server WMI provider: Unspecified error.
An error occurred in BizTalk Server.
Details:
------------------------------
[0x1721] The database call failed and returned the following error string:
"Cannot insert the value NULL into column 'nTransportType', table
'InterchangeSQ.dbo.cs_WorkQ'; column does not allow nulls. INSERT fails.".
If possible, we will attempt to retry this call.
[0x171c] The following stored procedure call failed: "{ call cs_resubmit( ?,
?)}".
Thank you in advance.
Ashwani
|