You’re offline. This is a read only version of the page.
34
Hi, 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:
Share
ReportDateAdd(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!
Perhaps it might be an option to refresh on minutes rather than seconds. I notice in your link that seconds processes can affect the date, whereas adding seconds will not affect the date. Also the seconds doesn't work off decimal? It needs to be an integer.
There is no 1.5 seconds, you get 1 or 2. now you can calculate milliseconds but that also works in integer only.
if this solves your issue please accept solution.
#1
mmbr1606
22
Super User 2025 Season 1
#2
stampcoin
19
#3
Michael E. Gernaey
15
Super User 2025 Season 1
All responses (
Answers (
