ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Post to WIP job is failing with ORA-21000

book

Article ID: 145458

calendar_today

Updated On:

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
...

Cause

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

Environment

Release : 15.6.1
Component : CA PPM SAAS APPLICATION

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).

Attachments