Views:

Applies to Product - Dynamics 365 Commerce

What’s happening?
  • The 1040 job is not getting applied to the offline database 

 

Reason:

  • The 1040 job failure is attributed to the offline database reaching the size limitation on SQL Server Express.

 

Resolution:
For the 1040 job issue, run database compression on all tables and indexes with the highest sizes. Use the following SQL commands:
ALTER TABLE [ax].<table_name> REBUILD PARTITION = ALL WITH (DATA_COMPRESSION = PAGE)
ALTER INDEX <index_name> ON [ax].<table_name> REBUILD PARTITION = ALL WITH (DATA_COMPRESSION = PAGE)
If the database has exceeded the size limitation, consider deleting the largest indexes causing the issue to create space, then recreate those indexes after running the above compression scripts.