NOW-DSC-DOMAIN_DATA_INVALID_PATH_TABLES

NOW-DSC-DOMAIN_DATA_INVALID_PATH_TABLES Severity Error Root Cause Identifies data with invalid paths.

If a domain is deleted in such a way that it changes the hierarchy of the data tables that reference that domain, the domain validator will run and make corrections to the paths in any table that referenced that domain or had that domain in its path. If the appropriate correction has not yet been made to the data table to account for the new domain, queries that use the path to retrieve the data records will not be retrieved as expected.

Effect Any domain-specific operation involving a domain-aware table that contains records with an invalid path will not be able to see those records. Follow the steps below:

Determine which of the two attached scripts you will need: To validate table data and fix any inconsistencies: Validate_and_Fix.txt To simply validate data without fixing inconsistencies: Only_Validate.txt Ensure that you are in the global domain. Navigate to System Maintenance > Scripts - Background. Cut the script from the attachment file and paste it into Scripts - Background. Locate the TODO comment in the script code. On the line below the comment, replace INSERT_TABLENAME_HERE with the name of the domain-separated table on which to run the script. Click the Run script button. The script is complete when you see a message that will start with either: Data validation successful

or

Data validation unsuccessful