Tweet
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:
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
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"
Hope this helps!
--Chris