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

Obiee 12c Repository Variable Refresh Problem

dilek

Hi,

We use following obiee version in our company. Our problem: repository variables is not updated automatically. This is not for all days but some days. For example, today this problem occurred.

Our repository variables = rv_yesterday (which includes yesterday value, including select statement from dual), it returns two days ago's value. Why this is happened? Do you have any idea? Is it a bug?

12.2.1.3.0 (Build BIPS-20170820114118 64-bit)

Please help me.

Regards,

Dilek

Find more posts tagged with

Accepted answers

All comments

3068122

Hi ,

It's worth to check

OBIEE 12.2.1.X Reports and Dashboards Using Dynamic Repository Variables Not Refreshing and Showing Incorrect Data (Doc ID 2338889.1)

Gianni Ceresa

Hi Dilek,

search here in the forum. There is a thread started more than a year ago which was fully about that and there has been some patches released. Apparently it has been fixed by one of those patches. Can’t remember the exact version it was about.

@Joel Acha must defenitely have useful links (sorry to spam you Joel, on my phone I can barely write)

Joel Acha

No worries @Gianni Ceresa! - Take a look at this thread (be warned, it's very long...)

Dynamic repositoy variables are not being refreshed in obiee12c(12.2.1.2.0)

[Deleted User]

Longest thread of all time in the BI space

Carsten Weber

It's quite funny that our repository variable also just got stuck on the same day.

Anyways the thread provided by Joel should give you an estimate overview of the problem and you will see that there is no real fix for it so far.

Michael Verzijl

Not exactly true. We have installed patch 27766951 on 12.2.1.4 and for us this is working fine now.

Carsten Weber

Sorry my bad. I dismissed your post within the mentioned thread.

Martin van Donselaar

Yes our system is also working correctly after this patch. Haven't had any issues since. Applying it should solve your issues