Arithmetic overflow error when accessing budget for editing

There is a limit of 99,999 hours of effort and time that can be entered for a single task assignment. The Changepoint interface prevents users from entering amounts that exceed 99,999.

However, in a budget that has "replace past with actuals" option enabled, the actual effort for a single task assignment can be increased over the limit by the overnight system update that updates the budget data. The result is a "DataPortal.fetch failed (Arithmetic overflow converting numeric to data type numeric)" when you try to access the budget for editing.

Workaround

1. Desubmit the hours that amount to > 99,999 and remove them on the time sheet. If these hours had been entered to show accumulated historical effort, you can split them over multiple assignments to ensure that no single task assignment exceeds 99,999 hours. 
2. Do one of the following:

• If the "replace past with actuals" option is enabled on the budget, then the budget will automatically be adjusted by the next day, after the system update has run overnight.
• If the "replace past with actuals" option is not enabled on the budget, you must run "replace past with actuals" manually on the SQL Server by executing the command:

Exec BU_ReplacePastWithActuals '<budgetid>', 0x0