Hello.
I added a new column to a table and I made a reference to another table. And when I tried to add a value in the column I received this error.
Solved
Arithmetic overflow erroe
+1- Vanguard
- 24 replies
Best answer by Robbert van Tongeren
In that trigger (goods_receipt_line_tu) on line 47, there is something that cannot be converted to a int. That is the location you should be looking at.
I would guess the problem is that the INT you are tying to insert is getting larger then 2147483647, which is the maximum for an int. If you need to go bigger you should be using a BIGINT.
Or maybe the calculation for adding up is not correct which results into a large number.
This topic has been closed for comments
Can you expand the error by clicking on the blue arrow in the bottom left corner?
And can you also open up the developer tool → debug and show that screen as well?
Can you check in your upgrade trigger of good receipts line on line 47?
Can you check on the database it self?
I do think you have a update trigger on the “goods_receipt_line” :)
In that trigger (goods_receipt_line_tu) on line 47, there is something that cannot be converted to a int. That is the location you should be looking at.
I would guess the problem is that the INT you are tying to insert is getting larger then 2147483647, which is the maximum for an int. If you need to go bigger you should be using a BIGINT.
Or maybe the calculation for adding up is not correct which results into a large number.
+1- Vanguard
- 24 replies
It was something wrong with the trigger, thank you! 😊
Kind regards, Elena Todirenchi
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.