AnsweredAssumed Answered

Load DWH full load job fails after a custom object  is deleted in the Clarity system

Question asked by venvzw on Sep 29, 2017
Latest reply on Oct 2, 2017 by Nika_Hadzhikidi

Load DWH full load job fails after custom object a is deleted in the Clarity system. Referencing the invalid view related to the custom object browse...

 

Caused by: java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-04063: view "CLARPRD.DWH_LKP_XXXXX_BROWSE__00_V" has errors

I thought the Full load job takes care of the deleted objects. 

Any ideas or Work around how to fix this?

Outcomes