OBIEE server logs analysis

Hesh

Hi,

OBIEE 12C version - 12.2.1.4.0

I need some help regarding analyzing OBIEE log files for investigation one incident happened today. Users were reporting that they were unable to login and reports performance was also an issue.

I can see following logs in OBIEE server, different logs got different errors, few are generic which are just produced by some reports or timeout error .. few are login issues Authentication errors..

I have tried but could't find any interesting things over there I believe I was not looking into them properly..

Can someone point me where to start with these logs?

Regards

Hesh

[Deleted User]

Hesh wrote:Can someone point me where to start with these logs?

Not really any other way to say this apart from: read the logs.

The topics you are mentioning are so vast and with so many implications that they require a lot of know-how as well as information. And the only way to have that information, interpret it and then gain that know-how is to read the logs, break them down and understand what's going on.

This goes way beyond the scope of a single OTN thread. It often entails long analysis and very large corrective actions since especially for the topic of performance the issue hardly ever is OBIEE at all.

Charles M

Hi Hesh,

In addition to what Christian has mentioned, you may be able to get started with these notes:

SRDC - Collecting Diagnostic Information for OBIEE 11g/ 12c Security Issues (Doc ID 1992262.1)    To BottomTo Bottom

OBIEE 12c: Quick Reference For Architecture, Lifecycle Management and File Locations (Doc ID 2067527.1)

What Files To Provide To Support When Encountering Authentication Or Security Issues in OBIEE 11g (Doc ID 1434514.1)

There is some helpful points.

Regards,

Charles

Hesh

Thanks Christian, Charles,

I felt the same, its a vast thing to look for .. the challenge here is  you have to ignore few and few are a symptom of other issues...

I will provide few errors here .. not sure if anyone may get something from this..

"

-- --------------------------------

####<Apr 29, 2019 7:22:06,491 AM BST> <Error> <HTTP> <XYZ-obiee-09.XXXX.com> <bi_server1> <[ACTIVE] ExecuteThread: '15' for queue:

'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <125c9a08-2cf2-4eeb-aafc-26cca6e0de9d-000abadf> <1556518926491> <[severity-value: 8]

[rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-101017> <[ServletContext@798922975[app:analytics module:analytics path:null spec-version:3.1]]

Root cause of ServletException.java.io.IOException: Connection reset by peer at sun.nio.ch.FileDispatcherImpl.write0(Native Method)

-- --------------------------------

[2019-04-29T07:16:49+01:00] [OBIPS] [ERROR:31] [] [saw.variableUtils] [ecid: 125c9a08-2cf2-4eeb-aafc-26cca6e0de9d-000ab4ed,0:1] [tid: 3442104064] [SI-Name: ]

[IDD-Name: ] [IDD-GUID: ] [userId: XYZ] A type mismatch occurred while evaluating an expression.[[

File:gdtypeconversions.cpp

Line:334

-- --------------------------------

[2019-04-29T07:20:32+01:00] [OBIPS] [NOTIFICATION:1] [] [saw.securitysubsystem.checkauthentication.runimpl]

[ecid: 125c9a08-2cf2-4eeb-aafc-26cca6e0de9d-000ab821,0:1:1] [tid: 2891765504] [SI-Name: ] [IDD-Name: ] [IDD-GUID: ] [userId: ] 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. (08004)State: HY000.  Code: 43113. 

[nQSError: 43113] Message returned from OBIS.

(HY000)

State: HY000.  Code: 43126.  [nQSError: 43126] Authentication failed: invalid user/password. (HY000)[[

File:checkauthentication.cpp

Line:1568

]]

-- --------------------------------

[2019-04-29T07:22:06+01:00] [OBIPS] [ERROR:16] [] [saw.rpc.server.handleConnection] [ecid: 005Xh9HTwxGFW7WFLzBT8A0007O^00000Z,0:275242] [tid: 2274428672]

[SI-Name: ] [IDD-Name: ] [IDD-GUID: ] [userId: ] Exception in handler thread. An error occurred during execution of "send". Broken pipe [Socket:106]

Error Codes: ETI2U8FA

Location: saw.rpc.variablemos.finalize, saw.rpc.server.responder, saw.rpc.server, saw.rpc.server.handleConnection,

saw.rpc.server.dispatch, saw.threadpool.socketrpcserver, saw.threads

[[

-- --------------------------------

[2019-04-29T08:20:46.311+01:00] [AdminServer] [NOTIFICATION] [] [oracle.dms.event] [tid: [STANDBY].ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)']

[userId: <WLS Kernel>]

[ecid: cf2c7b13-509f-489d-aa4b-10b14babdae5-00000004,0] [partition-name: DOMAIN] [tenant-name: GLOBAL] DMS-58081: The FlightRecorderDestination (id=JFRDestination)

can not function in this environment because although the JVMs flight recorder feature is present it is inactive.

Platform:WebLogic, VM:{'name'='Java HotSpot(TM) 64-Bit Server VM', 'version'='25.151-b12', 'spec-version'='1.8'}.[[

Cause: The JVM has a flight recorder feature but the flight recorder feature is not active.

Regards

Hesh

[Deleted User]

Sorry, that's still way too generic and high-level.

You need someone who knows how to troubleshoot and analyze an OBI server. As I said you can't learn that with just an OTN thread.

If you need support in this, feel free to contact me.

Hesh

Thank you Christian,

Really appreciate your help. How can I contact you.

Regards

Hesh