Thanks Joel... Yes I already refered the link...and in case of odbc connection I constantly used to get the error Odbc driver returned an error (SQLExecDirectW). State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000) State: HY000. Code: 43113. [nQSError: 43113]…

Thanks a lot Robert for the reply but I believe the classpath needs to be updated somewhere in weblogic server of obiee. Multiple times I started obiee server/services to resolve it but invain. Java path I already set to start drill in embedded mode and that worked. Need the make connection through jdbc/odbc to let it…

Someone suggested that Oracle has released a patch for this. Patch 27019889. We haven't tested it in our env yet. Anyone has tested it successful and can confirm please? Thanks

In our env also we got the alert that repository variables are out of sync. How come people are reporting the out of sync problem at the same time . Is it just a coincidence or a regular pattern?

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.…

Correct it looks like , this bug is in base product... In our case this problem occurred in 11g version as well and for that we started checking and sending mail for any variations. When we moved to 12.2.1.2.0 still it's there. I found that it happened in our env 3-4 time from the migration to to 12.2.1.2.0 in last Sept.…

Yes ..true , looks like a generic problem and bug . Recently it happened in our system again when no changes happened in prod env. Everything was working quiet well when at sudden recently in one morning I noticed . I verified and no any change has gone in our env so that mean even without any external touch it happened. I…

HI Christian , Even me as well installed as one-off patch. We updated our obiee env from 11.1.1.7.1 to 12.2.1.2.0 around mid of this year. And now to remove the VA link tried the option 1. removing through the wlst script and it didn't help 2. Installed the patch p26642682 which is inclusive of 24961623 but still not able…

Hi Christian , Thanks a lot for the reply ... I applied the patch p26642682 which say that it's inclusive of 24961623 as well. My obiee install version is 12.2.1.2.0. and OS is Linux x86-64 Red Hat enterprise 6. After installation and removal of the va.author from BIAuthor still I am seeing the link appearing as it was…

I faced very similar issue and after reading through this thread planned to install the patch 24961623. When I tried to get this patch then there was the message that new version of the patch has been created and it's patch no is 26642682. It includes the patch 24961623 as well. So I installed the patch 26642682. But even…

Automatic refresh of dynamic repository variables has stopped again. Not sure what has triggered them not to refresh. Although when I opened the rpd in online mode and tried to test them , they are getting latest values correctly. So that mean queries are fine and if have triggered then certainly would have refreshed…

Thanks to all for valuable suggestions... No specific response or solution from Oracle on the SR raised. They suggested to open the RPD in online mode and verify variable's values from session manager. In our case due to firewall issues not able to open RPD in online mode . Not able to query underlaying database from RPD…

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

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…

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…

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…

Thanks Gianni, Carsten ...... I got the prod RPD offline and able to verify options there . 1. It's enabled 2. Queries looks fine as same queries I tried running them from direct data base request and am able to see data from answers so no problem with queries. 3. It's prod env rpd so am not able to query tables from the…

Last week only we migrated our 11g env to 12c. We migrated repository and catalog through migration script. In 11g these variables were working fine but when moved in 12c they created this problem and not being refreshed automatically. Am able to run the queries behind these variables in the init block through data direct…

The screen shot if from prod env and the query in the init block is very simple select trunc(sysdate)-1, trunc((sysdate)-1,'MM'), trunc((sysdate-1),'YY'), decode(to_char(sysdate,'dy'),'sun',trunc(sysdate-2),'mon',trunc(sysdate-3),trunc(sysdate-1)) from dual When I run direct database request query from answers I am able to…