Post To WIP job fails

book

Article ID: 36526

calendar_today

Updated On:

Products

CLARITY PPM FOR ITG CLARITY PPM FEDERAL Clarity PPM On Premise

Issue/Introduction

Problem:  

The Post To WIP job is failing with the following error in the BG log:  

niku.njs (clarity:admin:42311161__E6C3FE52-511A-48E6-9FE4-EC842DD98730:Post Transactions to Financials) Error executing job: 1031 error java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-20878: -20669 - ORA-20669: -20669 - ORA-20669: ORA-01400: cannot insert NULL into ("CLARITY"."PPA_TRANSCONTROL_VALUES"."NATURAL_BILLRATE") ORA-06512: at "CLARITY.PAC_IMP_NPMTRANSIMPORT_SP", line 101

This issue could also occur if attempting to use the page for 'Post to WIP' and you may see an error message on the screen or in the APP log file.

Cause:  

This error occurs because the Post To WIP job will access the real-time rate matrix definition in order to calculate the actual cost of the transaction. When it encounters an invalid value, it will throw the error.

Resolution:  

  1. Run the query:  select * from PPA_MATRIXVALUES where numval1 is null  
  2. If results are returned, the null values will need to be updated with valid rates in the application  
  3. Within the application, locate and update the rate matrix rows containing the null values and save the changes  
  4. Run the Post To WIP job to have the transactions processed correctly  

 

Environment

Release: ESPCLA99000-14.3-Clarity-Extended Support Plus
Component: