Different Physical Query generating in different OBIEE environments. — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Different Physical Query generating in different OBIEE environments.

Received Response
1
Views
5
Comments
3192044
3192044 Rank 1 - Community Starter

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

  • cesar.advincula.o
    cesar.advincula.o Rank 6 - Analytics Lead

    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,

  • 3192044
    3192044 Rank 1 - Community Starter

    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

  • AkanshAgarwal
    AkanshAgarwal Rank 4 - Community Specialist

    Hi,

    Please check the database features between the two environments.

    Are they similar??

    Regards,

    Akansh Agarwal

  • 3192044
    3192044 Rank 1 - Community Starter

    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

  • rmoff
    rmoff Rank 6 - Analytics Lead

    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?