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.
Release : 15.8.1
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.
If you are sharing a db host make sure the jobs run at different times on the two environments.