Resolve System.Data.OleDb.OleDbException (0x80040E31): Query timeout expired error when batch processing in SendSuite Live
Learn how to resolve the error "System.Data.OleDb.OleDbException (0x80040E31): Query timeout expired" when batch processing in SendSuite Live.
Products affected: SendSuite® Live
Issue
When processing a batch in SendSuite® Live, it fails after 30 seconds and displays the following error:
System.Data.OleDb.OleDbException (0x80040E31): Query timeout expired
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
at Pierbridge.ProjectsServer.Services.Query.XMLSelectData(Int32 dataSourceID, String xmlSchemaName, String userName, StringCollection parameterNames, StringCollection parameterValues)
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
at Pierbridge.ProjectsServer.Services.Query.XMLSelectData(Int32 dataSourceID, String xmlSchemaName, String userName, StringCollection parameterNames, StringCollection parameterValues)
Cause
The system has a hard-coded timeout value of 30 seconds.
Resolution
The batches need to be made smaller in order for the processing to complete within 30 seconds.
Contact software support for assistance.
Contact software support for assistance.
UPDATED: June 03, 2021
Contact Us
Live Chat
Available • Closes at 8pm ET
Sales team hours are 8am-6pm ET
Sales team hours are 8am-6pm ET
Live Chat
Live Chat is currently unavailable.
Chat is available Mon-Fri, 8am-8pm ET
Chat is available Mon-Fri, 8am-8pm ET
Create a case
Submit support requests
(Sign in required)