Data Update Job (DUJ) fails logging the following:

Error #16943 in procedure dbo.ApplicationRuleApply line 334. Exception Rule ID: 44CAE310-9580-45A6-A4CE-5C0BC97C1A45.  [Could not complete cursor operation because the table schema changed after the cursor was declared.]

• Snow License Manager Production.

Run the queries below on SQL server Snow License Manager Database to view the DUJ status and any Errors:

Ensure that the Index Maintenance jobs are scheduled to run outside the DUJ run time.

The rebuilding indexes and statistics in Snow Inventory should be undertaken before the Data Update Job is scheduled to start and Snow License Manager after each Data Update Job. This is due to indexes being required when reading from the databases and should be updated after writing to the database. As the duration of the Data Update Job can vary, we recommend performing the Snow Inventory index maintenance before the Data Update Job runs to make the necessary index rebuilds and updates to allow these to complete prior to the Data Update Job starting.

Refer to Best Practices for Index Maintenance for more information.

For information regarding Ola Hallengren SQL-Server index maintenance strategies, please review the documentation for the specific version of SQL Server installed: https://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html .This third-party solution is one that needs careful consideration and configuration specifically for each SQL Server environment. Ensure the system owner / DBA has a Maintenance plan in SQL server to set up to maintain the index for all Snow databases. 

Rebuilding indexes is considered a table schema change and if this occurs at the same time when the Data Update Job is running , SQL error will be displayed as the data cannot be updated simultaneously.