Dynamic repositoy variables are not being refreshed in obiee12c(12.2.1.2.0) - Page 8 — 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
168101112

Answers

  • Joel
    Joel Rank 8 - Analytics Strategist

    I've sent you a DM.

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    Thanks again!

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

    I'll be installing this patch in our Development environment today and will keep this thread informed of the progress. Thank you!

  • Michael Verzijl
    Michael Verzijl Rank 6 - Analytics Lead

    Thanks for spotting Joel!

    I do find it strange to have this included in the solution:

    SET VARIABLE DISABLE_CACHE_SEED = 1,DISABLE_CACHE_HIT=1

    Also have asked Oracle support if this patch is going to solve this issue [as they did not reply to my SR at all]

  • Joel
    Joel Rank 8 - Analytics Strategist

    No worries @Michael Verzijl. The Cache settings I don't believe are part of the fix but just a means to test out the patch to ensure that the analysis executes against the data source and not cache which could potentially persist the problem after patch has been applied. That's my understanding anyway.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner
    Michael Verzijl wrote:I do find it strange to have this included in the solution:SET VARIABLE DISABLE_CACHE_SEED = 1,DISABLE_CACHE_HIT=1

    Not really a solution, no.

  • Dimitris Karydis
    Dimitris Karydis Rank 4 - Community Specialist

    Today same issue came up again.

    I am curious if this happened again to other users too. All of us have raised the issue in the past.

    Oracle should be worried that different users with different implementations face the same issue almost at the same time. They should acknowledge that it is more possible that there is a problem in the core that they should take care of

  • Joel
    Joel Rank 8 - Analytics Strategist

    A few other people have experienced this in the last day or 2. What time did you notice this?

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

    In our env also we got the alert that repository variables are out of sync.

    How come people are reporting the out of sync problem at the same time . Is it just a coincidence or a regular pattern?

  • Dimitris Karydis
    Dimitris Karydis Rank 4 - Community Specialist

    @Joel Acha This morning after the daily refresh

    @Onkar Nath Tiwari The time period that this is happening is looking totally random but when it happens a lot of people with different implementations and in different places face the same issue. It has been raised a long time ago but we are not having an answer (one that makes sense) from Oracle yet