Problem in OBIEE analytics , no login

Question

hi everyone

I have  problems for login page analytic with user weblogic, but if login in weblogic console and em  without problem, in the page analytics, show the next error

I see logs in OracleBIPresentation, found this error:

[2017-04-20T13:11:17.000-03:00] [OBIPS] [ERROR:31] [] [saw.connectionPool.getConnection] [ecid: 005JPbZN1Cf7y0t5KfL6ie0002px000000,0:1419] [tid: 2463557376] 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.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: 005JPbZN1Cf7y0t5KfL6ie0002px000000,0:1419

ThreadID: 2463557376

task: Cache/CatalogAttributes

]]

[2017-04-20T13:11:17.000-03:00] [OBIPS] [ERROR:1] [] [saw.security.odbcuserpopulationimpl.getbisystemconnection] [ecid: 005JPbZN1Cf7y0t5KfL6ie0002px000000,0:1419] [tid: 2463557376] 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:1020

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: 005JPbZN1Cf7y0t5KfL6ie0002px000000,0:1419

ThreadID: 2463557376

task: Cache/CatalogAttributes

]]

I need we help pleease.

thanks

[Deleted User] · Answer

eretamales wrote:I try change password user BISystemUser but nothing, only found the next error in the instance OracleBIPresentation

First of all it's not a clever idea to just start changing passwords. Especially BISystemUser who is inside several cwallets and the boot.properties if you use that.

Best look at this document and go step by step:

eretamales · Answer

Hi, I've the user weblogic to login in weblogic server console and analytics, with user weblogic I can login in console wls, but no the analytics webpage, I try change password user BISystemUser but nothing, only found the next error in the instance OracleBIPresentation

Logs

017-04-20T15:31:42.000-03:00] [OBIPS] [ERROR:31] [] [saw.security.odbcuserpopulationimpl.searchidentities] [ecid: 005JPbXHCAf7y0t5KfK6ye0004aB000000,0:3307] [tid: 2400450304] 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:731

Location:

saw.security.odbcuserpopulationimpl.searchidentities

saw.security.userpopulationmanagerimpl.searchidentities

saw.catalog.dirCache.getAllSharedFolders

saw.CatalogAttributes.cache.cleanup

saw.taskScheduler.processJob

taskscheduler

saw.threads

ecid: 005JPbXHCAf7y0t5KfK6ye0004aB000000,0:3307

ThreadID: 2400450304

task: Cache/CatalogAttributes

I don't see when resolved.

Gianni Ceresa · Answer

Didn't you forget to add some quotes in the query of the init block "usuario_perfil" ? Because it takes the username as a column while you probably wanted something like UPPER('weblogic') instead.

But you don't really provide a lot to give other answers ...