Oracle Communities

Oracle Analytics and AI

Child Item

Facing a strange issue with OBI URL

Hello Experts,

I am facing an strange issue with OBI login.

Whenever I am trying to login with generic URL of OBI ex:- http://obione.xxxxxx.com/analytics/ for some user its showing showing signing in, for some user its working.

As this a production clustered environment when we are trying to test with single node login example:-

http://xxxxxprod-n1.xxx.com:9502/analytics/ OR http://xxxxxprod-n2.xxx.com:9502/analytics/

sometimes its work fine on both node, sometime it login perfectly on One node and another node is keep signing in and no home page appears.

We tried to check logs to find some clue but we are not getting anything strange that look like an error.

We have tried to restart complete OBI server, but no luck

We are tried to restart OBI weblogic server but issue is still there.

OBI version:- Oracle Business Intelligence Product Version 12.2.1.1.0 (Build BIPS-20160604082456 64-bit)

Clustered Environment.

OS: - Solaris SPARC64

Kindly let me know if you need any more information.

Yours suggestion will be really helpful for me.

Thanks,

Abhi

Find more posts tagged with

Accepted answers

All comments

Joel Acha

Which log files have you looked at?

User_B7ZTH

Hello Joel,

Thanks for your response.

We have looked AdminServer.log, bi_server1.log and by logging into both node.

Regards,

Abhi

Robert Angel

What security model are you using?

Is there active directory or similar in the security stack that could be your cause?

User_B7ZTH

Hello Robert,

We are using LDAP authentication:- Active Directory Authentication.

We are able to see all the users/Groups in Console.

Regards,

Abhishek

Joel Acha

Could you look at your presentation services log as well as the BI server logs. You have been looking at weblogic component log files and this is possibly an OBIEE issue so you won't find anything helpful in the Admin Server & Managed Server log files.

Robert Angel

Can you try it without LDAP (revert to default security model) and see if it always works?

Also, is there any pattern with which users work and which do not - do some always work and some always not, or is it seemingly random?

User_B7ZTH

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 'Signing In'

Issue seems to be with Node2 but cant see any specific logs to interpret anything Except below log bi_server2-diagnostic.log

[2018-07-31T19:06:31.503+03:00] [bi_server2] [NOTIFICATION] [] [oracle.bi.security.authentication] [tid: [ACTIVE].ExecuteThread: '11' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: 61dc2ae8-b6af-456b-baaa-170acae0288e-000032de,0:1:1:6:1] [APP: bi-security] [partition-name: DOMAIN] [tenant-name: GLOBAL] [J2EE_APP.name: bi-security] [J2EE_MODULE.name: bi-security] [WEBSERVICE.name: SecurityWebService] [WEBSERVICE_PORT.name: SecurityWebServicePort] [SI-Key: ssi] Asserted user identity: User1

[2018-07-31T19:06:31.519+03:00] [bi_server2] [NOTIFICATION] [] [oracle.bi.security.opss.identitystore] [tid: [ACTIVE].ExecuteThread: '11' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: 61dc2ae8-b6af-456b-baaa-170acae0288e-000032de,0:1:1:6:1] [APP: bi-security] [partition-name: DOMAIN] [tenant-name: GLOBAL] [J2EE_APP.name: bi-security] [J2EE_MODULE.name: bi-security] [WEBSERVICE.name: SecurityWebService] [WEBSERVICE_PORT.name: SecurityWebServicePort] [SI-Key: ssi] Found user profile for User1

[2018-07-31T19:06:31.520+03:00] [bi_server2] [NOTIFICATION] [OBI-SEC-00019] [oracle.bi.security.authentication] [tid: [ACTIVE].ExecuteThread: '11' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: 61dc2ae8-b6af-456b-baaa-170acae0288e-000032de,0:1:1:6:1] [APP: bi-security] [partition-name: DOMAIN] [tenant-name: GLOBAL] [J2EE_APP.name: bi-security] [J2EE_MODULE.name: bi-security] [WEBSERVICE.name: SecurityWebService] [WEBSERVICE_PORT.name: SecurityWebServicePort] [SI-Key: ssi] Asserted user identity "User1"

We have found that there is a command called "sync_midtier_db.sh" located in mentioned folder location /u01/app/obiee/product/user_projects/domains/bi/bitools/bin.

will this command be helpful, can anyone suggest.

Thanks & Regards,

Abhi

Joel Acha

Can you check the BI Server & Presentation Services log files? I think I mentioned this earlier:

<oracle_home>/user_projects/domains/bi/servers/obis1/logs

Robert Angel

I have not experienced this but as well as Joel's suggestion below I would also suggest compare and contrast the messages you see in logs when only Node1 is up and log in is wholly successful with when only Node2 is up. Your 'random' behaviour would indicate that some users are lucky and land on Node 1, some are not and don't get in...

Have you logged an SR for this - multi-node with OBIEE is very common they must have run into your issue before...

[Deleted User]

Pump up the logging to 32 and check what's happening: slide 36 and 37: