Categories
- All Categories
- 89 Oracle Analytics News
- 7 Oracle Analytics Videos
- 14.1K Oracle Analytics Forums
- 5.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 51 Oracle Analytics Trainings
- 59 Oracle Analytics Data Visualizations Gallery
- 2 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
Oracle BI Admininstration Tool: Variables do not update
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
Answers
-
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)
0 -
Yes the results are correct as shown in my above screenshot.
0 -
Oh sorry hadn't realized that.
So that looks like bug 23757629 straight away.
0 -
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)
0 -
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
0 -
We actually are on version: Oracle Business Intelligence 12.2.1.1.0
Or do you mean the version of the administration tool?
0 -
No the actual product version. By the way you should update your client tools
0 -
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
0 -
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.
0 -
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.
0