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 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.

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.

Environment

Release : 15.8.1

 

Resolution

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