Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 42 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 54 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 19 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
OBIEE reports hanging after being amended
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
-
"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.
0