Home » Developer & Programmer » Reports & Discoverer » Report engine crashed (Oracle report 10g)
Report engine crashed [message #617455] Mon, 30 June 2014 05:44 Go to next message
dorerajp
Messages: 8
Registered: June 2014
Junior Member
Hi,

I'm generating csv through report ,but report is generating data when less than 500 records and it fails when more than 500 records(Refere Note 1).Then i have googled and it says that increase the jvmoptions (Refer note 2).

Is that any alternative solutions?

Note 1:
~~~~~~
Error: REP-56048: Engine rwEng-1 crashed, job Id: 18305

wsf_ioroem_cross_off_csv_batch:java.lang.RuntimeException: Error: REP-56048: Engine rwEng-1 crashed, job Id: 18305


Note 2:
~~~~~~~
<engine id="rwEng" class="oracle.reports.engine.EngineImpl" initEngine="1" jvmoptions="-Xoss4096k" maxEngine="1" minEngine="0" engLife="50" maxIdle="30" callbackTimeOut="90000">
<!--property name="sourceDir" value="your reports source directory"/-->
<!--property name="tempDir" value="your reports temp directory"/-->
<!--property name="keepConnection" value="yes"/-->
</engine>
Re: Report engine crashed [message #617457 is a reply to message #617455] Mon, 30 June 2014 06:07 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Can you run the same query in SQL*Plus? What happens if it fetches more than 500 records? Does it fail as well?

Did you, by any chance, set repeating frame's "Maximum records per page" property to some value? If so, reset it to 0 (zero).

Are all frames' "Vertical elasticity" properties set to a value different from "Fixed"? If not, try "Variable" instead.

Would recompiling the report (Ctrl + Shift + K) do any good?
Re: Report engine crashed [message #617476 is a reply to message #617457] Mon, 30 June 2014 07:40 Go to previous message
dorerajp
Messages: 8
Registered: June 2014
Junior Member
Hi,

Yes,in SQL plus i can see more than 2000 records.
its's already re-setted as 0
yes all frames are "Variable" only
i re-compiled the report and its is good.
Previous Topic: Reports 10G - SPREADSHEET - cannot see the cell borders in Excel
Next Topic: 0 instead of null column based on 2-queries (CM merged 2)
Goto Forum:
  


Current Time: Thu Mar 28 19:55:37 CDT 2024