ITPUB论坛-中国专业的IT技术社区

标题: Terminated with error: REP-56048: Engine rwEng-67 crashed, job Id: 3060 [打印本页]

作者: startwjw    时间: 2007-6-22 09:27
标题: Terminated with error: REP-56048: Engine rwEng-67 crashed, job Id: 3060
10g ias运行reports,服务器 出现很多 Terminated with error: REP-56048: Engine rwEng-67 crashed, job Id: 3060 这样的错误,请各位大虾诊断一下!
作者: diudiu4497    时间: 2012-8-18 17:26
Rep-56048 when Running Large Report with DESFORMAT=SPREADSHEET or DESFORMAT=PDF [ID 344794.1]        转到底部转到底部       
修改时间:2012-8-11类型:PROBLEM状态:PUBLISHED优先级:3       
没有任何注释注释 (0)        为此文档评级        通过电子邮件发送此文档的链接        在新窗口中打开文档        可打印页

In this Document
        Symptoms
        Cause
        Solution
        References

Applies to:
Oracle Reports Developer - Version 10.1.2.0.2 and later
Information in this document applies to any platform.
***Checked for relevance on 10-Aug-2012***


Symptoms

When running a report with DESFORMAT=SPREADSHEET or DESFORMAT=PDF and large number of records (>5000) the Reports engine crashes with "REP-56048: Engine rwEng-0 crashed".

Same report with DESFORMAT=HTML output works fine.
Cause

When creating the Spreadsheet or PDF format all pages for the report are created in memory then sent to the output. This leads to an increased need of stack size for processing.
Solution

1. It is necessary to modify the engine definition to include :
jvmOptions="-Xmx512M -Xms128M -Xss512k"



How to do it, depends on the version of Report Server in use :

a. For version 10gR2 (10.1.2.x) :

Backup your Reports server .conf file and Modify the rwEng parameters and add :

jvmOptions="-Xmx512M -Xms128M -Xss512k"

b. For version 11g (11.X), this has to be done through Enterprise Manager. In Enterprise Manager, locate your Report Server and go to "Basic Configuration" page then insert :
-Xmx512M -Xms128M -Xss512k



into the field "JVM Options" and "Apply" your changes.


* The important option is "Xss" that sets the maximum stack size that can be used by C code in a thread.

3. Restart your reports server and try to run again with DESFORMAT=SPREADSHEET




欢迎光临 ITPUB论坛-中国专业的IT技术社区 (http://www.itpub.net/) Powered by Discuz! X3.2