nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Oracle BI Admininstration Tool: Variables do not update

Carsten Weber

Hi guys,

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

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:

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:

The dynamic variables are currently set to update every hour.

Best regards and thanks in advance

Carsten

Find more posts tagged with

Accepted answers

All comments

[Deleted User]

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)

Carsten Weber

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

[Deleted User]

Oh sorry hadn't realized that.

So that looks like bug 23757629 straight away.

Carsten Weber

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)

[Deleted User]

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

Carsten Weber

We actually are on version: Oracle Business Intelligence 12.2.1.1.0

Or do you mean the version of the administration tool?

[Deleted User]

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

Carsten Weber

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

[Deleted User]

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.

Robert Angel

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.