Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
OBIEE Cache Not Working
Answers
-
Honestly I don't see how the presentation cache could be shared is it makes OBIEE unusable. The presentation cache is personal, it's like browser cache in the end.
When you see the wrong data with the user, what does the log tell you? The LSQL must be executed at least (the presentation cache doesn't even execute the LSQL anymore, it just show you the cached entry).
It looks more like you have an issue on your VPD implementation and the query is executed on the connection of the previous user instead of working as VPD is supposed to be on an isolated new connection.
Logs have all these infos inside, look at https://www.rittmanmead.com/blog/2015/03/instrumenting-obiee-database-connections-for-improved-performance-diagnostics/ on how to be able to track things down to the DB side and analyze all the steps.
I would definitely bet on a connection pool / VPD issue and not on presentation cache.
0 -
Gianni - You absolutely nailed it. Amazing job. That was it. We had shared connection pool checked. Once that was unchecked, it solved the
issue. Ugh. Thanks again to all.
0
