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
In Oracle Enterprise manager, we have "Enable cache" unchecked. We don't want the data to cache. However, when running
reports in OBIEE, it's clear that the cache is being used. The data results are not correct. As soon as we manually clear the
cache, the results are correct.
We want global caching turned off.
Answers
-
Which exact version?
Are you sure that the server has been bounced after setting cache as disabled?
0 -
If BI Server cache has been disable in your environment and still reports are hitting cache then did you check if cache is still getting seeded when a non cached report is run?
After disabling cache did you purge already seeded cache, because I am not sure but I dont think by just disabling cache it also ensures CACHE HIT for previously generated cache is disabled, may be I am wrong.
Yeah also do check if cache disbaling changes through EM is reflected in NQSConfig.INI under [CACHE] section.
DO NOT CHANGE NQSConfig.INI FILE DIRECTLY JUST BECAUSE I MENTIONED IT HERE.
Here is a blog(Under Section Application Level) which talks about naviagtion to disable BI Server Cache through EM:
Oracle Business Intelligence: Enable / Disable Cache in OBIEE 11g
0 -
Hi All - I took the steps of turning cache on and off again (and restarting services) in EM this morning and it now appears that
all is behaving as intended at the report level. Thank you.
We've had caching turned off (at least as evidenced in EM and I verified in the nqslog) for a long time.
What would make caching at the report level show up anyways despite having caching globally turned off? My concern
is that it's a ticking time bomb that needs constant babysitting.
0 -
If cache is off it is off, you can even set in the RPD the no cache info on each physical source object to make it even more "no".
But you will anyway still have a browser / front-end caching.
Cache off doesn't mean the analysis is executed again every time you refresh the page (in the same session), that's the front-end cache which is always there to not run queries for nothing.
Also another thing: if cache is hit you see it in the logs, so keep an eye on logs to see if you have a cache hit info coming to confirm your cache is off.
You never posted the version of OBIEE you are talking about, but I don't remember any with cache being on even when set to off...
0 -
As mentioned above, it sounds like you are bypassing the cache to the tables in the RPD & in EM -- which I believe means it will not use the BI SERVER cache -- but your reports are still using the Presentation Server cache.
To bypass that here is what I do:
To bypass cache in a single report
----------------------------------
1)Go to Advanced tab of Report
2)Go to Advance SQL section
3)Check the 'Bypass Oracle BI Presentation Services Cache' check box
4)Go to Prefix Section
5)Write the below command:
SET VARIABLE DISABLE_CACHE_SEED=1,DISABLE_CACHE_HIT=1;
*make sure before saving click Apply SQL Query Button in the bottom
6)Save the report
Hopefully this helps.
0 -
Ok. The issue is probably the Presentation server cache. Will try last suggestion. Thanks all!
0 -
I'll keep all posted. I've also implemented the suggestion to disable presentation services caching.
Here's why I'm doing this. We're incorporating VPD (virtual private database) whereby depending upon who
runs a given query, a different set of data will show up. We need the query to hit the database each time so
that users do not see data they are not supposed to see. In some of our testing, when I did not go back to the
database, I was seeing info that I was not supposed to.
0 -
Here is what was throwing me - when you search the web for turning off the cache in obiee, several places basically say in order
to do this at the application level, do it in Enterprise Manager. Isn't BI Presentation Services considered part of the application?
I thought so. So didn't realize that I also need to deal with the Presentation Services cache at the report level. Upon further
research, I'm seeing this suggestion. I won't be able to fully test until next week. If all goes well, I'll mark the last suggestion
showing the Advanced tab in a report as the correct answer. Really appreciate EVERYONE's help!
0 -
First thing you still didn't say what version of OBIEE you are talking about, so you make it quite hard to give you useful answers! ( )
The presentation cache is personal, it isn't shared, so it can't be an issue. If it would be shared almost 90% of the OBIEE setup wouldn't work because it would destroy any security setup.
As apparently you are setting up VPD you maybe want to finish the full config of VPD before to test to get a real view of what happen, because what you described sounds a bit weird and honestly never saw that if not with a missing or wrong cache management strategy.
But again: it also depends on what version you use as between OBIEE 10g, 11g and 12c there are like 10 years of multiple different versions ...
0 -
It is version 11.1.1.7.
If the user hits the same report, you sure the presentation server cache not shared? When I cleared all cursors manually, the problem went away.
VPD itself is working. If I manually clear all cursors, a person who was not seeing the correct data on the page now does see the correct information.
We are going to test further today. Here is what has been done on caching:
-Turned off in EM
-Cachable property turned off on every physical table in the Physical layer of RPD. My understanding is that this is not necessary if we took the EM step, but
leaving in place for now.
-On every report on the dashboard, on Advanced tab, checked option to bypass presentation services and added the script suggested above to the prefix
In our testing, it does appear that if users run the same report (and the bypass presentation services option not checked on the report), the presentation services
cache is shared. Also, in the rpd, we're not processing against the database with individual database accounts or using the :USER variable. We're using a service
account and added a script to pass the Active directory id of the person who logged in back to the database.
0
