"Post to WIP" job fails due to out of range error

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Post to WIP job consistently fails with below error

ERROR YYYY-MM-DD hh:mm:ss,156 [Dispatch Post to WIP : [email protected] (tenant=clarity) (BG Job Thread)] niku.njs (clarity:xxxyyyzzz:4875847XX-SB76-XXXYYY-Z1Z1\:Post to WIP) () Error executing job: 7777777XX
com.niku.union.persistence.PersistenceException:
SQL error code: 21000
Error message: ORA-21000: error number argument to raise_application_error of -1 is out of range
ORA-06512: at "NIKU_TEST.PAC_PRC_POSTTOWIPS_SP", line 988
ORA-06512: at "NIKU_TEST.PAC_PRC_POSTTOWIP_JOB_SP", line 195
ORA-06512: at "NIKU_TEST.PAC_PRC_POSTTOWIP_JOB_SP", line 195
ORA-06512: at line 1

Environment

v16.4.1

Cause

Termination dates for all active resources are incorrect.

Resolution

Update the termination date appropriately and execute the job.