OBIEE 11g - Reports sourced from PostgreSQL Database using DataDirect 7.0.1 ODBC Driver Doesn't Execute Simultaneously (Doc ID 2117169.1)

Last updated on JULY 17, 2017

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.7.0 and later
Linux x86-64

Symptoms

On using Oracle Business Intelligence Enterprise Edition (OBIEE) 11g and getting data from PostgreSQL database using DataDirect 7.0.1 ODBC driver, it is noticed that the OBIEE reports are executed one after the other and there is an issue with the performance in the execution of the reports.

For example:

There are 2 reports as described below:

Report01, with small number of records-> This report returns results in seconds.
Report02, with huge number of records->This report returns results in minutes.

Test1 -

1. Execute Report01 by TestUser1.
2. Execute Report02 by TestUser2.

In this scenario, it is noticed that Report01 returns results in seconds and Report02 returns results in minutes.

Test2 -

1. Execute Report01 by TestUser2.
2. Execute Report02 by TestUser1.

In this scenario, it is noticed that Report01 returns results in minutes and it looks like Report01 is waiting for Report02 to finish.

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