Skip to main content
Kofax

EQ Reports Manager Fails with a SQL Error Message

Problem statement

When running some EQ reports, the EQRptMgr will crash with the following error message:

"the query failed because of this error:[Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic overflow error converting expression to data type int."

When running the report query directly in SSMS, the following error is shown:

"Msg 8115, Level 16, State 2, Line 1

Arithmetic overflow error converting expression to data type int.

Warning: Null value is eliminated by an aggregate or other SET operation."

Cause

This error can happen if a transaction has a pagecount too large to be handled by the SQL conversion.

Resolution

Have a DBA run a script to look for transactions with a large page count = 2147483647 (which is binary 1111111111111111111111111111111). In one particular instance, the problem was with newly added MFPs that were incorrectly configured to track sent faxes. After removing these transactions from the eqcas database; and, the MFP technician correcting the MFP configuration, the EQ Reports all run without error.