Views:

Applies to Product - Dynamics 365 Lifecycle Services


What’s happening?
The customer is unable to create a database backup as the process keeps rolling back, resulting in an error message indicating missing files or unresolved references in the database schema.
 

Reason:
This is related to missing database objects or unresolved references in the schema, which prevent the successful export of the database. Specific errors include references to objects that do not exist or are ambiguous.
 

Resolution:

  1. Check for Missing Objects: Verify if the objects referenced in the error logs exist in the database. If they do not exist, create them or correct the references.
  2. Correct the Schema: Address any unresolved references in the views, such as [DBO].[PWIFPACKAGING_SHARINGVIEWWITHUNIQUEID]. Ensure that all referenced objects are correctly defined in the database.
  3. Perform Full DB Sync: Enable and disable maintenance mode to perform a full database synchronization, which may add any missing columns to the tables.
  4. Retry the Export: After making the necessary corrections to the schema and ensuring all objects are present, attempt to create the database backup again.
  5. Direct Database Access: If the export continues to fail, consider accessing the database directly until a permanent solution for the export issue is found.
If the issue persists after following these steps, further investigation may be required to analyze telemetry and logs for additional insights.