Oracle Analytics Publisher

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

Categories

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

BIP report bursting is giving output failed issue

Received Response
730
Views
7
Comments
Bhavna-Civeo
Bhavna-Civeo Rank 1 - Community Starter
in Oracle Analytics Publisher

Hi,

Have created BIP report which is generated output in excel using RTF template, while trying to schedule the report Adding Destination as Email type, it's sending email with report.

However when using bursting option, it's giving following error:


Waiting Time: 0.9 seconds

Data Fetch Time: 0.5 seconds

Total Execution Time: 44.8 seconds

Job Priority: Normal


Output failed.

[INSTANCE_ID=bip.bi_server1] [SUBJOB_ID=108279]

Waiting Time: 0.9 seconds

Data Fetch Time: 0.5 seconds

Total Execution Time: 19.5 seconds

Job Priority: Normal


Total sub-jobs:1473 Processed sub-jobs:262

[INSTANCE_ID=bip.bi_server1]

[INSTANCE_ID=bip.bi_server1]


Please advise.


Regards,

Bhavna

Tagged:

Answers

  • mikaromo
    mikaromo Rank 1 - Community Starter

    Hello, have you identified the root cause of this? I am having similar problem. Thanks.

  • Mallikarjuna Kuppauru-Oracle
    Mallikarjuna Kuppauru-Oracle Rank 8 - Analytics Strategist

    Hi @ Bhavna-Civeo

    Are you seeing any Error from publisher.log file?

    Regards,

    Arjun

  • Abhilash K - Deloitte USI
    Abhilash K - Deloitte USI Rank 5 - Community Champion

    Check if the template name, locale and output format is correct in Bursting query. Also the parameter6 should be true.

    Please review and post results.

    Thanks

    Abhilash

  • Puja Saha
    Puja Saha Rank 1 - Community Starter
    edited January 8

    Try using OUTPUT_FORMAT as 'XLSX' in bursting query.

  • Sathish Kumar Pattipati
    Sathish Kumar Pattipati Rank 1 - Community Starter

    After adding Output format value as XLSX it worked for me.

  • Mallikarjuna Kuppauru-Oracle
    Mallikarjuna Kuppauru-Oracle Rank 8 - Analytics Strategist

    HI @Bhavna-Civeo

    Please check the replies and if you are fine with answer please select one as Answer.

    Changing xlsx will resolve the issue.

    Regards,

    Arjun

  • Sahana Sakkarpani-Oracle
    Sahana Sakkarpani-Oracle Rank 1 - Community Starter

    Hi Team,

    Is anybody faced issue in scheduling BIP report which leads to failure with below error.

    Job processor caused exception
    [INSTANCE_ID=bip.bi_server1] [INSTANCE_JOB_ID=79688]

    Error getting report data
    [INSTANCE_ID=bip.bi_server1]
    oracle.xdo.servlet.scheduler.ProcessingException:
    Error getting report data
    [INSTANCE_ID=bip.bi_server1]
    at oracle.xdo.enterpriseScheduler.bursting.BurstingJobProcessor.getControlXML(BurstingJobProcessor.java:767)
    at oracle.xdo.enterpriseScheduler.bursting.BurstingJobProcessor.execute(BurstingJobProcessor.java:450)
    at oracle.xdo.enterpriseScheduler.bursting.BurstingJobProcessor.onMessage(BurstingJobProcessor.j

    Report is not having bursting, only CSV output format in report.

    Ess Job is successfully completing and producing output for the same BIP report.

    Regards

    Sahana