Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Report refresh is very poor in OBIEE single node 12.2.1.1.0

Login is slow & refreshing reports is slow too.
Refreshing reports or dashboards when Report has writeback enabled or has hierarchies --> it takes time as compared to running same sql against the database.
Checked one such report and it took 51 sec's on bi_server1.
Log from bi_Server1
####<Dec 9, 2016, 7:50:26,98 PM EST> <Info> <JDBC> <rac8503e.dc.ricohonline.org> <bi_server1> <[ACTIVE] ExecuteThread: '36' for queue: 'weblogic.kernel.Default (self-tu
ning)'> <<WLS Kernel>> <> <df2b7e4c-64ae-4a22-bde3-46618d03ff7a-0000078c> <1481331026098> <[severity-value: 64] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <B
EA-001128> <Connection for pool "opss-data-source" has been closed.>
####<Dec 9, 2016, 7:50:27,633 PM EST> <Info> <Common> <rac8503e.dc.ricohonline.org> <bi_server1> <Essbase Agent Heartbeat Daemon> <<WLS Kernel>> <> <df2b7e4c-64ae-4a22-
bde3-46618d03ff7a-000000a4> <1481331027633> <[severity-value: 64] [rid: 0:7] [partition-id: 0] [partition-name: DOMAIN] > <BEA-000628> <Created "1" resources for pool "
biplatform_datasource", out of which "1" are available and "0" are unavailable.>
####<Dec 9, 2016, 7:52:03,862 PM EST> <Info> <Common> <rac8503e.dc.ricohonline.org> <bi_server1> <[ACTIVE] ExecuteThread: '12' for queue: 'weblogic.kernel.Default (self
Following error was seen in the saw log :
[2016-12-09T19:53:19-05:00] [OBIPS] [ERROR:31] [] [saw.views.evc.activate] [ecid: df2b7e4c-64ae-4a22-bde3-46618d03ff7a-00000794,0:2] [tid: 5400] [SI-Name: ] [IDD-Name:
] [IDD-GUID: ] [userId: PFERRAND] Could not find privilege: Delete[[
And this error comes when ever reports takes long time to refresh.
Also checked on following points with customer :
1- Check the performance tuning guide for JVM for Manged server logs , section 2.3 which is done.
2- Re-bounced the system which is done several time.
3- Re-started the services done also.
4-Issue is happening for all reports regardless of writeback enabled or not and for all users.
5-Customer has SAML -SSO enabled on 12.2.1.1
KM research :
OBIEE 12c: How To Bind The OBIEE Components To A Specific Listen Address (Doc ID 2193508.1)
Please let me know if any one has any idea on this issue .
Thanks,
Anshu
Answers
-
2955702 wrote:Login is slow & refreshing reports is slow too.
Compared to what?
Is it a feeling like it's slower than something else? Did you just expected something else?
Did you spent some time analysing what your system does?
Worth a look at @rmoff Silver Bullets presentation: https://speakerdeck.com/rmoff/still-no-silver-bullets-obiee-12c-performance-in-the-real-world
(or video https://www.youtube.com/watch?v=0W34l2O9GMo )
0 -
+1 to Gianni. You have to do a proper analysis.
0