Clarity

Expand all | Collapse all

Rate Matrix Extraction job Error

  • 1.  Rate Matrix Extraction job Error

    Posted 01-29-2019 10:33 AM

    Hi, 

    Rate Matrix Extraction job has been errored out with below error. Recently we are receiving this error. Can you please help me what can I do to fix the error?

     

    We are using Clarity 7.5 version. 

     

    Error: 

    Stored Procedure application error java.sql.SQLException: ORA-20000: Error in CMN_JOB_RATE_MATRIX_SP - ORA-20000: Error in NBI_PROJ_RATES_AND_COSTS_SP - Performing project-related activities, inserting rows associated with the specific assignments: ORA-01555: snapshot too old: rollback segment number 10 with name "_SYSSMU10$" too small ORA-06512: at "NIKU.CMN_JOB_RATE_MATRIX_SP", line 12 ORA-06512: at line 1


  • 2.  Re: Rate Matrix Extraction job Error

    Posted 01-29-2019 10:41 AM

    This is a Oracle configuration issue and you should consult your DBA. See few resolution from oracle Troubleshooting ORA-1555 (Doc ID 1307334.1) | Oracle DB/EM Support Blog