The BizTalk Server SAP adapter stops receiving IDOC messages in BizTalk Server

Consider the following scenario. You are using Microsoft BizTalk Server. You send an IDOC message. An IDOC message is an intermediate SAP document from the SAP system to the server that is running BizTalk Server. The BizTalk Server SAP adapter stops receiving IDOC messages, and the following error may be logged in the event log:

Error in Check Transaction: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Additionally, BizTalk Server receives the IDOC messages if the BizTalk Server host is restarted or if the blocking process on the server that is running Microsoft SQL Server is killed.

This problem occurs because the index on the SAPTid table that is used by the BizTalk Server SAP adapter is not available.

To work around this problem, the index for the SAPTid table must be created. Ask the database administrator to run the following SQL script in the MessageBox database.