Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIS - Authentication failed: invalid user/password

Received Response
42
Views
9
Comments
Rama0830
Rama0830 Rank 3 - Community Apprentice
edited Aug 13, 2024 5:47PM in Oracle Analytics Cloud and Server

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

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    First top tip: You posted the content of a MOS Document which is explicitly forbidden and hence illegal by the terms of use of Oracle Support: https://www.oracle.com/support/supportportalterms.html

    Second: re-installing the environment takes a lot less time than correct such a mistake - believe me.

  • Teresa Modesta
    Teresa Modesta Rank 5 - Community Champion

    No back up to revert to?

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Looking at the OP's approach I would wager....No, there are no backups X-D

  • Rama0830
    Rama0830 Rank 3 - Community Apprentice

    Hi Christian,

    My apologies, I have seen some posts where some ppl have posted, so I posted thinking that it would help in understanding the issue.

    Won't repeat that next time.

    Thank you,

    Rama

  • Rama0830
    Rama0830 Rank 3 - Community Apprentice

    Hi,

    So, if we don't have a backup, is it going to very difficult to fix this issue? I am not a DBA, I need to check with them.

    Thank you,

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Post a link. Never the content. Oracle Support is secured and only accessible with a valid Support Identifier for a reason.

  • Teresa Modesta
    Teresa Modesta Rank 5 - Community Champion

    Christian is telling you; -

    1. Delete the document from MOS above or you could be in trouble with the boards

    2. You will have to reinstall to fix it OR revert to back up - those are the options

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Yes LFG said it right: backup or re-install.

    By the way, why DBA? OBI is an analytical platform, not just a DB package.

  • Rama0830
    Rama0830 Rank 3 - Community Apprentice

    Hi,

    I have deleted the screenshot and just posted the link.

    Thank you,