594
Views
4
Comments
How to fix : Arithmetic overflow error converting numeric to data type numeric. 
Question

Sir,

Please check below mentioned error:





Champion
Rank: #106

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.

Champion
Rank: #106

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

Rank: #9250

iamuramit wrote:

Sir,

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

https://www.codeproject.com/Questions/367195/Arithmetic-overflow-error-converting-numeric-to-da

https://success.outsystems.com/Documentation/11/Reference/Errors_and_Warnings/Errors/Expression_Overflow_Error


Thanks 

soundarya


Rank: #590


Your problem can be fixed by defining the "Lenght" property of your attribute to be greater than "Decimals" property since you must have always the whole-number part of your decimalThe whole-number part 

Don't forget to mark an answer as correct so we can help the community to find a solution faster.