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
Query on Disabling Client side caching

Hi All,
Oracle Business Intelligence 12.2.1.1.0
We have caching enabled and we use event pooling method to purge the cache. Today one of our user was not seeing any result for a report. When the same report is ran from another system browser it returned results. When the user who had the issue hit the refresh button, it returned the correct result. So I believe the issue was because of the browser cache. User was using IE 11.
So I was wondering is there any method to disable to disable the client side caching. I have seen a blog post related to this whose link is given below,but couldn't find any official oracle documentation.
http://bisimplified.blogspot.com/2014/06/obiee-11g-disable-cache-on-client-side.html
Anyone faced this similar issue ? What would be a better solution to this prevent these issues ?
Thanks
Ebin
Answers
-
I believe to bypass the client side cache, you can:
1)Go to Advanced tab of Report
2)Go to Advance SQL section
3)Check the 'Bypass Oracle BI Presentation Services Cache' check box
And to bypass the server cache, you can:
1)Go to Prefix Section
2)Write the below command:
SET VARIABLE DISABLE_CACHE_HIT=1;
or
SET VARIABLE DISABLE_CACHE_SEED=1,DISABLE_CACHE_HIT=1;
-make sure before saving click Apply SQL Query Button in the bottom
3)Save the report
0 -
Hi Chris,
Thanks for your reply. We are purging the BI server cache using event pooling method. That is not an issue here. Also it is not possible at the moment to make the presentation service cache change change report by report as we have large number of reports.
0 -
Ebin,
I just checked the obips schema. The below is from obips-config-base.xsd schema has been documented with the details about the Cache Control at the client side.
<!-- ==========================================
WebConfig/ClientSideCaching/CacheControlHttpHeader
========================================== -->
<xs:complexType name="CacheControlHttpHeaderType">
<xs:all>
<xs:element name="Default" type="xs:string" minOccurs="0" default="private"/>
<xs:element name="NoCache" type="xs:string" minOccurs="0" default="private"/>
<xs:element name="EnableCache" type="xs:string" minOccurs="0" default="private"/>
</xs:all>
</xs:complexType>
Thanks,
0 -
Hi Madasamy,
Thanks for your reply. Could you please confirm the tag need to be added to instanceconfig.xml to disable clientside caching ?
Thanks
Ebin
0 -
You can try this
<ClientSideCaching>
<CacheControlHttpHeader>
<Default>no-cache, no-store</Default>
<NoCache>no-cache, no-store</NoCache>
</CacheControlHttpHeader>
</ClientSideCaching>
0