Error executing stored procedure when attempting to view batch statistics

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. 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.

Filed under PaperVision® Capture, R72.1

Last modified Feb 17, 2011

Submitted Feb 17, 2011

Related Articles

    Share via Email Print