Troubleshooting
Problem
DMS-E-GENERAL, a general exception error has occurred during operation attach database arithmetic overflow error converting expression to datatype int. DMS-E-GENERAL, a general exception error has occurred during operation attach database General SQL server error: Check messages from the SQL Server.
Resolving The Problem
This will occur if you are using an expression to convert a value into an integer and somewhere in the column there is an invalid digit, such as a letter or symbol.
The expression may not necessarily be in the report, although it is the first place to look. It could be in a view that the report calls upon. In this case, the error may be from the SQL in that view. In either cases, it is recommended to resolve the data problem in the database by doing a report against the column that you are converting and filter out only the numeric values 0,1,2,3,4,5,6,7,8,9 and see what you are left with. Also, check the SQL Server log for more
info.
Historical Number
76121
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21353945