Rate Matrix Extraction Failing - SQL Server

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

Any Clarity supported release using Microsoft SQL Server database.

Cause

Two environment databases (such as DEV and TEST) 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 those environments.