Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

authnetication problem DSN configuration

Received Response
43
Views
7
Comments
933651
933651 Rank 2 - Community Beginner
edited Aug 13, 2024 5:56PM in Oracle Analytics Cloud and Server

Hello,

I have just installed oracle BI 12c. I am a newbie for Oracle BI.

Everything was ok. I can login from the web to Enterprise manager and to the console using weblogic user and pw.

I am now trying to login using Oracle BI client from windows. When trying to configure DSN ODBC data source , I put user weblogic and password but giving me error:

I am putting same password I put on the web for the conssole and for enterprise manager.

[nQSError: 10131] Open session failed[nQSError: 43113} Message from OBIS.

[nQSError: 43126] Authentication failed: invalid user/password.

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Is OBIEE really running? Can you login on the web page of OBIEE with these credentials?

    Weblogic Console and Enterprise Manager isn't OBIEE, they are on the weblogic Admin server and can perfectly works while OBIEE is down or your user can't login to OBIEE because you are missing the security (if you didn't import the default SampleSales Lite BAR etc.).

  • 933651
    933651 Rank 2 - Community Beginner

    IF you mean to login to http://ip addr:9502/analytics  then I can't do. The web page shows up but saying :

    An error occurred during authentication. Try again later or contact your system administrator.

    I think it is already strted because ./start.sh executed successfully. Maybe I have to do some other steps.

  • Syedsalmancs110
    Syedsalmancs110 Rank 6 - Analytics Lead

    Then the right way to go about it would be to check for more detailed error messages in sawlog(X).log and obis1-diagnostic.log, at below mentioned location respectively.

    <ORACLE HOME>\user_projects\domains\<DOMAIN NAME>\servers\obips1\logs

    <ORACLE HOME>\user_projects\domains\<DOMAIN NAME>\servers\obis1\logs

    feel free to share error message with us on community, of course hiding your environment specific details.

  • 933651
    933651 Rank 2 - Community Beginner

    In    <ORACLE HOME>\user_projects\domains\<DOMAIN NAME>\servers\obips1\logs

    location:

            saw.securitysubsystem.checkauthentication.runimpl

            saw.threadpool.asynclogon

            saw.threads

    ]]

    [2017-09-15T15:26:32+02:00] [OBIPS] [ERROR:1] [] [saw.securitysubsystem.checkauthentication.runimpl] [ecid: 2e78e8be-f8a2-4bbb-ac17-374cbfdb2652-00001a51,0:3:1] [tid: 1132295952] [SI-Name: ] [IDD-Name: ] [IDD-GUID: ] [userId: ] Odbc driver returned an error (SQLDriverConnectW).

    State: HY000.  Code: 10058.  [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.

    (HY000)

    State: HY000.  Code: 73025.  [nQSError: 73025] The Oracle BI Server is currently unavailable for queries. Please contact your System Administrator to report the failure. (HY000)[[

    File:checkauthentication.cpp

    Line:1595

    Location:

            saw.securitysubsystem.checkauthentication.runimpl

            saw.threadpool.asynclogon

            saw.threads

  • Gianni Ceresa
    Gianni Ceresa Mod 
    933651 wrote:I think it is already strted because ./start.sh executed successfully. Maybe I have to do some other steps.

    That's why next to start.sh you have status.sh giving you the exact status of your environment.

    What kind of install you did? Did you load the SampleSales Lite BAR file during install? Because if not ... your system is empty (totally empty) and it's kind of normal you can't do anything.

  • Syedsalmancs110
    Syedsalmancs110 Rank 6 - Analytics Lead

    Check for other mentioned log as well and focus on what Gianni is pointing out

    What kind of install you did? Did you load the SampleSales Lite BAR file during install? Because if not ... your system is empty (totally empty) and it's kind of normal you can't do anything.

  • 933651
    933651 Rank 2 - Community Beginner

    From ./status.sh I see that everything is running.

    I have installed Oracle BI standart edition one on oracle  linux OS.

    During the execution of ./config.sh I selected Oracle sample application (SampleAppLite) but after finishing I did nothing more and started to try connecting.

    Is there any other step to be done?