Post to WIP job is failing with ORA-21000

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

The Post To WIP job is failing with the following error in the BG-CA.log.

niku.njs (xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx:Post to WIP) Error executing job: 5079073
com.niku.union.persistence.PersistenceException: 
SQL error code: 21000
Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-21000: error number argument to raise_application_error of 100 is out of range
ORA-06512: at "XXXXXXX.PAC_PRC_POSTTOWIPS_SP", line 601
ORA-06512: at "XXXXXXX.PAC_PRC_POSTTOWIPS_SP", line 601
ORA-06512: at "XXXXXXX.PAC_PRC_POSTTOWIP_JOB_SP", line 201
ORA-06512: at "XXXXXXX.PAC_PRC_POSTTOWIP_JOB_SP", line 201
ORA-06512: at line 1
...
Caused by: java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-21000: error number argument to raise_application_error of 100 is out of range
...

Environment

Release : 15.6.1
Component : CA PPM SAAS APPLICATION

Cause

There was a lot of transactions and they were executed at onetime.

Resolution

Try to separate Post to WIP job.
To decrease transactions by using below parameter of Post to WIP job.



For example, separate Post to WIP job into 4 jobs by using Transaction Type parameter (Equipment, Expense, Labor, Material).