Oracle Analytics Cloud and Server

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

Oracle BI Admininstration Tool: Variables do not update

Received Response
101
Views
13
Comments
Rank 5 - Community Champion

Hi guys,

we have the problem, that our specified dynamic repository variables within our Oracle BI Administration Tool do not update anymore.

pastedImage_0.png

The value within the first variable "PriorDateEB" should be "02.07.2017". The variables do not update since last Saturday (01.07.2017).

We used to have this problem only a couple of times within the last months and I usually solve it by restarting the whole Oracle BI application environment.

When testing the connection string within the inilization block I receive the correct values:

pastedImage_1.png

Is there an easier way to update the repository variables besides restarting the Oracle BI services?

Does anyone also have this problem and can deliver a solution?

Our Version is as follows:

pastedImage_3.png

The dynamic variables are currently set to update every hour.

Best regards and thanks in advance

Carsten

Welcome!

It looks like you're new here. Sign in or register to get started.
«1

Answers

  • Rank 2 - Community Beginner

    Does the query behind the init block actually yield correct results?

    Alternatively it can be "planed obsolescence" since 12.2.1.0.0 is out of support since June :-P  (that's a joke)

  • Rank 5 - Community Champion

    Yes the results are correct as shown in my above screenshot.

  • Rank 2 - Community Beginner

    Oh sorry hadn't realized that.

    So that looks like bug 23757629 straight away.

  • Rank 5 - Community Champion

    Thx for the hint Christian.

    Do I correctly understand it, that I should always restart OPMN services after I made a change to our repository in online mode to prevent this issue?

    Shouldn't this bug be fixed by using version "12.2.1.1.0": 22733489 BIESG: CACHE NOT BEING PURGED WHEN DYNAMIC REPOSITORY VARIABLE CHANGES VALUE (12.2.1.1 Bugs Fixed List)

  • Rank 2 - Community Beginner

    The bug points to OPMN because it was originally raised for 11.1.1.7.150120 - in 12c there is no OPMN anymore.

    Can't comment on 22733489 since it's a non-pblic bug but topic-wise it sounds like a different issue.

    And a forced restart of the component sounds like a bit much - and harsh - to me. Never had that issue in 12.2.1.1 or 12.2.1.2 so far. Maybe it's a bug you're facing because you're on the dot zero version 12.2.1.0

  • Rank 5 - Community Champion

    We actually are on version: Oracle Business Intelligence 12.2.1.1.0

    Or do you mean the version of the administration tool?

  • Rank 2 - Community Beginner

    No the actual product version. By the way you should update your client tools

  • Rank 5 - Community Champion

    Thx for the advice Christian. I have just downloaded the newest version of the client installer: 12.2.1.2.0

    Still from my understanding the client version should not have anything to do with my issue, since it should be a bug on server-level.

    I have also just raised an SR: SR 3-15263601291 : Oracle BI Admininstration Tool: Variables do not update

  • Rank 2 - Community Beginner

    Not saying it's the client tool. Just pointing out that you have a version mismatch there. By the way "newer" Admin Tool and "older" actual server is also not good ;-)

    The bug I mentioned above doesn't have a "Fixed in version" so it might still persist.

  • Rank 8 - Analytics Strategist

    The workaround I have used for this is to make them session variables, this also guarantees that the variables are as fresh as the user's log in.

Welcome!

It looks like you're new here. Sign in or register to get started.