Oracle Forms Report Crash while generating Excel output, REP-56049

If you have encounter the error REP-56048: Engine rwENG-1 Crashed , job id: 39021, then you need to increase the memory settings of the reports.

to do this, in the $ORACLE_HOME/reports/config ,find your report config file
and change the engine id,

engine id="rwEng" class="oracle.reports.engine.EngineImpl" initengine="1" maxengine="1" minengine="0" englife="1" maxidle="30" callbacktimeout="90000" jvmoptions="-Xms64m -Xmx32m -Xss8192k -Xoss8192k"

with jvmOptions to a higher value e.g.

engine id="rwEng" class="oracle.reports.engine.EngineImpl" initengine="1" maxengine="1" minengine="0" englife="1" maxidle="30" callbacktimeout="90000" jvmoptions="-Xms512m -Xmx1024m -Xss8192k -Xoss8192k"


Restart the forms services after this.

If you still encounter this problem after increasing the memory and you oracle forms version is 10.1.2.0.2. Do the below,

1. Apply the latest patch set 10.1.2.3 and then apply the 6835690 patch 6835690 to run the report with enhancedspreadsheet. Download and apply the Patch:5983622 for 10.1.2.3.

Note: The one-off patch:6835690 to get EnhancedSpreadsheet can be applied on release 10.1.2.2 too, but it is always recommended to upgrade to the latest patchset available. Right now the latest one is patchset 3.

3. To make sure the middle tier was successfully upgraded to patchset 3 (10.1.2.3), execute the following url and command:
http://host:port/reports/rwservlet/getserverinfo?

$ORACLE_HOME/Apache/Apache/bin/httpd -version

Both versions, Oracle HTTP Server (OHS) and Oracle Reports should be 10.1.2.3

4. Apply one-off patch 6835690 needed to work with EnhancedSpreadsheet desformat.


After that , change the format to DESFORMAT=ENHANCEDSPREADSHEET has been introduced to generate large data sets (up to 75,000 rows) to spreadsheets as indicated patch:6835690