CA PPM: Load Data Warehouse (ETL) job fails with error in domain update

Document ID : KB000005058
Last Modified Date : 06/06/2018
Show Technical Document Details
Issue:
We are getting an error similar to what appears in the BG-dwh logs.
 
Environment:

CA PPM 14.3+

Cause:
ERROR 2016-11-25 12:31:10,830 [Dispatch 25 Load Data Warehouse : bg@[server] (tenant=clarity)] kettle.JasperSoftDomainUpdates (clarity:admintest__50F61B9C-3D33-4EEF-AEED-04FB677D5BD1:25 Load Data Warehouse) Error occurred while processing domain attributes. com.ca.jasper.restAdapter.JasperException: Could not update attribute business_owner_key of object idea to domain CSK_IDE_Management

ERROR 2016-11-25 12:31:10,830 [Dispatch 25 Load Data Warehouse : bg@[server](tenant=clarity)] niku.njs (clarity:admintest__50F61B9C-3D33-4EEF-AEED-04FB677D5BD1:25 Load Data Warehouse) Error executing job: 6231661

com.ca.jasper.restAdapter.JasperException: Could not update attribute business_owner_key of object idea to domain CSK_IDE_Management

at com.ca.clarity.etl.kettle.JasperSoftDomainUpdates.updateAttrObjNameInDomain(JasperSoftDomainUpdates.java:447)

at com.ca.clarity.etl.kettle.JasperSoftDomainUpdates.processDomainUpdateAttributes(JasperSoftDomainUpdates.java:355)

at com.ca.clarity.etl.kettle.JasperSoftDomainUpdates.dynamicDomainUpdates(JasperSoftDomainUpdates.java:167)

at com.ca.clarity.etl.kettle.DataWareHouseKettleJob.postProcess(DataWareHouseKettleJob.java:109)

The Load Datawarehouse (ETL) job fails with variations of the error, depending on the object.
Error occurred while processing domain attributes. Could not update attribute [xxxxx] of object xxxxx to domain xxxxx


 

Resolution:

This error is indicative of PPM vs DWH schema synchronization issue where the ETL job completes but the domain could not get updated.

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

For For CA PPM 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