search cancel

DWH job fails after modifying NSQL query which is already enabled for DWH


Article ID: 190409


Updated On:


Clarity PPM SaaS Clarity PPM On Premise


The Load Data Warehouse (DWH) job fails if you modify a lookup query that is already enabled for DWH.


Release : 15.8

Component : Data Warehouse (DWH)


This is caused because of mismatch between Lookup views and the meta columns.


  1. Flush the application cache, so that the new lookup query is implemented.
  2. Navigate to Administration -> Objects -> ObjectName.
  3. Find the attribute which is using this lookup, exclude it from DWH. (See: Load DWH failing on custom lookup - finding the attribute to disable)
  4. Run DWH Full Load.
  5. Include the attribute back to DWH which was excluded on step 2.
  6. Run DWH Full Load.

Additional Information

Reference also: