OBIEE 11g - Application Is Slow While Logging In

Error:

Even though entering correct credentials in OBIEE login screen, it takes a long time(4-6 mins) to open the homepage.

Cause:

There might be initialisation blocks defined in repository which are failing to give default values to variable defined in IB. This will make login slower for sure.

Solution:

At the time of login, OBIEE runs all the queries specified in all active initialisation blocks available in rpd. If these queries are taking time to make a connection to the specified DB or to retrieve values after a successful connection, you will observe delay in login to the OBIEE system.

To avoid this, you can disable all the IB which are not usable or de-scoped. From the log, you can identify which connection pools are taking time to establish the connection and which one are failing. Disable this for a moment, reload metadata and try login in again. You should get a smoother login at this time.

Hope this helps, happy blogging. :-)