Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Different Physical Query generating in different OBIEE environments.

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
Answers
-
Hello,
0. The dummy.question:.your.connection.pool has the same database setting(ip, port, sid)
1. Do you see any data security settings?
2. Do you has some session initialization blocks? In your physical query?
Kind regards,
0 -
Hi Cesar,
Thanks for the reply.
The RPD is same in both the environments.
So the connection pool and security is in sync.This is basically due to a Ago column which we are using. Generally obiee generates single query with subqueries pointing one to the selected month and one to the ago month.
This is happening on Pre Prod.
But in Prod env. obiee is generating 2 standalone queries, with one pointing to Selected month and one pointing to the ago month.
Regards,
Avinash Sharma
0 -
Hi,
Please check the database features between the two environments.
Are they similar??
Regards,
Akansh Agarwal
0 -
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
0 -
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?
0