Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 221 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.8K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 83 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
BI Publisher Reports pulling blank and/or timeout errors with no modifications done

Wondering if anyone has run in to similar situations. We have custom SQL/BI Publisher Reports that are encountering unexplained issues. For example reports that have been in place for an extended period of time are now randomly pulling blank data or experiencing time out issues for users. In most cases there have been no modifications done to the data model or report themselves. We have seen some instances where clearing cache/cookies will resolve but in others we are seeing where data models have to be completely recreated to allow for functionality. Also, with timeouts the exact same data models with the only difference being the use of this NVL(HRC_SESSION_UTIL.GET_USER_PERSONID,-1) in place of a static value. Has anyone encountered similar issues? Any recommendations for solutions?
Answers
-
Hi Bradley,
Welcome to Oracle Analytics community.
Couple of things here:
- We recently faced a similar issue and found that one of the ESS jobs were running too long (running since last 10 days) and it caused the severe performance degrading of all BIP reports.
- There was another similar instance but that time it was due to a mass data upload happened as part of a merger.
I would suggest you to check any long running ESS jobs and see if killing them helps.
Thanks.
0