System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. Records not integrating

Environment

iVend 6.5 update 6 with SAP B1 9.2

Problem Statement

2 records not integrating from iVend to SAPB1 and showing not processed constantly 

Issue Details

The customer was facing an error at integration and 2 records not integrating they were coming up with the message shown below and we retried but they continuously appeared in the integration failure monitor as well.

System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out

Resolution/Work Around

We informed the customer to shrink & optimize both database CXSIntegration & iVend HO Database in customer downtime after taking backup of an existing one. After that, retry the events from iVend to SAPB1.

Recommendations /Suggestion

Shrink/Optimize the CXSIntegration/ iVendEnterprise database and need to update the Integration services well.

• Related Articles

• System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired

  Problem Statement Getting an error message "System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding." in the iVend integration failure ...

• System.Data.SqlClient.SqlException (0x80131904) Error converting data type nvarchar to numeric.

  Environment: iVend Retail 6.6 7989 With SAP B1 10.0 Problem statement: iVend Optical Product Master Created in SAP Business, however those failed stuck in integration failure log from SAP To iVend with below error. System.Data.SqlClient.SqlException ...

• Integration Err System.Data.SqlClient.SqlException (0x80131904): Error converting nvarchar data type

  Product Version: 6.5 Update 6 Patch2 Problem Statement Incident ID - INC0012326 - Warehouse events stuck on Integration Failure Monitor from SAP to iVend with error message System.Data.SqlClient.SqlException (0x80131904): Error converting nvarchar ...

• How to Resolve Timeout Expired Error

  How to Resolve Timeout Expired Error This knowledge base article will assist you in resolving the Timeout Expired error, which is a common error that occurs in .IRT extension type reports (iVend Retail Report Designer reports). Going through this ...

• The Integration service is getting time out while integrating the data in SAP (cloud)

  Environment: iVend 6.6 Cloud Problem Statement: The Integration service is getting time out while integrating the data in SAP (cloud) Symptoms: The records were showing time out while integrating the records in SAP from iVend. Resolution/Work Around: ...