Skip to main content
Planview Customer Success Center

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.