Rollup project job fails with arithmetic overflow error(CP2014)
QUESTION
The resource demand job keeps failing in the step 'Rollup Projects by Fiscal Periods'. The error message is:
ERROR
Arithmetic overflow error for data type smallint
RESOLUTION
Please check for any very long task assignments, e.g. starting in 1984, a date that sometimes is used by Microsoft Project as default start date.
Such assignments result in tasks running for >30 years and this causes the overflow.
These tasks need to be edited and a reasonnable start date needs to be put in.