Unable to Login Analytics

Venkat Thota - BIP

Hi everyone ,

I am trying to login to analytics but unable to logic ,can anyone help me with issue ,

sawlog:

State: 08004.  Code: 10018.  [NQODBC] [SQL_STATE: 08004] [nQSError: 10018] Access for the requested connection is refused.

[2016-09-19T12:22:55.000-04:00] [OBIPS] [ERROR:31] [] [saw.security.odbcuserpopulationimpl.searchidentities] [ecid: 0002Nvfc0YP81zJMymMaMG0005VI000000,0:2039] [tid: 1090] Error retrieving use
r/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.

Gianni Ceresa

Sorry but your aren't doing anything to help people helping you ...

As you wrote the word "analytics" in the OBIEE forum we can guess you try to login to OBIEE, that's you provide as information ...

How To Ask Questions The Smart Way

There are things like version, security setup (providers etc.) ...

Rampradeep Pakalapati

Hi,

I know i don't have much info to pinpoint the issue, As this seems to be issue with security and the error suggests you have either changed the RPD or catalog recently. Perform GUID refresh and try the same.

Thanks,

Rampradeep

Gianni Ceresa

Except if the OP is on 12c as GUID doesn't exist anymore ...

user13697368

Are u able to login EM or Console? If so, the issue is with your BISystemUser. You have to sync the password of BISystemUser in both EM and console.

Joel

As @Gianni Ceresa mentioned, it depends on whether @user13697368 is referring to OBIEE 11g or OBIEE 12c. User GUIDs don't exist in OBIEE 12c.

Could you provide some more information like screenshots, log files( sawnlog.log, nqserver.log), OBIEE version numbers etc if you want to get some help from this forum