EQ Reports Manager Fails with a SQL Error Message
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."
This error can happen if a transaction has a pagecount too large to be handled by the SQL conversion.
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.