Clarity

  • 1.  CA PPM  - Job 'Rate Matrix Extraction' is failing

    Posted Jan 15, 2018 12:14 PM

    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



  • 2.  Re: CA PPM  - Job 'Rate Matrix Extraction' is failing

    Posted Jan 16, 2018 12:19 AM

    I guess, you should check the ppa_matrix and ppa_matrix_values tables - error might be due to duplicate data

     

    NJ



  • 3.  Re: CA PPM  - Job 'Rate Matrix Extraction' is failing

    Posted Jan 18, 2018 10:53 AM

    we have a lot of matrix records ; how can we identify duplicate data in the tables ? do we need to check specific columns of table if yes then can you please share list of columns of 2 tables ... 



  • 4.  Re: CA PPM  - Job 'Rate Matrix Extraction' is failing

    Posted Jan 24, 2018 01:57 AM

    Hi pradeepdsingh ,

     

    Could you confirm the parameters you have selected on execution of the Rate Matrix Extraction Job?

    Or can you give a try by executing the job and selecting the below parameters.

     

    Regards

    /Shubham



  • 5.  Re: CA PPM  - Job 'Rate Matrix Extraction' is failing

    Posted Jan 25, 2018 01:47 PM

    It failed.

     

    Regards

    Pradeep Kumar Singh

     

    RICOH USA, INC

    70 Valley Stream Parkway, Malvern, PA 19355

    Work: (610) 382 6114

    Email: pradeepkumar.singh@ricoh-usa.com