Share
Report
34Hi, hoping someone can help with this error I'm receiving on a dataverse table:
Sql error: A SQL arithmetic overflow error occurred...
I've traced the error to a Formula column (the new type). The column formula is:
DateAdd(Refresh_Start, Typical_RefreshTime, TimeUnit.Seconds)Refresh_Start is a Date/Time column, Typical_RefreshTime is a Decimal number column. This was working fine until tonight, I went to change the value in a record for Typical_RefreshTime from 660 to 1080, and then the table fell over and couldn't load, per error above. After getting the table back working by editing the formula (changed Typical_RefreshTime to 10, then changed it all back to as it was) I started trying different amounts to see what it's breaking point was. It turned out to be 822 obviously 🤨. Have I discovered the limits of DateAdd when it comes to adding seconds or is it because I'm not using an integer and 822 is the limit to it's decimal truncating skills? I found this link which may explain it, if I understood what it meant!
Any help greatly appreciated!
All responses (
Answers (
