Announcement

Collapse
No announcement yet.

[SOLVED] Exporting large reports to Excel causes crash

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • [SOLVED] Exporting large reports to Excel causes crash

    Hello,

    Just had an issue with a client that migrated to OTM v5.5. As part of the migration, Oracle Reports gets upgraded to 10.1.2.0.2 (from 9.2.0.4) and several problems have ensued.

    The biggest one involves exporting large data sets to Excel, which would cause the Oracle Reports server to crash. In researching this issue, I found Metalink doc # 459824.1: Spreadsheet Option with Large Datasets using RWSERVLET Hangs or Crashes.

    Basically, I had to edit the Report Server's config file and add the following to the engine definition:
    Code:
    jvmOptions="-Xmx1024M -Xms128M -Xss512k"
    If that doesn't work, try increasing the value for -Xmx. If it still doesn't work, Oracle's recommendation is to wait until Oracle Reports 11g

    Hope this helps!

    --Chris
Working...
X