3 Replies Latest reply on Nov 6, 2015 9:14 AM by UnitedNations

    OBIEE Login failed with administrator

    user11928564

      Hello,

         we have a problem with login in Analytics with administrator user Oracle BIEE 11g.

       

      The problem does not occur every time you try to access.

       

      This is the sawlog8.log complete.

       

      [2015-10-21T10:50:08.000+02:00] [OBIPS] [ERROR:31] [] [saw.connectionPool.getConnection] [ecid: b0fe202250b53380:44a20624:150849d04b7:-8000-0000000000007afe,0:1:1] [tid: 1082173760] 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.securitysubsystem.checkauthentication.runimpl

        saw.threadpool.asynclogon

        saw.threads

      ecid: b0fe202250b53380:44a20624:150849d04b7:-8000-0000000000007afe,0:1:1

      ThreadID: 1082173760

      ]]

       

      We  don't have any information in nqserver.log

       

       

       

      Please, help me.

      Thanks

        • 2. Re: OBIEE Login failed with administrator
          user11928564

          Hello,

          thank you very much for the response.


          I tried to change the setting of defaultAuthenticator, but the problem remains.


          The error is the same:

          [2015-10-22T10:32:13.000+02:00] [OBIPS] [ERROR:31] [] [saw.connectionPool.getConnection] [ecid: b0fe202250b53380:64675610:1508ea50389:-8000-00000000000002dc,0:1:1] [tid: 1115396416] 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.securitysubsystem.checkauthentication.runimpl

            saw.threadpool.asynclogon

            saw.threads

          ecid: b0fe202250b53380:64675610:1508ea50389:-8000-00000000000002dc,0:1:1

          ThreadID: 1115396416

          ]]


          The version of OBIEE is Oracle Business Intelligence 11.1.1.7.150120


          Thanks



          • 3. Re: OBIEE Login failed with administrator
            UnitedNations

            Hi Techie,

             

            Any Solutions/Suggestion for the Issue, we too facing the same Issue on the same OBIEE Version.