0 Replies Latest reply on Jun 6, 2018 2:45 PM by Rama0830

    OBIS - Authentication failed: invalid user/password

    Rama0830

      I have accidentally removed BISystem role from EM --> Application Role, which I have added it back exactly as it is mentioned in the below blog:-

       

      OBIEE Sagar !!! : Accidentally deleted BISystem Role

       

      And also I made sure that the BISystemUser password is in Synchronise with Weblogic Console and in Enterprise Manager by following steps from the below link.

       

      https://support.oracle.com/knowledge/Enterprise%20Performance%20Management%20and%20Business%20Intelligence/1285899_1.htm…

       

      After doing the above two steps, I had restarted the BI Server, but it still failing with System components showing 5 Services Up and 1 Down. When I looked at most recent sawlog file, it displays the following message:-

       

      "

      [2018-06-06T23:14:49.000+10:00] [OBIPS] [ERROR:31] [] [saw.connectionPool.getConnection] [ecid: ] [tid: ] 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:471

      Location:

      saw.connectionPool.getConnection

      saw.security.odbcuserpopulationimpl.getbisystemconnection

      saw.security.odbcuserpopulationimpl.searchidentities

      saw.security.userpopulationmanagerimpl.initializeroles

      saw.security.securityimpl.initialize

      saw.catalog.local.loadCatalog

      saw.subsystems.catalogbootstrapper.loadcatalog

      saw.webextensionbase.init

      saw.sawserver

      saw.sawserver.initializesawserver

      saw.sawserver

      ]]

      [2018-06-06T23:14:49.000+10:00] [OBIPS] [ERROR:31] [] [saw.security.odbcuserpopulationimpl.getbisystemconnection] [ecid: ] [tid: ] Could not create a system user connection to Oracle BI Server during start-up. Please check the error message and try again.

      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:1033

      Location:

      saw.security.odbcuserpopulationimpl.getbisystemconnection

      saw.security.odbcuserpopulationimpl.searchidentities

      saw.security.userpopulationmanagerimpl.initializeroles

      saw.security.securityimpl.initialize

      saw.catalog.local.loadCatalog

      saw.subsystems.catalogbootstrapper.loadcatalog

      saw.webextensionbase.init

      saw.sawserver

      saw.sawserver.initializesawserver

      saw.sawserver

      ]]

      [2018-06-06T23:14:49.000+10:00] [OBIPS] [ERROR:31] [] [saw.security.odbcuserpopulationimpl.searchidentities] [ecid: ] [tid: ] Error retrieving user/group data from Oracle BI Server's User Population API.

      Could not create a system user connection to Oracle BI Server during start-up. Please check the error message and try again.

      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:462

      Location:

      saw.security.odbcuserpopulationimpl.searchidentities

      saw.security.userpopulationmanagerimpl.initializeroles

      saw.security.securityimpl.initialize

      saw.catalog.local.loadCatalog

      saw.subsystems.catalogbootstrapper.loadcatalog

      saw.webextensionbase.init

      saw.sawserver

      saw.sawserver.initializesawserver

      saw.sawserver

      ]]

      [2018-06-06T23:14:49.000+10:00] [OBIPS] [ERROR:10] [] [saw.security.userpopulationmanagerimpl.initializeroles] [ecid: ] [tid: ] Error retrieving user/group data from Oracle BI Server's User Population API.

      Could not create a system user connection to Oracle BI Server during start-up. Please check the error message and try again.

      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:userpopulationmanagerimpl.cpp

      Line:279

      Location:

      saw.security.userpopulationmanagerimpl.initializeroles

      saw.security.securityimpl.initialize

      saw.catalog.local.loadCatalog

      saw.subsystems.catalogbootstrapper.loadcatalog

      saw.webextensionbase.init

      saw.sawserver

      saw.sawserver.initializesawserver

      saw.sawserver

      ]]

      [2018-06-06T23:14:49.000+10:00] [OBIPS] [NOTIFICATION:1] [] [saw.security.userpopulationmanagerimpl.initializeroles] [ecid: ] [tid: ] Error searching roles in the backend to resolve GUIDs during user population manager initialization[[

      File:userpopulationmanagerimpl.cpp

      Line:280

      Location:

      saw.security.userpopulationmanagerimpl.initializeroles

      saw.security.securityimpl.initialize

      saw.catalog.local.loadCatalog

      saw.subsystems.catalogbootstrapper.loadcatalog

      saw.webextensionbase.init

      saw.sawserver

      saw.sawserver.initializesawserver

      saw.sawserver

      ]]

      [2018-06-06T23:14:49.000+10:00] [OBIPS] [ERROR:31] [] [saw.security.userpopulationmanagerimpl.initializeroles] [ecid: ] [tid: ] Error retrieving user/group data from Oracle BI Server's User Population API.

      Could not create a system user connection to Oracle BI Server during start-up. Please check the error message and try again.

      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:userpopulationmanagerimpl.cpp

      Line:281

      Location:

      saw.security.userpopulationmanagerimpl.initializeroles

      saw.security.securityimpl.initialize

      saw.catalog.local.loadCatalog

      saw.subsystems.catalogbootstrapper.loadcatalog

      saw.webextensionbase.init

      saw.sawserver

      saw.sawserver.initializesawserver

      saw.sawserver

      ]]

      [2018-06-06T23:14:49.000+10:00] [OBIPS] [ERROR:1] [] [saw.catalog.local.loadCatalog] [ecid: ] [tid: ] Error initializing/loading existing Catalog: D:\Oracle\OBIEE\instances\instance1/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/catalog/SampleAppLite.

      Error retrieving user/group data from Oracle BI Server's User Population API.

      Could not create a system user connection to Oracle BI Server during start-up. Please check the error message and try again.

      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:localwebcatalog.cpp

      Line:395

      Location:

      saw.catalog.local.loadCatalog

      saw.subsystems.catalogbootstrapper.loadcatalog

      saw.webextensionbase.init

      saw.sawserver

      saw.sawserver.initializesawserver

      saw.sawserver

      ]]

      [2018-06-06T23:14:49.000+10:00] [OBIPS] [NOTIFICATION:1] [] [saw.sawserver] [ecid: ] [tid: ] Oracle BI Presentation Services are shutting down.[[

      File:sawserver.cpp

      Line:867

      Location:

      saw.sawserver

      saw.sawserver.terminatesawserver

      saw.sawserver

      ]]

      "

      Have no clue where to proceed for next step.

       

      I could see a few archived forum posts, but didn't help. So I have posted this as a new question.

       

      I greatly appreciate your help.

       

      Thanks Rama