Oracle Analytics Cloud and Server

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

Obiee 12c Repository Variable Refresh Problem

Received Response
378
Views
8
Comments
dilek
dilek Rank 6 - Analytics Lead

Hi,

We use following obiee version in our company. Our problem: repository variables is not updated automatically. This is not for all days but some days. For example, today this problem occurred.

Our repository variables = rv_yesterday (which includes yesterday value, including select statement from dual), it returns two days ago's value. Why this is happened? Do you have any idea? Is it a bug?

12.2.1.3.0 (Build BIPS-20170820114118 64-bit)

Please help me.

Regards,

Dilek

Answers

  • 3068122
    3068122 Rank 4 - Community Specialist

    Hi ,

    It's worth to check

  • Hi Dilek,

    search here in the forum. There is a thread started more than a year ago which was fully about that and there has been some patches released. Apparently it has been fixed by one of those patches. Can’t remember the exact version it was about.

    @Joel Acha must defenitely have useful links (sorry to spam you Joel, on my phone I can barely write)

  • Joel
    Joel Rank 8 - Analytics Strategist

    No worries @Gianni Ceresa! - Take a look at this thread (be warned, it's very long...)

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

  • [Deleted User]
    [Deleted User] Rank 10 - Analytics Guru

    Longest thread of all time in the BI space

  • Carsten Weber
    Carsten Weber Rank 5 - Community Champion

    It's quite funny that our repository variable also just got stuck on the same day.

    Anyways the thread provided by Joel should give you an estimate overview of the problem and you will see that there is no real fix for it so far.

  • Michael Verzijl
    Michael Verzijl Rank 6 - Analytics Lead

    Not exactly true. We have installed patch 27766951 on 12.2.1.4 and for us this is working fine now.

  • Carsten Weber
    Carsten Weber Rank 5 - Community Champion

    Sorry my bad. I dismissed your post within the mentioned thread. :/

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

    Yes our system is also working correctly after this patch. Haven't had any issues since. Applying it should solve your issues