Clarity PPM: Load Data Warehouse job fails with error in domain update

Document ID : KB000005058
Last Modified Date : 06/06/2018
Show Technical Document Details
Issue:
We are getting variations of an error in the BG DWH logs:
Error occurred while processing domain attributes.
 
Cause:

The job can fail with variations of the error depending on what object it fails on first.

Error occurred while processing domain attributes. Could not update attribute [xxxxx] of object xxxxx to domain xxxxx
OR
Error occurred while processing domain attributes. Resource /ca_ppm/domains/CSK_PRJ_Management_files/schema.xml not found.

 

Resolution:

Since the error is indicative of a PPM vs DWH schema synchronization issue where the ETL job completes but the domain could not get updated, the following steps can be performed.

For versions 15.2.0.3 and below, run the command: admin content-jaspersoft csk restoreDomains -userName superuser -password 'XXXXXX’

For versions 15.2.0.3+, run the Restore Domains job from the Reports and Jobs page.
 

Additional Information:

Note: The details about the command and various Jaspersoft commands can be found in:

https://comm.support.ca.com/kb/list-of-jaspersoft-commands-in-accordance-with-ca-ppm-version/kb000009869