Hello Joel, I tried to find the logs you suggested but I am getting the below error only in OBIJH:- 2018-08-29T12:53:46.235+03:00] [messageprocessor] [WARNING] [] [saw.messageprocessor] [tid: 23] [ecid: 259f38a6-d1b6-4e6c-9222-c1806d47c175-00000002,0] Unexpected exception. Connection will be closed[[ java.io.IOException:…

Thanks Joel, Problem solved, created the datasource with RAC option.

Hello Joel, Thank you for your help, I will try these options mentioned and update the blog. Regards, Abhi

Hello Berg, yes, you are correct, even i tried to add the parameter but no help. Regards, Abhi

Hello Joel, Bingo!!! its was the exact issue after upgrade services.xml file was missing. Thanks for your nice help. Cheers

Hello All, Thank for your support. Resolution we find out that ramdisk was full on node2. we have cleared it and its started working again. Thanks again for your wonderful support and as ususal Oracle support is still asking for LOGS. Regards, Abhi

hello Christian, Thank you for your post and direction of help, I have finally give up my investigation and raised an SR with oracle. However in I found something more in log. [2018-08-01T18:42:30.882+03:00] [OBICCS] [NOTIFICATION:1] [] [] [ecid: ] [sik: ] [tid: 2] [71020] A connection with Oracle BI Server biprod-n1:9514…

Hello Robert, We have tried to narrow down the problem:- 1. We have clustered env 2. When both nodes are up, some users are able to login normally some are not, its random 3. When Node1 is only up and Node2 is down, login for all users is fine. 4. When only Node2 is up then the issue related to login repeats, it keeps…

Hello Robert, We are using LDAP authentication:- Active Directory Authentication. We are able to see all the users/Groups in Console. Regards, Abhishek

Hello Joel, Thanks for your response. We have looked AdminServer.log, bi_server1.log and by logging into both node. Regards, Abhi

Thanks Robert

Hello Robert, Thank you for your response, I will be going through the link you provided and let you know once I get something more. Kindly give me a day time to respond you back. However, I just tried to create the union report via the test user (having visibility role) with two column from Fact shipment and Fact Claim…

Hello Robert, Thank you for your response. I tried to run the test report with physical query with both the test user. Query with user without Data visibility filter There are two query which was sent from OBI server. select sum(T179775.UNIT_WEIGHT_KG / 1000) as c1, T169099.YEAR_ID as c2 from COMMON_SL.DWD_TIME T169099,…

Hi Robert, sorry for delay response was pulled into a meeting related to same issue. I will start a new thread as I am facing a new problem related to same issue. However, thank you for quick suggestion in right direction. Thanks & Regards, Abhi

Thanks Robert for your explanation. I have one more doubt, if this role has been added via a group to a user and if that user create analysis then will the condition Limit Filter=0 will be added into the physical query in where clause, I tried to find it but I guess no it will not appear correct me if I wrong. Regards, Abhi

Hello Joel, Correct its an IE issue, but i tried to delete the cache and run it but still no luck. Thanks again.

Thank you Gianni, yes we are planning to upgrade and doing POC for 12.2.1.3.0 upgrade.

Hello Handat, I was able to import the certificates and configure it. I can also see the user and groups now. But unfortunately none of ldap user is able to login into the OBI environment. I am getting below error in b1_server log:- <Warning> <Security> <cargbitest> <bi_server1> <ConnSetupMgr> <<anonymous>> <>…

Hello Handat, Thank you for your response, so I have already the got the certificate in .pem format so the command to import these certificates will be as below:- keytool -import -keystore $JAVA_HOME/jre/lib/security/cacerts -alias upmldapss -file /u01/app/obiee/share/aaldaps_new.pem -storepass changeit –noprompt Kindly…

Hello Geoff, I tried below command to import the certificate and got this error. Command executed:- keytool -import -keystore $JAVA_HOME/jre/lib/security/cacerts -alias ldapubalias -file /u01/app/obiee/share/aldaps_new.p7b -storepass changeit -noprompt Error received:- Keytool error: java.lang.Exception: Input not an X.509…