Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

OBIEE reports hanging after being amended

Received Response
12
Views
1
Comments
user10094133
user10094133 Rank 1 - Community Starter
edited Aug 13, 2024 7:09PM in Oracle Analytics Cloud and Server

We are on OBIEE version 1.1.7 having upgraded from version 1.1.5 and are getting the following behaviour

Reports coming from an Oracle database subject area will not return after being an object is changed. The reports return data unchanged.

Our support person can run and change the report in our UAT environment without an issue, but if it done in Production then report hangs

The only way to get the reports to run in Production is to copy the UAT explain plan into Production.

Any advice would be appreciated.

Answers

  • rmoff
    rmoff Rank 6 - Analytics Lead

    "report hangs" <-- can you be more specific please. Does the query execute on the database but not return in OBIEE? Or it doesn't run in the database either? Use nqquery.log to trace what is actually happening with execution.