1 2 Previous Next 15 Replies Latest reply on Aug 9, 2018 7:14 AM by 3521884

    Facing a strange issue with OBI URL

    3521884

      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

        • 1. Re: Facing a strange issue with OBI URL
          Joel Acha

          Which log files have you looked at?

          1 person found this helpful
          • 2. Re: Facing a strange issue with OBI URL
            3521884

            Hello Joel,

             

            Thanks for your response.

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

             

            Regards,

            Abhi

            • 3. Re: Facing a strange issue with OBI URL
              Robert Angel

              What security model are you using?

               

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

              1 person found this helpful
              • 4. Re: Facing a strange issue with OBI URL
                3521884

                Hello Robert,

                 

                We are using LDAP authentication:- Active Directory Authentication.

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

                 

                Regards,

                Abhishek

                • 5. Re: Facing a strange issue with OBI URL
                  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.

                  • 6. Re: Facing a strange issue with OBI URL
                    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?

                    1 person found this helpful
                    • 7. Re: Facing a strange issue with OBI URL
                      3521884

                      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

                      • 8. Re: Facing a strange issue with OBI URL
                        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

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

                        1 person found this helpful
                        • 9. Re: Facing a strange issue with OBI URL
                          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...

                          1 person found this helpful
                          • 10. Re: Facing a strange issue with OBI URL
                            Christian Berg

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

                            Advisor Webcast Troubleshooting OBIEE Login Issues

                            1 person found this helpful
                            • 11. Re: Facing a strange issue with OBI URL
                              Christian Berg

                              3521884 Did you give up on this thread?

                              • 12. Re: Facing a strange issue with OBI URL
                                3521884

                                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 (monitor port 9515) was established.

                                 

                                 

                                [2018-08-02T05:26:09.243+03:00] [OBICCS] [NOTIFICATION:1] [] [] [ecid: ] [sik: ] [tid: 2]  [71019] The connection with Oracle BI Server biprod-n1:9514 (monitor port 9515) was lost.

                                 

                                 

                                [2018-08-02T05:26:09.244+03:00] [OBICCS] [NOTIFICATION:1] [] [] [ecid: ] [sik: ] [tid: 2]  [71011] Oracle BI Server biprod-n1:9514 has transitioned to offline state.

                                 

                                 

                                [2018-08-02T05:26:14.244+03:00] [OBICCS] [NOTIFICATION:1] [] [] [ecid: ] [sik: ] [tid: 2]  [71020] A connection with Oracle BI Server biprod-n1:9514 (monitor port 9515) was established.

                                 

                                 

                                [2018-08-02T05:27:09.251+03:00] [OBICCS] [NOTIFICATION:1] [] [] [ecid: ] [sik: ] [tid: 2]  [71019] The connection with Oracle BI Server biprod-n1:9514 (monitor port 9515) was lost.

                                 

                                 

                                [2018-08-02T05:27:09.251+03:00] [OBICCS] [NOTIFICATION:1] [] [] [ecid: ] [sik: ] [tid: 2]  [71011] Oracle BI Server biprod-n1:9514 has transitioned to offline state.

                                 

                                 

                                [2018-08-02T05:27:14.252+03:00] [OBICCS] [NOTIFICATION:1] [] [] [ecid: ] [sik: ] [tid: 2]  [71020] A connection with Oracle BI Server biprod-n1:9514 (monitor port 9515) was established.

                                 

                                 

                                [2018-08-02T05:38:59.311+03:00] [OBICCS] [NOTIFICATION:1] [] [] [ecid: ] [sik: ] [tid: 2]  [71019] The connection with Oracle BI Server biprod-n1:9514 (monitor port 9515) was lost.

                                 

                                 

                                [2018-08-02T05:38:59.311+03:00] [OBICCS] [NOTIFICATION:1] [] [] [ecid: ] [sik: ] [tid: 2]  [71011] Oracle BI Server biprod-n1:9514 has transitioned to offline state.

                                 

                                 

                                [2018-08-02T05:39:04.312+03:00] [OBICCS] [NOTIFICATION:1] [] [] [ecid: ] [sik: ] [tid: 2]  [71021] An attempt to establish a connection with Oracle BI Server biprod-n1:9514 (monitor port 9515) failed.

                                 

                                 

                                [2018-08-02T05:39:04.403+03:00] [OBICCS] [ERROR:1] [] [] [ecid: ] [sik: ] [tid: 8]  [71092] Client with tenant ':ssi' (request type: 0) can not be assigned.

                                 

                                But I will update the blog once I find any answer from Oracle Support.

                                 

                                Thanks & Regards,

                                Abhi

                                • 13. Re: Facing a strange issue with OBI URL
                                  Christian Berg

                                  The support guys will ask for the exact same thing: log files with a higher log level.

                                  • 14. Re: Facing a strange issue with OBI URL
                                    Venkata Rachuri

                                    With out logs my Guess :

                                     

                                    These things only when two machines are not communicating with each other. Add 1st ip address to second machine etc/hosts file and vice versa.

                                     

                                    1)Were you able to ping machine 2 to machine 1 and wise versa ?

                                    2) is shared drive accessible on both machines ?

                                    3) why were you not able to restart. you have to start the node manager on second machine and start start.sh on first machine. Did you do that/

                                     

                                    Thanks

                                    Venkat

                                    1 2 Previous Next