Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 215 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
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
Answers
-
Which log files have you looked at?
0 -
Hello Joel,
Thanks for your response.
We have looked AdminServer.log, bi_server1.log and by logging into both node.
Regards,
Abhi
0 -
What security model are you using?
Is there active directory or similar in the security stack that could be your cause?
0 -
Hello Robert,
We are using LDAP authentication:- Active Directory Authentication.
We are able to see all the users/Groups in Console.
Regards,
Abhishek
0 -
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.
0 -
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?
0 -
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
0 -
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
<oracle_home>/user_projects/domains/bi/servers/obis1/logs
0 -
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...
0 -
