authnetication problem DSN configuration

933651

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.

Gianni Ceresa

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

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

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

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

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

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

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?