Rate Matrix Extraction Failing - SQL Server
search cancel

Rate Matrix Extraction Failing - SQL Server

book

Article ID: 201781

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

Rate Matrix job is failing with the following error message:

ERROR 2020-09-30 22:01:10,810 [Dispatch Rate Matrix Extraction - Full : bg@SomeServer (tenant=clarity)] niku.njs (clarity:SomeUser:182__23291D6F-5272-4F3B74E:Rate Matrix Extraction - Full) Error executing job: 5140048
com.niku.union.persistence.PersistenceException: 
SQL error code: 16943
Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]Could not complete cursor operation because the table schema changed after the cursor was declared

Environment

 

 

Cause

Two environment databases such as dev and test are sharing the same DB host and the job running at the same time on both environments.

Resolution

If you are sharing a DB host, make sure the jobs run at different times on the two environments.