Clarity

Expand all | Collapse all

Rate Matrix Extraction Job Fails

  • 1.  Rate Matrix Extraction Job Fails

    Posted 03-09-2016 06:08 PM
      |   view attached

    Hello,

     

    Five days ago, the Rate Matrix Extraction (Prepare Rate Matrix Data) job started to fail. Please see below for a portion of the error. The full error is in the attached .txt file.

     

    Caused by: java.sql.SQLDataException: [CA Clarity][SQLServer JDBC Driver][SQLServer]Arithmetic overflow error converting expression to data type datetime.

     

    The Rate Matrix Extraction job completes with the following settings checked:

    • Extract Cost and Rate Information for the Scheduler & Update Rate Matrix Data
    • Prepare Rate Matrix Data & Update Rate Matrix Data

     

    The Rate Matrix Extraction job fails with the following settings checked:

    • Extract Cost and Rate Information for the Scheduler & Prepare Rate Matrix Data
    • Extract Cost and Rate Information for the Scheduler,  Prepare Rate Matrix Data & Update Rate Matrix Data

     

    Any help or suggestions on how to troubleshoot this issue is much apprecaited.

     

    Thanks for your help!

    Nemish Patel

    Attachment(s)



  • 2.  Re: Rate Matrix Extraction Job Fails

    Posted 03-11-2016 10:42 AM

    CA PPM Version/Build 14.3.0.298 01 17



  • 3.  Re: Rate Matrix Extraction Job Fails

    Posted 03-11-2016 03:11 PM

    Looking at info on RME in  earlier versions and thinking in writing.

     

    You say

    Looking at TecDoc 439334

    http://www.ca.com/us/support/ca-support-online/product-content/knowledgebase-articles/tec439334.aspx

    In the first case old data is used.

    In the second case the new data is used but not extracted to the scheduler.

    In the third case the data is prepared, but updated and my assumption is that the information extracted to the scheduler is the new data as the Extraction to scheduler fails.

    In the last case the new data is used to prepared and updated and extracted to the scheduled but

    [CA Clarity][SQLServer JDBC Driver][SQLServer]Arithmetic overflow error converting expression to data type datetime.

     

    Either that is a bug or there is a problem with a date field in the matrix

    So go through the dates in the matrix.

    Next check the dates in the tables mentioned below

    See also

    CA PPM Tuesday Tip: Rate Matrix Configuration

    Is it possible that a matrix is not found to be used to the Extraction to scheduler or is there a date that is not in the supported range of dates for the scheduler?

    Eg. 2106 instead of 2016

     

    Five days ago, the job started to fail:

    Can you try to track what was changed again looking at the dates in the matrix.