Categories
- All Categories
- 163 Oracle Analytics News
- 29 Oracle Analytics Videos
- 14.8K Oracle Analytics Forums
- 5.7K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 56 Oracle Analytics Trainings
- 13 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 2 Oracle Analytics Industry
- Find Partners
- For Partners
Dynamic repositoy variables are not being refreshed in obiee12c(12.2.1.2.0)
Answers
-
In our prod env as well we got same failure yesterday ! Rep variables stopped refreshing ....
From last April onwards we faced this issue almost 5-6 times ..
Over the time I found the easiest method to refresh them again. Just to share it is as below .. No need to update or restart ...
1. Open the rpd in online mode
2. Disable all dynamic init blocks in one go and save the rpd.
3. Enable all disabled init blocks in previous steps and save the rpd.
It's done ! ... all rep dynamic variables will be uptodate and auto refresh will become functional...
Thanks
Onkar
0 -
Agreed that works but this is such a central and critical functionality that it HAS to be solved by Oracle once and for all in the core product and not be a manual hack where someone has to go a actively do things by hand in a productive environment.
0 -
Is there an SR for this? Are Oracle even aware of this issue?
0 -
From my side multiple. Every time it happens a new SR is opened for this.
Also pointed to this topic in the SR that multiple sites have this issue.
0 -
If only there were some thing like sentiment analysis or cluster analysis or .... gasp .... a relationship graph which could point out multiple related occurrences of this issue!
But that's just crazy. Technology isn't that far advanced yet.
0 -
From my side we have also reported this issue multiple times to Oracle support and we have send them several diagnostic_bundles each time the error occured.
Regarding the steps of Onkar Nath Tiwari we almost do it the same way:
1. Open .rpd-file in online mode
2. "Test" the data source of the respective inilization block and commit
3. Save the .rpd-file
Yesterday I got an advice of an external consultant:
1. Create a new connection pool within Administration Tool
2. Set cache size to NULL / deactivate it
3. Set your inilization block to this new connection pool and only use it for your variables
0 -
All these hacks may work but are quite dangerous because you risk bringing/inventing in errors which weren't there before. It's just a manual crutch.
Re new connection pool that's actually the most scary one I've seen so far.
The key question is simply: how long until this first happens on a critical OAC instance and the pressure gets high enough that there is a fix in the codebase
0 -
We have raised an SR for this too, a couple of months ago
0 -
Just seen this from Oracle: Oracle Support Document 2338889.1 (OBIEE 12.2.1.X Reports and Dashboards Using Dynamic Repository Variables Not Refreshing and Showing Incorrect Data ) can be found at: https://support.oracle.com/epmos/faces/DocumentDisplay?id=2338889.1
0 -
That looks hot off the presses!
Is there a way to subscribe to new documents relating to a product that you are using, or were you just searching 'My Oracle Support'?
0
