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
1562
Views
117
Comments
2456712

Answers

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

    Thanks Robert ..

    but first not getting confidence that session variable will certainly work as it has to also pass through similar init blocks.

    second thing that using session variable instead of repository variables will increase unnecessarily extra queries on the server and hence load.Obiee itself is slow so don't want to put extra stuffs on it.

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

    Any other pointer  plz for resolving it ....

    For now I have raised SR with oracle but they just referred me to some documents of 11g problems which are certainly not applicable in my case.

    OBIEE 11g Dynamic Repository Variable may not Be Updated Dynamically ( Doc ID 2176875.1 ).

    Other options am trying is

    open the RPD online and create a dummy variable with high frequency and see if it triggers to run others as well.

    Thanks

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

    The problem at the moment seems to be that they just don't acknowledge the existence of this bug and don't properly invest time in its analysis.

    Unfortunately from our side there's not much we can do. There isn't an internal call which forces bulk refresh of respositoryvariables for example that we could use.

    Also, the option of going for session variables as an alternative is...well...not really the same. Yes the variable will be refreshed upon each login but it will not be refresh while the session persists.

    So for you, @3319735 and @Carsten Weber I can only say: escalate your Service Requests to the highest possible level - they just won't do anything if you don't. Escalation makes the SRs visible in their internal management food chain and is quite literally the only thing which will force them to have a second look...or better: to actually read the SR once.

  • Did you try creating a new fake one to see if it does refresh?

    Because if it does ... you can invest 5 minutes to drop the existing init blocks and create new ones using the same code and pointing to the same variables. It's maybe enough. (It isn't a solution to the potential bug, just a workaround if you need it)

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

    Thanks Christian!!

    Very true .. seems Oracle is missing some concrete mechanism to acknowledge bugs and work on their resolutions. Also from the customers side they try to create SR for any discrepancies but if it takes longer then they try to create their own work around and leave the SR. Timely response from them is also a concern. Who from end users side  will follow so long till the resolution and their inclusion in the later version unless some management team from Oracle takes this responsibility. I am also looking for quick work around. How can I hold the prod env for such a long duration and wait for Oracle's soln.

    Thanks

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

    Thanks Gianni for asking it ...

    Having limited access in prod env so not able to open RPD in online mode . Have requests in process to open rpd in online mode..

    Will update if it works ...

    Thanks

  • [Deleted User]
    [Deleted User] Rank 10 - Analytics Guru
    3319735 wrote:I am also looking for quick work around. How can I hold the prod env for such a long duration and wait for Oracle's soln.

    Bounce OBIS all the time?

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

    Do you have multiple Ini Blocks? I had an Issue with Rep variables that did not update and the cause was actually another  Ini Block that failed thus preventing all other blocks behind it from completing.

    Make sure all of your  Ini Blocks are valid. You might have already ruled that out but I wanted to share anyway.

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

    Invalid init block? Or was it a blacklisted connection pool which was serving those init blocks?

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

    The Query had become Invalid. So the IB could not complete (Because of an ORA message).