Siva, I am actually trying to do a similar thing as you, in a new OBIEE 12.2.1.2.0 environment, where I want to do SAML 2.0 for authentication and use the BISQLGroupProvider for external database table authorization. I am struggling to make ours work, and you seem to be further along than me, but I do have some thoughts on…

Can you give us the physical SQL? What you just posted is actually the logical SQL.

The error says "insufficient permissions" or "insufficient privileges"? Maybe post the exact error. Does the user belong to a group that has rights to Create Agents (under manage privileges)?

I think the '=' is okay, although a bit counter-intuitive. I say this because I also am on 11.1.1.7.x and have row-wise session variables that ultimately feed into row-level security groups, and we use ' = ' when setting up the row-level security. In the physical SQL, it converts it to IN(val1,val2,valn). You are 100% sure…

Perhaps you forgot to reload server metadata after renaming the SA?

My initial thoughts would be to pursue one of these options: 1) Combine your Budget and Expenditure fact tables into a single fact table at the physical source layer (in the database) and thus model a single fact table in the RPD. 2) Model aggregate/detail tables properly in the RPD, where your Expenditure table is the…

Refreshing firefox also corrects the issue for our users who are having the problem. So far we are sending people who have this problem here and they are reporting back that the problem is resolved: https://support.mozilla.org/en-US/kb/refresh-firefox-reset-add-ons-and-settings Unfortunately this doesn't help us identify…

Definitely a FF issue, nothing was patched or changed in OBIEE. I'm troubleshooting at the moment. One thing I have noticed so far, if you restart firefox in safe mode, with all plug-ins disabled, the problem does NOT happen. I'm working to see if it's a specific plug-in that is problematic. Will update soon, I hope.

We have the same problem in 11.1.1.7.160119. It just started today. Each user with the problem is using FF 49.0.1.

In your RPD: 1) go to Tools -> Utilities 2) Select 'Oracle BI Event Tables' and press 'Execute' 3) Are there any objects listed in the 'Event Tables' section? Do you have any dynamic repository variables? Do you know with certainty someone is not checking in or saving in the RPD in online mode at around 3:00 PM?

This issue was caused by having this line in instanceconfig: <PersistPageState>false</PersistPageState>

I suggest reading through the support document: How the Oracle BI Server Query Cache is purged (Doc ID 1137203.1) Edit: I just realized this is a 10g doc, but maybe still has aspects that are relevant to 11g.

If someone is saving the RPD in online mode, the BI server cache will automatically get cleared. If you open your RPD in online mode, and go to Manage -> Cache, and then go Action -> Show Info, what do you see?