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 monitor
Cause
Such exceptions could be momentarily and might have caused because of extended wait time for record processing
Procedure to fix:
Follow the below steps to reprocess the record.
1) Stop the integration Service
2) Clear the Temp folder where iVend Integration Service is configured
3) Restart the affected machine once.
4) Restart the SQL Server once.
5) Update the integration Service
6) Start the integration Service
7) Retry the failed records from iVend Integration Failure log screen and check.
Related Articles
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 ...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 ...iVend Retail - Report Timeout
iVend Retail – iVend Report (Designer) Timeout Follow the steps mentioned below to set the timeout property in iVend Report Designer: 1. Open the Management Console, go to: Reports > Designer/Label > Report Designer Figure 1 Report Designer 2. Open ...