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?
Can you go to PPM and check the look up if they are ensuring DWH look up standard are met and doesn't have duplicates.
This is the out of the box lookup for the custom object.
Yes not all out of box look up are DWH complaint though. Which look up you are using?
Was the custom object completely deleted from the system with this same lookup attribute and it's no longer in use anywhere?
If yes, you can go ahead and drop the view after taking a backup of the DDL. Then try running the Load DWH - Full again.
If the lookup is also used on other objects, then try compiling the view
and see what are the exact Oracle errors thrown.
You could also try unchecking the attribute and running the Load DWH job (provided it's in use on another object).
Hope this helps -Nika