search cancel

Datamart Extraction Job failed after the upgrade to 16.0.2

book

Article ID: 243105

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

The datamart extraction job failed after we upgraded to 16.0.2 with error:

PMD application error java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-20000: Error in NBI_EXTRACT_SP - Calling NBI_EXTR_RF_SP: ORA-20000: Error in NBI_EXTR_RF_SP - SELECTING PROJECTS COUNT: ORA-20000: Error in NBI_RF_SP - DONE DROPPING INDEXES: ORA-01426: numeric overflowORA-06512: at "NIKUDBA.NBI_EXTRACT_SP", line 362ORA-06512: at line 1

Cause

This may be caused by some bad values in the curves.

Environment

Release : 16.0.2

Component : Clarity Financial Management

Resolution

If after trying the job a few times and still failing 

Run the job in the following sequence

  • Time slice sync
  • Time slice
  • Rate matrix extraction 
  • DataMart extraction job|
  • Recreate the indexes on NBI_R_FACTS .

Restart the app and BG after the above steps