Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Problem in OBIEE analytics , no login
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
Answers
-
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 ...
0 -
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.
0 -
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.
0
