The Load Data Warehouse job fails with the following error in bg-dwh.log:
[CA Clarity][Oracle JDBC Driver][Oracle]ORA-02298: cannot validate (DWH_RDM_ITEM_POSITION_FK3) - parent keys not found
... 2 more
Caused by: java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-02298: cannot validate (DWH_RDM_ITEM_POSITION_FK3) - parent keys not found
Versions: 15.6.1, 15.7.0, 15.7.1, 15.8.0, 15.8.1, 15.9.0, 15.9.1
DWH_RDM_ITEM_POSITION.PICKLIST_KEY has a foreign key constraint on DWH_RDM_PICKLIST.PICKLIST_KEY, that is defined in DWH_RDM_ITEM_POSITION_FK3.
The following query can be used in the DWH DB to determine any such orphan records in DWH_RDM_ITEM_POSITION table.
picklist_key NOT IN (
1. Run the following query in the PPM DB to find the picklist_key that are causing the issue:
JOIN rdm_roadmaps rr ON rr.id = ip.roadmap_key
ip.picklist_key NOT IN (
2. The name and code of the Roadmap that has the issue is shown by the above query in the first two columns. Use that information to navigate to the relevant Roadmap
3. Check if there are any custom picklists defined in that Roadmap. Also, navigate to the Board view and change "Columns" and "Color By" options under "View Options"
4. Run the query in step 1 again, and verify if any rows are returned or not. If no rows are returned, then try running a full load and check if the job fails or not.