Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

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

Unable to Login Analytics

Received Response
31
Views
5
Comments
Venkat Thota - BIP
Venkat Thota - BIP Rank 7 - Analytics & AI Coach
edited Aug 13, 2024 6:12PM in Oracle Analytics Forum

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.

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    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
    Rampradeep Pakalapati Rank 3 - Community Apprentice

    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
    Gianni Ceresa Mod

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

  • user13697368
    user13697368 Rank 1 - Community Starter

    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 Acha
    Joel Acha Rank 8 - Analytics & AI Strategist

    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