[22003] SQL call failed. Arithmetic overflow error converting int to data type numeric. The statement has been terminated.
Article ID: KB0071790
Updated On:
| Products | Versions |
|---|---|
| TIBCO Scribe Insight | - |
Description
This error comes in the MS SQL when try to store an out-of-range floating point value into a numeric variable. For example, if your NUMERIC or DECIMAL variable is defined as NUMERIC(5,2) then the maximum value it can hold is 999.99, if try to store something like 1000.00 then it will throw "Arithmetic overflow error converting numeric to data type numeric". The common reasons for this error are the misconfiguration of the NUMERIC data type.
Issue/Introduction
This article helps to resolve the error: [22003] SQL call failed. Arithmetic overflow error converting int to data type numeric. The statement has been terminated. When it tries to insert the records into SQL table but due to misconfiguration in data definition of the field getting this transaction error.
Resolution
It needs to re-verify the source of value, correct if needed or increase the precision level of the column on the MS SQL side.
Based upon the above example, it requires increasing the width of the variable to store number e.g. NUMERIC(6,2) will solve this error.
Based upon the above example, it requires increasing the width of the variable to store number e.g. NUMERIC(6,2) will solve this error.
Feedback
Yes
No
Powered by
