Different Physical Query generating in different OBIEE environments.

Question

Hi All,

Recently, we encountered a issue in OBIEE 11g where we were facing data difference in Pre Prod and Prod Env.

This is due to the difference in the Physical Query which OBIEE was generating in both the Environments. Even when the Web Catalogue and RPD is same in both the environments, the physical queries are different.

Could anyone help me understand, what could be the possible reason for this?

Really appreciate any response on this.

Regards,

Avinash Sharma

rmoff · Answer

DB Features is a configuration option within your RPD and environment : https://docs.oracle.com/middleware/11119/biee/BIEMG/conn_pool.htm#BIEMG1268

It can cause vastly different SQL generation.

In addition - are your environments at the same OBIEE patchset level?

3192044 · Answer

Hi Akansh,

The OBIEE physical query is generating in different way.

Could you specify what all database feature you are thinking of?

Regards,

Avinash Sharma

AkanshAgarwal · Answer

Hi,

Please check the database features between the two environments.

Are they similar??

Regards,

Akansh Agarwal