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
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
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