Load DWH job fails with error "ORA-01400 :cannot insert NULL..." after a refresh


Article ID: 223287


Updated On:


Clarity PPM On Premise Clarity PPM SaaS


The Clarity Database (DB) was copied from Production to a non-production environment. The Data Warehouse (DWH) DB was not copied. You then ran the Load Data Warehouse job to populate the DWH DB. However, it is fails with the following error message in the bg-dwh.log:

2040/21/35 06:39:25 - ClarityDB - isOracle? - [CA Clarity][Oracle JDBC Driver][Oracle]ORA-20100: ENCOUNTERED EXCEPTION IN DWH_DIM_LOAD (DWH_RDM_PICKLIST). SQLERRM : ORA-01400: cannot insert NULL into ("CLARITYDWH"."DWH_RDM_PICKLIST"."PICKLIST_CONTEXT_KEY")


Meta Data mismatch between PPM and DWH DBs. 


Version: Any


Refresh the DWH DB with a backup from Production to resolve this issue. 

Note: While refreshing non-production environments with Production data, both the PPM and the DWH DBs have to be copied over. Only copying the PPM DB can result in meta data mismatch, which in turn causes the Load Data Warehouse job to fail.