Microsoft KB Archive/331337

= Must Restart the Interchange COM+ Application After a Connection Loss to SQL =

Article ID: 331337

Article Last Modified on 12/19/2002

-

APPLIES TO


 * Microsoft BizTalk Server 2002 Standard Edition

-



This article was previously published under Q331337



SYMPTOMS
After a connection interruption between the computer that is running BizTalk Server and the computer that is running Microsoft SQL Server, you may receive the following error message when you call IInterchange::Submit:

An error occurred in BizTalk Server.

Details: --

The following stored procedure call failed: &quot; { call adm_cache_loadTimeStamp( ?, ?, ?, ?, ?, ?)}&quot;. :'[DBNETLIB][ConnectionWrite (send).]General network error. Check your network documentation.' Unspecified error

The configuration data from the database could not be reloaded.

There was a failure creating the internal work item. Make sure that SQL Server is running.



CAUSE
The Interchange application caches its connection information until it is restarted or a failure occurs.



RESOLUTION
To resolve this issue, identify and correct the cause of the connection interruption.



WORKAROUND
To work around this issue, you may be able to build error routines to trap this error and resubmit the initial failed submission, depending on your submission method. Only the initial submission after the connection interruption will fail, and then the connection will be re-established.



STATUS
This issue is by design.

Keywords: kbprb KB331337

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.