CA PPM Load Data warehouse Job failing while updating domains

Document ID : KB000005058
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

CA PPM Load Data warehouse Job failing while updating domains 

Environment:
CA PPM and above
Cause:

Please take a look at BG-DWH log and if you see the below error 

 

ERROR 2016-11-25 12:31:10,830 [Dispatch 25 Load Data Warehouse : bg@VDA1CS3231 (tenant=clarity)] kettle.JasperSoftDomainUpdates (clarity:N389170:47891097__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@VDA1CS3231 (tenant=clarity)] niku.njs (clarity:N389170:47891097__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)

 

Resolution:

Please run the command below 

 admin content-jaspersoft csk restoreDomains -userName superuser -password 'XXXXXX’

 

Additional Information:

Note: The details about the command and various jaspersoft command can be found in the TEC1027861 as well as in community blog List of Jaspersoft Commands in accordance with CA PPM Version