Rate Matrix Extraction Failing - SQL Server

Products

• Clarity PPM On Premise

Issue/Introduction

Rate Matrix job is failing with error

 

ERROR 2020-09-30 22:01:10,810 [Dispatch Rate Matrix Extraction - Full : [email protected] (tenant=clarity)] niku.njs (clarity:admin:16510882__23291D6F-5272-44AC-BCB4-254FDDF3B74E:Rate Matrix Extraction - Full) Error executing job: 5146048
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

......

Caused by: java.sql.SQLException: [CA Clarity][SQLServer JDBC Driver][SQLServer]Could not complete cursor operation because the table schema changed after the cursor was declared.

Environment

Release : 15.8.1

 

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.