Arithmetic overflow error

Former Member
Former Member
Hello, we have been using ARAS for a while now and recently in Project management we have ran into an error: Overflow error in the SUM of the total hours in the "1332 PROJECT NAME" Work Breakdown Structure. The rollup_actual_work property does not allow the SUM of all Activity Time Records to be greater than it's precision. in SQL: exec activity_status_rollup 'E251EE221C4C4FFC8CAE120709DE55B0','E. Europe Standard Time' To solve the issue we have tried to increase precision of decimal  under property rollup_actual_work in itemtype Activity2. This has only caused a new error. Arithmetic overflow error converting numeric to data type numeric. The statement has been terminated. in SQL: exec activity_status_rollup 'E251EE221C4C4FFC8CAE120709DE55B0','E. Europe Standard Time' Has anyone ran into such a problem and know how to fix this? thank you
Parents
  • Hi Eimantas, It's possible that you need to increase the precision even more depending on the rollup value that is getting calculated for your data. Otherwise, you may end up with a scenario where the ratio of "work estimated" to "work completed" is greater than 99.9999. Eli
    Eli Donahue Aras Labs Software Engineer
Reply
  • Hi Eimantas, It's possible that you need to increase the precision even more depending on the rollup value that is getting calculated for your data. Otherwise, you may end up with a scenario where the ratio of "work estimated" to "work completed" is greater than 99.9999. Eli
    Eli Donahue Aras Labs Software Engineer
Children
No Data