Load Data Warehouse jobs have been consistently failing every 30 minutes for the past several hours

Products

• Clarity PPM SaaS

Issue/Introduction

Load Data Warehouse jobs have been consistently failing every 30 minutes for the past several hours

Cause

ERROR 2020-06-24 15:38:23,806 [Dispatch Load Data Warehouse : [email protected] (tenant=clarity)] kettle.JasperSoftDomainUpdates (clarity:user:session:Load Data Warehouse) Error occurred while processing domain attributes. com.ca.jasper.restAdapter.JasperException: Could not add attribute code of sub object retrospectives to domain  (dwh table:dwh_odf_retrospectives dwh column:id )CSK_PRJ_Management
ERROR 2020-06-24 15:38:23,813 [Dispatch Load Data Warehouse : [email protected]app1234567.casaasops.com (tenant=clarity)] niku.njs (clarity:user:session:Load Data Warehouse) Error executing job: 5175279
com.ca.jasper.restAdapter.JasperException: Could not add attribute code of sub object retrospectives to domain  (dwh table:dwh_odf_retrospectives dwh column:id )CSK_PRJ_Management
 at com.ca.clarity.etl.kettle.JasperSoftDomainUpdates.addAttributesToDomain(JasperSoftDomainUpdates.java:1035)
 at com.ca.clarity.etl.kettle.JasperSoftDomainUpdates.processDomainAddedAttributes(JasperSoftDomainUpdates.java:297)
 at com.ca.clarity.etl.kettle.JasperSoftDomainUpdates.dynamicDomainUpdates(JasperSoftDomainUpdates.java:174)
 at com.ca.clarity.etl.kettle.DataWareHouseKettleJob.postProcess(DataWareHouseKettleJob.java:109)
 at com.ca.clarity.etl.kettle.AbstractKettleJob.executeETLJob(AbstractKettleJob.java:99)
 at com.ca.clarity.njs.listeners.ETLJobListener.scheduledEventFired(ETLJobListener.java:31)
 at com.niku.njs.Dispatcher$BGTask.run(Dispatcher.java:657)
 at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
 at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
 at java.base/java.lang.Thread.run(Thread.java:834)

Environment

Release : 15.8

Component : CA PPM SAAS DATA WAREHOUSE

Resolution

Customer removed custom subobject referenced in the logs.