How to fix : Arithmetic overflow error converting numeric to data type numeric.


Please check below mentioned error:

Hi Amit,

The conversion is failing as it looks like you're trying to cast / convert a number, pretty big number to the small allowed window.

Basically the decimal(p,s) and numeric(p,s) both specify a Precision and a Scale. Check what are the limits in your data model and what conversion is happening with this operation.

You may solve the issue by adjusting the size of Scale or precision (depends, what is causing error).

iamuramit wrote:


Please check below mentioned error:

Hi ,

    Are you using any sql QUERY CONVERSION  of integer to numeric datatype or else it been a expreesion overflow error of outsystems.

Refer This if its related to you issues or else, Please explain query in detail manner