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

BI Publisher error

Received Response
53
Views
2
Comments
Joe Choueiri-Oracle
Joe Choueiri-Oracle Rank 5 - Community Champion
edited January 2024 in Oracle Analytics Publisher

Hi

Job fails for Data model>bursting and the error code is this: does anyone know what is the issue?

Waiting Time: 0.7 seconds

Data Fetch Time: 10.4 seconds

Total Execution Time: 20.8 seconds

Job Priority: Normal

Delivery failed.

[INSTANCE_ID=bip.bi_server2] [SUBJOB_ID=20937]

Waiting Time: 0.7 seconds

Data Fetch Time: 10.4 seconds

Total Execution Time: 20.8 seconds

Job Priority: Normal

Total sub-jobs:2 Processed sub-jobs:1

[INSTANCE_ID=bip.bi_server2]

[INSTANCE_ID=bip.bi_server2]

Answers

  • User_9BUCP
    User_9BUCP Rank 1 - Community Starter
    spacer.gif

    Hii


    job fails for schedule process



    Waiting Time: 0.9 seconds

    Data Fetch Time: 2.4 minutes

    Total Execution Time: 5.4 minutes

    Job Priority: Normal


    Output failed.

    [INSTANCE_ID=bip.bi_serverHA] [OUTPUT_ID=358226] oracle.xdo.XDORuntimeException: Your data is more than 65531 rows in a sheet, that exceeds Microsoft Excel (.xls) limitation. Stop processing. Suggest to turn on Excel Template Scalable Mode to true from Runtime Properties.

    [INSTANCE_ID=bip.bi_serverHA]

  • Gianni Ceresa
    Gianni Ceresa Mod

    @User_9BUCP ,

    Not sure what your post is meant to be, but if you have an error with Publisher, create a new question in the Oracle Analytics Publisher (BIP) category explaining your issue (full product name and version, what you tried to do, how you did it, what you got instead and also screenshots often help in better understanding the situation).