Categories
- All Categories
- 99 Oracle Analytics News
- 9 Oracle Analytics Videos
- 14.3K Oracle Analytics Forums
- 5.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 55 Oracle Analytics Trainings
- 59 Oracle Analytics Data Visualizations Gallery
- 4 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
Dynamic repositoy variables are not being refreshed in obiee12c(12.2.1.2.0)
Answers
-
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.
0 -
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
0 -
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.
0 -
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)
0 -
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
0 -
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
0 -
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?
0 -
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.
0 -
Invalid init block? Or was it a blacklisted connection pool which was serving those init blocks?
0 -
The Query had become Invalid. So the IB could not complete (Because of an ORA message).
0