3 Replies Latest reply on Apr 20, 2017 8:09 PM by Christian Berg

    Problem in OBIEE analytics , no login

    eretamales

      hi everyone

       

      I have  problems for login page analytic with user weblogic, but if login in weblogic console and em  without problem, in the page analytics, show the next error

       

      I see logs in OracleBIPresentation, found this error:

       

      [2017-04-20T13:11:17.000-03:00] [OBIPS] [ERROR:31] [] [saw.connectionPool.getConnection] [ecid: 005JPbZN1Cf7y0t5KfL6ie0002px000000,0:1419] [tid: 2463557376] Authentication Failure.

      Odbc driver returned an error (SQLDriverConnectW).

      State: 08004.  Code: 10018.  [NQODBC] [SQL_STATE: 08004] [nQSError: 10018] Access for the requested connection is refused.

      [nQSError: 43113] Message returned from OBIS.

      [nQSError: 43126] Authentication failed: invalid user/password. (08004)[[

      File:connection.cpp

      Line:436

      Location:

              saw.connectionPool.getConnection

              saw.security.odbcuserpopulationimpl.getbisystemconnection

              saw.security.odbcuserpopulationimpl.searchidentities

              saw.security.userpopulationmanagerimpl.searchidentities

              saw.catalog.dirCache.getAllSharedFolders

              saw.CatalogAttributes.cache.cleanup

              saw.taskScheduler.processJob

              taskscheduler

              saw.threads

      ecid: 005JPbZN1Cf7y0t5KfL6ie0002px000000,0:1419

      ThreadID: 2463557376

      task: Cache/CatalogAttributes

      ]]

      [2017-04-20T13:11:17.000-03:00] [OBIPS] [ERROR:1] [] [saw.security.odbcuserpopulationimpl.getbisystemconnection] [ecid: 005JPbZN1Cf7y0t5KfL6ie0002px000000,0:1419] [tid: 2463557376] Authentication Failure.

      Odbc driver returned an error (SQLDriverConnectW).

      State: 08004.  Code: 10018.  [NQODBC] [SQL_STATE: 08004] [nQSError: 10018] Access for the requested connection is refused.

      [nQSError: 43113] Message returned from OBIS.

      [nQSError: 43126] Authentication failed: invalid user/password. (08004)[[

      File:odbcuserpoploaderimpl.cpp

      Line:1020

      Location:

              saw.security.odbcuserpopulationimpl.getbisystemconnection

              saw.security.odbcuserpopulationimpl.searchidentities

              saw.security.userpopulationmanagerimpl.searchidentities

              saw.catalog.dirCache.getAllSharedFolders

              saw.CatalogAttributes.cache.cleanup

              saw.taskScheduler.processJob

              taskscheduler

              saw.threads

      ecid: 005JPbZN1Cf7y0t5KfL6ie0002px000000,0:1419

      ThreadID: 2463557376

      task: Cache/CatalogAttributes

      ]]

       

       

       

      I need we help pleease.

       

       

      thanks

        • 1. Re: Problem in OBIEE analytics , no login
          Gianni Ceresa

          Didn't you forget to add some quotes in the query of the init block "usuario_perfil" ? Because it takes the username as a column while you probably wanted something like UPPER('weblogic') instead.

           

          But you don't really provide a lot to give other answers ...

          • 2. Re: Problem in OBIEE analytics , no login
            eretamales

            Hi, I've the user weblogic to login in weblogic server console and analytics, with user weblogic I can login in console wls, but no the analytics webpage, I try change password user BISystemUser but nothing, only found the next error in the instance OracleBIPresentation

             

             

            Logs

             

            017-04-20T15:31:42.000-03:00] [OBIPS] [ERROR:31] [] [saw.security.odbcuserpopulationimpl.searchidentities] [ecid: 005JPbXHCAf7y0t5KfK6ye0004aB000000,0:3307] [tid: 2400450304] Error retrieving user/group data from Oracle BI Server's User Population API.

            Unable to create a system user connection to BI Server while running user population queries

            Authentication Failure.

            Odbc driver returned an error (SQLDriverConnectW).

            State: 08004.  Code: 10018.  [NQODBC] [SQL_STATE: 08004] [nQSError: 10018] Access for the requested connection is refused.

            [nQSError: 43113] Message returned from OBIS.

            [nQSError: 43126] Authentication failed: invalid user/password. (08004)[[

            File:odbcuserpoploaderimpl.cpp

            Line:731

            Location:

                    saw.security.odbcuserpopulationimpl.searchidentities

                    saw.security.userpopulationmanagerimpl.searchidentities

                    saw.catalog.dirCache.getAllSharedFolders

                    saw.CatalogAttributes.cache.cleanup

                    saw.taskScheduler.processJob

                    taskscheduler

                    saw.threads

            ecid: 005JPbXHCAf7y0t5KfK6ye0004aB000000,0:3307

            ThreadID: 2400450304

            task: Cache/CatalogAttributes

             

             

            I don't see when resolved.

            • 3. Re: Problem in OBIEE analytics , no login
              Christian Berg

              eretamales wrote:

               

              I try change password user BISystemUser but nothing, only found the next error in the instance OracleBIPresentation

               

              First of all it's not a clever idea to just start changing passwords. Especially BISystemUser who is inside several cwallets and the boot.properties if you use that.

               

              Best look at this document and go step by step: Advisor Webcast Troubleshooting OBIEE Login Issues