Dynamic repositoy variables are not being refreshed in obiee12c(12.2.1.2.0) - Page 9 — Oracle Analytics

Oracle Analytics Cloud and Server

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

Dynamic repositoy variables are not being refreshed in obiee12c(12.2.1.2.0)

Received Response
1590
Views
117
Comments
16791112

Answers

  • Onkar Nath Tiwari
    Onkar Nath Tiwari Rank 3 - Community Apprentice

    Someone suggested that Oracle has released a patch for this.  Patch 27019889.

    We haven't tested it in our env yet.

    Anyone has tested it successful and can confirm please?

    Thanks

  • r.barrera
    r.barrera Rank 2 - Community Beginner

    My repository variable also failed yesterday, Thursday April 26. It had been the first occurrence of t his happening since we applied patch 27019889 in our production environment last month. We thought that the patch had worked, but yesterday's failure proved otherwise.

  • user12871966
    user12871966 Rank 1 - Community Starter

    Our variables failed to update on March 7 and April 26.

    Very interesting situation...

  • chillychin
    chillychin Rank 6 - Analytics Lead

    Adding in my info

    I have 4 environments (Sandbox, DEV, QA and PROD)

    All my environments are single node and not clustered

    We are on version 12.2.1.2 for all 4 enviroments, and migrated from 11.1.1.7.140225 - We never experienced this issue when we were in 11g

    3 out of my 4 environments failed to refresh the dynamic variables on 04-25-2018

    It sounds like others experienced an issue right around the same time/days.

    One thing to note - For our QA server we actually turned off the BI server cache

    BI Cache.jpg

    We had turned off the BI server cache on QA to do some testing, and this then issue just happened. This happened to be the only server out of 4 that seemed to be not affected.

    As a test, I plan on applying the patch (27019889) from this article in our SANDBOX enviroment

    https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=168144305117338&id=2338889.1&_afrWindowMode=0&_adf.ctrl-…

    I will also attempt to turn off the BI server cache on our DEV environment (same as our QA environment).

    Leaving our PROD environment alone, and will wait for this issue to hit again.

    When it does, I can at least see if either A) Patching works or B) Perhaps turning off the BI server cache would work

  • Venkata Rachuri
    Venkata Rachuri Rank 5 - Community Champion

    Have you checked this

    OBIEE 12.2.1.X Reports and Dashboards Using Dynamic Repository Variables Not Refreshing and Showing Incorrect Data (Doc ID 2338889.1)

    Thaanks

    venkata Rachuri

  • Michael Verzijl
    Michael Verzijl Rank 6 - Analytics Lead

    I already installed patch 27019889 on all our environments, but this didn't work. It stopped last week.

    SR is re-opened again.

  • Farnaz M.
    Farnaz M. Rank 1 - Community Starter

    Hi!    Anyone else has experienced this last night, 14th of July, again?

  • Michael Verzijl
    Michael Verzijl Rank 6 - Analytics Lead

    We experienced the same again. Happened between 22:05 and 23:20 CET.

    Our SR is still under investigation.

  • Martin van Donselaar
    Martin van Donselaar Rank 6 - Analytics Lead

    Yep, here also today

  • Dimitris Karydis
    Dimitris Karydis Rank 4 - Community Specialist

    Same issue here again in all environments, will contact Oracle again, they'll give us back the same random answer and life goes on