7

Currently, SQL operations (ex : index rebuild) executed by the automation on business hours conflict with batch jobs / data entities, resulting with below error message :

[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Could not complete cursor operation because the table schema changed after the cursor was declared.


This Issue causes lots of manual actions to fix incomplete data (monitoring, data verification, relaunching batch jobs...).


Therefore, I would like to suggest to either fix this Issue so that no cursor is lost while automation is running or to run automation outside business hours.

Category: Data Management
STATUS DETAILS
New