Unable to login to obiee 12c analytics after restarting the machine

Helan Kumar

OBIEE 12.2.1.1

I have installed OBIEE 12c in windows 7 and i'm able to login to Console and EM. Also able to start/stop bi_server1/bi components

Weblogic server is up and running

Node manager is up and running

bi_server1 is up and running

All the services/bi components are up and running

All the deployment components are in active state in console

Issue : When i login to Analytics, i'm getting the following error with weblogic, same worked will immediately after installation. Issue started after restarting the machine

before installation i didn't set the static address for the loop back adapter which was created, setting the same after installation also no use.  Please share and suggest your experience on the same.

error message from analytics screen

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

Error Log from Sawlog0

[2017-07-17T16:15:52+05:30] [OBIPS] [ERROR:1] [] [saw.securitysubsystem.checkauthentication.runimpl] [ecid: ] [tid: 3840] [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:1606

Location:

              saw.securitysubsystem.checkauthentication.runimpl

              saw.threadpool.asynclogon

              saw.threads

]]

Thanks in advance

saketsrv

Hi ,

As you mentioned , Issue started only after restarting the machine ,so was there any patching activity done on the server?

Check if all the required OS Kernal patches for the application is still intact or not.

Michael Verzijl

Server? He installed OBIEE 12c on Windows-7

Please see: https://dimensionality.ch/2017/05/06/installing-oracle-bi-on-windows-7-8-10/

saketsrv

Oh..Sorry..Missed it

JamiePeakIndicators

Hi,

I'm assuming when you say you have installed on Win 7, it's a standalone locally running install...

If you're sure everything is running it could be your IP. You could try adding your static IP to the hosts file on your machine, at the following location...

C:\Windows\System32\drivers\etc\hosts

Thanks,

Jamie.

Gianni Ceresa

So not a supported OS, a desktop OS instead of a server OS, not setting an address (static) to the fake adapter which is supposed to be the only way for OBIEE to have a fixed matching hostname/ip and restarting your laptop probably getting a new IP from the DHCP ...

There were little chance (just to not say no chance at all) it could survive a restart. Actually you are already lucky it worked once before the restart (or maybe it didn't?).

Maybe better to move to a VM with a supported OS and an environment a bit more controlled avoiding this kind of issues.

[Deleted User]

@Helan Kumar https://dimensionality.ch/2017/05/06/installing-oracle-bi-on-windows-7-8-10/

Helan Kumar

Yeah i have made those entries post installation. This resolved node manager and bi_server start up issue

Helan Kumar

Was trying to install Oracle BIEE 12c SampleApp v607 V

While importing .ova file getting this error

Could not create the imported medium 'C:\Users\hmungaru\VirtualBox VMs\SampleAppv607p-appliance\SampleAppv607p-appliance-disk1.vmdk'.

VMDK: Compressed image is corrupted 'C:\Users\hmungaru\SampleAppv607p-appliance-disk1.vmdk' (VERR_ZIP_CORRUPTED).

Result Code:	VBOX_E_FILE_ERROR (0x80BB0004)
Component:	ApplianceWrap
Interface:	IAppliance {8398f026-4add-4474-5bc3-2f9f2140b23e}

i thought my downloaded file was corrupted and started downloading the complete set of SampleAppv607 for the second time and tried importing. Issue is still the same. Any suggestions appreciated. i even reinstalled VirtualBox no use

One more observation, while exporting the file using 7zip i see two errors. Unexpected end of data and CRC failed

[Deleted User]

What did you use to unzip the files? Just the Windows garbage or a proper tool like 7zip?

Gianni Ceresa

Your files are named wrong!!!

Look at the original files on the webpage, look at the file names in the Deployment Guide and look at your files : yours have the wrong names.

Files are named *.001 , *.002, *.003, *.004, *.005 while yours are *.001.zip, *.002.zip etc.

Display the real extension of your files in your Windows and rename them correctly. Once done the extract with 7zip of the *.001 will extract automatically all of them and the .ova will be fine !