OBIEE 12c page switch taking time

Question

Hi All,

We have installed obiee 12.2.1.2 version on linux version 6. Deployed everything proper but when after login when we switch from page to other or from results to criteria or from one page to another its taking time.

Performace of page refresh is not good, so when we checked the sawserver log found below warnings.

2017-05-22T06:05:29Z] [OBIPS] [WARNING:16] [] [saw.meminfo.threadpool.asynclogon] [ecid: 005K1QcCKdx7EC2_Rpt1id0001N500005^,0] [tid: 4215371520] [SI-Name: ] [IDD-Name: ] [IDD-GUID: ] [userId: ] ThreadPool<AsyncLogon:1>: Memory usage log - Allocs: 437649, Net: 77300; Bytes Alloc'd: 360332540, Net: 194011808; System Bytes: 167772160, Net: 167772160; Peak-Bytes: 236008521.[[

File:threadpool.cpp

Line:1021

Location:

saw.meminfo.threadpool.asynclogon

saw.threadpool.asynclogon

saw.threads

]]

[2017-05-22T06:10:58Z] [OBIPS] [WARNING:16] [] [saw.odbc.statement.execute.timings] [ecid: 4ac707eb-c4b7-4a96-b3e3-966330e531d1-00000230,0:1:152] [tid: 2817337088] [SI-Name: ] [IDD-Name: ] [IDD-GUID: ] [userId: ] SQLExecDirectW returned in 289807 msec(s).[[

File:odbcstatementimpl.cpp

Line:160

Location:

saw.odbc.statement.execute.timings

saw.odbc.statement.execute

saw.queryCache.odbcExecuter.execute

saw.querycache.executeQuery

saw.threadpool.query

saw.threads

ConnId: 1

StmtId: 29

Please help to know what are this warnings indicate and how can we eliminate it.

Thanks,

Sandeep

3310714 · Answer

Hi,

I think OBIEE logs all sorts of warnings/errors even when no one is using the system.  So it might not be the warning for your issue.  You said things are slow, could it because the query takes a long time to run?  Are you able to run the query against the DB to see how long that takes?

sandy45252 · Answer

We are not using any Direct Database requests in reports or Dashboards.

Syedsalmancs110 · Answer

Check below document is this something similar to your issue

Switching Dashboards In OBIEE 11g (11.1.1.9.0) Fails To Display | Hangs | Load Until The Original Dashboard Is Rendered (Doc ID 2075808.1)

The document states 11.1.1.9.0 but the Bug for this issue is said to be fixed in 12.2.2.0.0, so not sure if fix for this bug has been already included in 12.2.1.2.0

Check with Oracle Support on same whether Patch is available for this issue on top of 12.2.1.2.0, if this is not similar to your issue then you need capture fiddler trace(a free web debugging proxy which logs all HTTP(s) traffic between your computer and the Internet. Use it to debug traffic from virtually any application that supports a proxy like IE, Chrome, Safari, Firefox, Opera and more) for further diagnosis of issue