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