Snow Data Update Job fails with the error "Could not complete cursor operation because the table schema changed after the cursor was declared"

The Data Update Job (DUJ) is failing with the following error:

"Could not complete cursor operation because the table schema changed after the cursor was declared"


 

• All database index maintenance should be performed outside of the Data Update Job runtime window or as a custom procedure called from within the Data Update Job. 
• If an Index Maintenance job kicks off that will update indexes on the SnowLicenseManager database while the Data Update Job is running, request that the index maintenance job be stopped until the DUJ has completed.

• This can be caused when an Index Maintenance job is running at the same time as the DUJ.
• Any time an index is rebuilt or reorganized, this is considered a table schema change. 
• If a step in the DUJ is inserting, deleting or updating rows in a table while any index is being rebuilt or reorganized, a SQL error will be thrown indicating that the table schema changed.