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/------------------------------