AnsweredAssumed Answered

Rate Matrix Extraction Job Fails

Question asked by nemish.patel.resourceit on Mar 9, 2016
Latest reply on Mar 11, 2016 by urmas

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

Outcomes