Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Query on Disabling Client side caching

Received Response
51
Views
5
Comments
Ebin Cherian
Ebin Cherian Rank 5 - Community Champion
edited Aug 13, 2024 5:56PM in Oracle Analytics Cloud and Server

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

  • Chris Arnold
    Chris Arnold Rank 5 - Community Champion

    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

  • Ebin Cherian
    Ebin Cherian Rank 5 - Community Champion

    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.

  • Madasamy -Oracle
    Madasamy -Oracle Rank 6 - Analytics Lead

    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,

  • Ebin Cherian
    Ebin Cherian Rank 5 - Community Champion

    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

  • Madasamy -Oracle
    Madasamy -Oracle Rank 6 - Analytics Lead

    You can try this

                                   <ClientSideCaching>

                                        <CacheControlHttpHeader>

                                              <Default>no-cache, no-store</Default>

                                              <NoCache>no-cache, no-store</NoCache>

                                        </CacheControlHttpHeader>

                                   </ClientSideCaching>