Error Message

A dtrace run on the Accelerator Service shows the following:

729078 14:18:22.596 [4240] (AcceleratorService) EV-H {-} Exception: Error Production_ReportError Info:{ACCELERATOREVENT.EN_US} {C7.EN_US} An error occurred when producing the Production report. System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.| at System.Data.SqlClient.TdsParser.ReadPlpUnicodeChars(Char[]& buff, Int32 offst, Int32 len, TdsParserStateObject stateObj)| at System.Data.SqlClient.TdsParser.ReadSqlStringValue(SqlBuffer value, Byte type, Int32 length, Encoding encoding, Boolean isPlp, TdsParserStateObject stateObj)| at System.Data.SqlClient.TdsParser.ReadSqlValue(SqlBuffer value, SqlMetaDataPriv md, Int32 length, TdsParserStateObject stateObj)| at System.Data.SqlClient.SqlDataReader.ReadColumnData()| at System.Data.SqlClient.SqlDataReader.ReadColumn(Int32 i, Boolean setTimeout)| at System.Data.SqlClient.SqlDataReader.GetValueInternal(Int32 i)| at System.Data.SqlClient.SqlDataReader.GetValues(Object[] values)| at System.Data.ProviderBase.DataReaderContainer.CommonLanguageSubsetDataReader.GetValues(Object[] values)| at System.Data.ProviderBase.SchemaMapping.LoadDataRow()| at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)| at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)| at System.Data.Common.DataAdapter.Fill(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)| at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)| at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)| at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)| at KVS.Accelerator.Production.ProductionRun.GetChunkedProductionItemsForRun(ExportReportDS reportDS, Int32 productionID, Int32 chunkSize, Int32 chunkNum)| at KVS.Accelerator.Production.ProductionRun.ProduceReport(Int32 ProductionID) Diag: Type:System.Exception ST:
729079 14:18:22.596 [4240] (AcceleratorService) EV-H {PRODUCTIONRUN.EN_US} {C7.EN_US} Finished report for export 1 in 288337ms.
729080 14:18:22.596 [4240] (AcceleratorService) EV-H {TRACETIMER.EN_US} {C7.EN_US} [288s] Timer - Generated report for production id 1
729081 14:18:22.596 [4240] (AcceleratorService) EV-H {-} Exception: Error Common_ProcessingQueueProcessThread Info:{ACCELERATOREVENT.EN_US} {C7.EN_US} An error occured in ProcessingQueue::ProcessQueueThread. System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.| at KVS.Accelerator.Production.ProductionRun.ProduceReport(Int32 ProductionID)| at KVS.Accelerator.Production.ProductionQueue.GenerateReportsQueue_ProcessItem(ThreadSafeQueue& theQueue, Object queuedItem)| at KVS.Accelerator.Common.ProcessingQueue.ProcessQueueThread() Diag: Type:System.Exception ST:

When creating the reports to include journal recipients the distribution list for each message is expanded in order to extract each individual address in the report.  If distribution lists are too large, this can cause out of memory errors when there is too much data for the Accelerator Service to parse.

Reduce the report chunk size in order to free up memory more quickly following the steps below.

1. Launch the Accelerator Client, go to the Configuration tab and click 'Settings.'
2. Expand the "Export/Production" section and locate 'Report Chunk Size.'
3. The default for this setting is 25000. Change this value to 10000 or lower and click the 'Save' button, then restart the Accelerator Service or the Customer Background Task.
4. It may be necessary to lower that setting further if the first change does not resolve the issue.

In the event reducing the report chunk size does not resolve the issue, it may be necessary to reduce the number of production report threads.

1. Return to the "Export/Production" section above and locate 'Number of production report threads.'
2. The default for this setting is 5.  Change this value to 2 and click the 'Save' button, then restart the Accelerator Service or the Customer Background Task.