AnsweredAssumed Answered

CA PPM  - Job 'Rate Matrix Extraction' is failing

Question asked by pradeepdsingh on Jan 15, 2018
Latest reply on Jan 25, 2018 by pradeepdsingh

CA PPM  - Job 'Rate Matrix Extraction' is failing

 

 

Hi

 

Job 'Rate Matrix Extraction' is failing with below error.

 

Any idea why is it failing.

 

Please let me know if any team has faced the same issue.

 

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 rows ORA-06512: at "US2917P.CMN_JOB_RATE_MATRIX_SP", line 15

 

 

 

-Pradeep

Outcomes