OBIEE 11g: Presentation Server Navigation Performance And Login Is Very Slow (Doc ID 1337665.1)

Last updated on JANUARY 23, 2017

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.5.0 [1308] and later
Business Intelligence Suite Enterprise Edition - Version 11.1.1.5.0 [1308] and later
Information in this document applies to any platform.
*** Checked for relevancy 2-26-14 ***

Symptoms

Environment has 4 tiers
All Windows 2008 32-bit with 16-32 GB memory
2 - Tiers are MS IIS Web Servers for HTTP caching/compression
2- Tiers are primary and secondary scale-out. Both Primary and Secondary run 2 BI Servers and 1 Presentation Server.

Logging in takes between 4-10 minutes.
Once logged in, if you hover the mouse over My Dashboards to get a list, then it spins
click on dashboard link, the image keeps revolving and the dashboard list does not come up.

Navigating is very slow.

This is related to <NOTE:1334531.1> - 'After An OBIEE 11g Upgrade, The 'My Dashboard' Link Displays A 'Spinning' Icon And Never Returns'; however, the focus of the symptom here is the very long login time.

Changes

A catalog upgrade was originally performed from OBIEE 10.1.3.4.1 to 11.1.1.5.

There was in interim upgrade to 11.1.1.3, during this time application areas 'ABC' and 'XYZ' were developed in 11.1.1.3, this catalog was upgraded to 11.1.1.5

Then, the two catalogs were merged.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms