IBM Support

Arithmetic overflow error converting expression to datatype int.

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.

[{"Product":{"code":"SSTQPQ","label":"IBM Cognos Series 7 PowerPlay"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Impromptu","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"Impromptu 5.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Historical Number

76121

Document Information

Modified date:
15 June 2018

UID

swg21353945