Error executing stored procedure when attempting to view batch statistics

Product: PaperVision Capture

Last modified: September 21, 2022

Submitted: February 17, 2011

Version: R72.1

Article ID: PC000049

Error executing stored procedure when attempting to view batch statisticsmain image

Find what you need

Filed under:

Description

The database table that stores batch statistics can grow considerably large in a short amount of time. If this table grows too large, an error may be thrown executing the stored procedure used to retrieve these statistics.

Summary

When the batch statistics table grows too large, there are several potential resolutions:

  1. Use the “Filters” available in batch statistics to limit the report to only the information that is needed. This reduces the amount of data that needs to be returned.
  2. Reduce the amount of batch information being held in the system. This is done by scheduling Batch Destructions and choosing the option to not retain statistics. Capture installations should employ routine procedures for deleting out-of-production batches and statistics.
  3. The SQL query used to retrieve these statistics may timeout, causing an error executing the stored procedure. This causes a SQL timeout. To resolve this issue, the query timeout must be increased.

Follow these steps to increase the SQL query timeout:

  1. Open C:\Program Files\Digitech Systems\PaperVision Capture\appSettings.config in Notepad. On a 64-bit OS - C:\Program Files (x86)\Digitech Systems\PaperVisionCapture\appSettings.config
  2. Add the following right below the first line: <add key="dbTimeout" value="600" />
  3. Save the file, close Notepad, and restart the PaperVision Capture Administration Console.