View Only
  • 1.  Rate Matrix Extraction job Error

    Posted Jan 29, 2019 10:33 AM


    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. 



    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

    Broadcom Employee
    Posted Jan 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