Skip to Content
Jun 16, 2015 at 06:15 PM

Cache for derived columns


When we promote Web Intelligence reports along with underlying Universe to another BOBJ instance, say from Quality to Production, the reports that use derived columns from the Universe error out in the target instance while running with message:

"Some objects are not available to your user profile. You cannot refresh this document. (IES 00002)"

They work when we manually delete the derived columns and add them back to query. It looks like there is a cache pointing to the source BOBJ system that prevents objects to refresh in the new environment but I am not sure about the details and how to overcome this error without the manually modifying the query. We are on BOE Version 4.2