Forum Orisinil

OtomaX - Orisinil Topup Machine => OtomaX International => Topic started by: Thiagarajan on March 07, 2014, 07:20:53 PM

Title: Arithmetic overflow error
Post by: Thiagarajan on March 07, 2014, 07:20:53 PM

Trx Error #5: Arithmetic overflow error for data type smallmoney, value = 243525.
The statement has been terminated.

When Reliance Rs.255 and Rs.349 and more value recharge id done come this type of error

how to solve this error

[attachment deleted by admin]

Title: Re: Arithmetic overflow error
Post by: Yusuf on March 08, 2014, 08:47:12 AM

You need to change the data-type of all smallmoney columns on transaksi table. Use SQL Server Management Studio (SSMS) to change those column's datatype to money instead of smallmoney.

Title: Re: Arithmetic overflow error
Post by: Thiagarajan on March 08, 2014, 03:54:33 PM

Dear Yusif,

I cant understand but more loss to me last 3 days of reliance product

Title: Re: Arithmetic overflow error
Post by: Yusuf on March 08, 2014, 04:03:44 PM

Please contact your seller or Hariyanto for fast technical support.

You can find the contact person here: http://forum.orisinil.com/index.php/topic,8617.0.html

Hope you will get solution ASAP.

Title: Re: Arithmetic overflow error
Post by: yogesh on March 14, 2014, 01:52:11 AM

hello sir when change small money instead money then harga_beli and saldo all price is change to hiher vaule.
after that not proper check daily report or sale.if we do recharge rs.29 and i set price 0.995 and sell price is 1.00 then value i want to come this 28.855 but value comes 28,855.00 this higher now tell me solution sir i m in very trouble.


[attachment deleted by admin]

Title: Re: Arithmetic overflow error
Post by: Yusuf on March 15, 2014, 09:23:29 PM

Are you using version 3.3.8? If problem still persists, please try to use version 3.3.7.

Thank you.