Forum Discussion

Former_Member's avatar
Former_Member
Accelerator III
9 years ago

Arithmetic overflow error

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

1 Reply

  • eli_donahue's avatar
    eli_donahue
    Community Manager
    9 years ago
    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