How to Purge Stale data from Catalog Groups and Application Roles in OBIEE 11g

The following steps will show you how to clean up the OBIEE catalog from Stale metadata.

In OBIEE 11.1.1.7 release, the information about role membership, access control list and the other information are cache by presentation services. The information will last for default amount time and it will be purged automatically. This design is to improve performance as the presentation services does not need to contact the server every time. However some times you may see stale data till the cache is purged. In order to purge the cache, you will have to do reload server metadata. 

As a workaround, you can increase the purging frequency by changing the default time to lesser time, for say, 3 mins. This means that, you will have to wait for 3 mins to see the changes. 

1. Please take a backup of [Middleware Home]/instances/instance1/config/OracleBIPresentationServicesComponent/coreapplication_obips1/instanceconfig.xml 

2. Add <Cache> as mentioned below within <ServerInstance> : 

<ServerInstance> .. 

<Cache>
 <RoleDirectMembersCache>
 <CleanupFrequencyMinutes>3</CleanupFrequencyMinutes> 
<MaxAgeMinutes>3</MaxAgeMinutes> 
</RoleDirectMembersCache> 

<RoleHierarchyCache> 
<CleanupFrequencyMinutes>3</CleanupFrequencyMinutes> 
<MaxAgeMinutes>3</MaxAgeMinutes> 
</RoleHierarchyCache> 

<ParentRolesForGrantedRolesCache>
 <CleanupFrequencyMinutes>3</CleanupFrequencyMinutes>
 <MaxAgeMinutes>3</MaxAgeMinutes> 
</ParentRolesForGrantedRolesCache> 

<GroupMemberships>
 <CleanupFrequencyMinutes>3</CleanupFrequencyMinutes> 
<MaxAgeMinutes>3</MaxAgeMinutes> 
</GroupMemberships> 

</Cache> 
</ServerInstance> 

Save and restart the services.

Thanks,

Sandeep

SHARE SHARE SHARE

About test