Running Dossiers or Dashboards After Migration Produces the Error, "Document Execution Failed: One or more dataset reports returned an error"

Starting with the release of Strategy ONE (March 2024), dossiers are also known as dashboards.

Description

Attempting to run a dashboard or dossier that’s been migrated via an Object Manager package returns the following error when trying to run the report, “Document Execution Failed: One or more dataset reports returned an error.”
A detailed error message is found in the DSSErrors.log, "Object with ID 'xxxx' and type 26 (Column) is not found in the metadata."

Steps to Reproduce

• Create an Object Manager package with a dashboard/dossier and Add All Used Dependencies.
• Import the Object Manager package into another environment.
• Attempt to run the dossier.
• The following error occurs:
  

• The DSSErrors.log include the error, "Object with ID 'xxxx' and type 26 (Column) is not found in the metadata."

Why is This Happening?

This is a known defect in Strategy 2019 Update 1 and earlier. This defect causes columns to fail to be migrated from one environment to another via Object Manager packages.

Upgrade

Upgrade to Strategy 2019 Update 1 to resolve this issue. Upgrading does not correct existing issues with missing columns, but prevents the error from occurring when migrating new objects.

Workaround

• Migrate the missing column by searching for the column by ID in Object Manager.
  

• Enable Display Managed Objects in the Search Options menu.
  

• To add a column to an Object Manager package, make sure to first include another object, such as a test report (set to Replace), to migrate into the destination environment. The column cannot be added if you do not include another object.
  

• Add the column to the Object Manager package.
  

• Set the test report to Replace and the column to Force Replace.
  

• Migrate the column using the Object Manager package into the other environment. The dossier should now run as expected.