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)

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.

UPDATED: June 03, 2021