BI Publisher Reports pulling blank and/or timeout errors with no modifications done

bradley.smith2

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?

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/27094/bi-publisher-reports-pulling-blank-and-or-timeout-errors-with-no-modifications-done

Hi Bradley,

Welcome to Oracle Analytics community.

Couple of things here:

1. 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.
2. 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.

RVohra

• 3. Review BI Publisher report and middleware timeout settings.

• 4. Increase the timeout thresholds temporarily to see if reports complete successfully.

• 5. Since recreating data models sometimes fixes the problem, compare the metadata and session properties of the old and new models.

• 6. Export and diff the XML of data models to spot hidden differences.