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