Maximo Open Forum

 View Only

  • 1.  Export large data with pagebreak 400000 in single tab in xlsx of Birt Report taking long time

    Posted 27 days ago

    Hello Everyone, 

    I am facing issue while exporting large data in single tab in xlsx format with pagebreak 400000. While exporting data, this exporting process is taking very long time ( more than 40 m) and continue.

    Is there any solution/option to reduce processing time to export large data in single tab in xlsx format of birt report?

    Thanks & Regards


    #MaximoApplicationSuite
    #Reporting

    ------------------------------
    JustIn goodLuck
    ABS
    ------------------------------


  • 2.  RE: Export large data with pagebreak 400000 in single tab in xlsx of Birt Report taking long time

    Posted 26 days ago

    Hi Justin,

    Exporting huge amounts of data from a BIRT report can cause serious performance problems and even crash the server component (JVM) that your BIRT report is running on.

    If the report is returning a lot of data then it is likely to be using a lot of memory and that would affect the response times that you are seeing. Maximo's log files would show the memory usage and they could confirm if the report is causing a problem.

    A better alternative would be to investigate if a custom export routine (e.g. an automation script) could be written that would perform the same query and export the data without having to load all of the BIRT report structure/framework into memory.

    I have seen this type of situation when the data is being analysed offline e.g. in Excel or being given to another syste e.g. an improptu interface.

    If the data is being used for offline analysis then it would be worth looking at whether or not the BIRT report can do more of the analysis for you. BIRT reports can be developed to perform complex analysis including reading data from other databases or performing complex calculation/summaries.

    I have developed those types of reports and previously taught others how to write complex reports.

    If this is being used for an impromptu interface then it would be worth seeing if a proper interface could be developed e.g. using database level access or the Maximo Integration Framework (MIF)

    Best regards,

    Mark



    ------------------------------
    mark robbins
    Cohesive
    IBM Champion 2017-2024 Inclusive
    See my blog on Maximo support related topics here:
    https://www.linkedin.com/pulse/maximo-support-advice-from-non-ibm-engineer-article-mark-robbins/
    ------------------------------

    Original Message


  • 3.  RE: Export large data with pagebreak 400000 in single tab in xlsx of Birt Report taking long time

    Posted 24 days ago

    Have you tried the CSV (Data Export) output from browser? All the data will be there except the headers/ footers. Only downside is, it cannot be scheduled. 



    ------------------------------
    vineet joshi
    ------------------------------

    Original Message


  • 4.  RE: Export large data with pagebreak 400000 in single tab in xlsx of Birt Report taking long time

    Posted 24 days ago

    If the report is performing calculations / adding in attributes then the Data Export won't deliver all the data because that will be based on the data retrieved from the queries.



    ------------------------------
    mark robbins
    Cohesive
    IBM Champion 2017-2024 Inclusive
    See my blog on Maximo support related topics here:
    https://www.linkedin.com/pulse/maximo-support-advice-from-non-ibm-engineer-article-mark-robbins/
    ------------------------------

    Original Message


Related Content