Urgent - Rate Matrix Extraction job failed

book

Article ID: 191731

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction



The Rate Matrix Extraction job is failed with below error. 

Java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-20000: Error in CMN_JOB_RATE_MATRIX_SP - ORA-20000: Error in NBI_PROJ_RATES_AND_COSTS_SP - Calling NBI_PREPARE_MATRIX_DATA_SP: ORA-20000: Error in NBI_PREPARE_PROJ_DATA_SP - : ORA-01422: exact fetch returns more than requested number of rowsORA-06512: at "SJC111P.CMN_JOB_RATE_MATRIX_SP", line 16ORA-06512: at line 1

Cause

This may be caused by changes to the rate matrix.

Environment

Release : 15.4.1

 

Resolution

XOG out matrix and XOG back in.  Or you may need to revert any changes made to the matrix after the last successful completion of the job.