3 Replies Latest reply on Jul 15, 2015 11:33 AM by Sagar Tippe

    Not able to login into analytics page but able to login into em and console through weblogic user..

    Prashant_Reddy

      Hi all,

       

      OBIEE Version = 11.1.1.7.0

      OS = Linux (RHL 5.8 64 bit)

       

      Not able to login into analytics page but able to login into em and console..

       

      sawlog2.log:

      [2015-07-14T15:26:41.000+05:30] [OBIPS] [ERROR:1] [] [saw.security.odbcuserpopulationimpl.getbisystemconnection] [ecid: 0056g39DdOADkZWFLzRL8A0002K3000000,0:17438] [tid: 1110395200] 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:1015

      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: 0056g39DdOADkZWFLzRL8A0002K3000000,0:17438

      ThreadID: 1110395200

      task: Cache/CatalogAttributes

      ]]

      [2015-07-14T15:26:41.000+05:30] [OBIPS] [ERROR:31] [] [saw.security.odbcuserpopulationimpl.getbisystemconnection] [ecid: 0056g39DdOADkZWFLzRL8A0002K3000000,0:17438] [tid: 1110395200] 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:1018

      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: 0056g39DdOADkZWFLzRL8A0002K3000000,0:17438

      ThreadID: 1110395200

      task: Cache/CatalogAttributes

      ]]

      [2015-07-14T15:26:41.000+05:30] [OBIPS] [ERROR:31] [] [saw.security.odbcuserpopulationimpl.searchidentities] [ecid: 0056g39DdOADkZWFLzRL8A0002K3000000,0:17438] [tid: 1110395200] 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:726

      Location:

        saw.security.odbcuserpopulationimpl.searchidentities

        saw.security.userpopulationmanagerimpl.searchidentities

        saw.catalog.dirCache.getAllSharedFolders

        saw.CatalogAttributes.cache.cleanup

        saw.taskScheduler.processJob

        taskscheduler

        saw.threads

      ecid: 0056g39DdOADkZWFLzRL8A0002K3000000,0:17438

      ThreadID: 1110395200

      task: Cache/CatalogAttributes

       

      nqserver.log:

       

      [2015-07-14T15:26:40.000+05:30] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 0056g39DdOADkZWFLzRL8A0002K3000000] [tid: 443bb940] FailedAuthentication : The security token cannot be authenticated.

      [2015-07-14T15:26:40.000+05:30] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 0056g39DdOADkZWFLzRL8A0002K3000000] [tid: 443bb940] [nQSError: 43126] Authentication failed: invalid user/password.

       

      Workaround:

      -Check password in both em and console.

      -Able to connect DEV_MDS and DEV_PLATFORM schema.

      -Checks User & groups and Roles policy.

       

      Regards

      Prashant Reddy