Oracle Fusion HCM Analytics

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Fusion Data Intelligence› Oracle Fusion HCM Analytics

Categories

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

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

Received Response
19
Views
2
Comments
bradley.smith2
bradley.smith2 Rank 1 - Community Starter
in Oracle Fusion HCM Analytics

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

  • MandeepGupta
    MandeepGupta Rank 8 - Analytics Strategist
    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
    RVohra Rank 6 - Analytics Lead
    • 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.