nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

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

Find more posts tagged with

Accepted answers

All comments

[Deleted User]

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

No back up to revert to?

[Deleted User]

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

Rama0830

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

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]

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

Teresa Modesta

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]

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

Hi,

I have deleted the screenshot and just posted the link.

Thank you,