cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
s1hl3_ukuvuma
Level: Powered On

Microsoft SQL Arithmetic overflow error

Hi @RandyHayes 

 

When I save a record  with a number text input that has 6 digits or more I get an error message:

Microsoft SQL Arithmetic overflow error converting numeric to data type.

 

The Char on SQL is 50. so I have not exceeded the character limit. 

 

any ideas?

6 REPLIES 6
Super User
Super User

Re: Microsoft SQL Arithmetic overflow error

@s1hl3_ukuvuma 

Can you provide the formula that is causing the error, or some screenshots to see what is going on?

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
s1hl3_ukuvuma
Level: Powered On

Re: Microsoft SQL Arithmetic overflow error

@RandyHayes  see attached

Super User
Super User

Re: Microsoft SQL Arithmetic overflow error

@s1hl3_ukuvuma 

Your problem is that you are trying to convert a text value into a value to then have it convert back to a character value for the field.

Remove the Value function from around the TotalCapexAmount_value.Text and try it again. There is no need (from what I see) to do that conversion. 

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
s1hl3_ukuvuma
Level: Powered On

Re: Microsoft SQL Arithmetic overflow error

@RandyHayes  The conversion is needed as when i remove the value conversion, it says the value not a text is expected.

 

remember that it works, and only returns the error when I exceeed 5 digits but it accepts anything less.

Super User
Super User

Re: Microsoft SQL Arithmetic overflow error

@s1hl3_ukuvuma 

So then your TotalCapexAmount_value is defined as numeric and not text...that's fine.  How is that field defined exactly in the DB?  

The Value function does have a maximum and then it starts to round up and down, but from a character perspective, that is about 16 characters - so, that's not where the problem is coming from.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
DavidJennaway
Level: Powered On

Re: Microsoft SQL Arithmetic overflow error

It sounds like you need to increase the precision of the data-type in SQL. In SQL, numeric (and decimal) data types have a definable precision (total number of digits, including decimal places) and scale (number of decimal places) - see this

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

Users Online
Currently online: 336 members 3,660 guests
Please welcome our newest community members: