Report Engine crashed. How to rectify this issue ?

Hi,

We have one matrix report created using oracle Reports builder. We are trying to generate the report with data from Jan-Oct, we are getting error in application server as "Engine rwEng-0 crashed, job id: 28". The same report is working for Feb-Oct and also for oct month only.

Our application is working on Oracle Forms & Reports 11g. Your immediate response is highly appreciated.

Thanks,
Mary
Mary YujinAsked:
Who is Participating?
 
Helena Markováprogrammer-analystCommented:
I am afraid that if some configuration of application server cannot help (your admin knows what can be done...) then you must either split report (e.g Jan - Jun + Jul - Dec) or try to use another tool e.g. BI Publisher (here is a link:
https://www.oracle.com/solutions/business-analytics/business-intelligence/publisher/index.html)
0
 
Helena Markováprogrammer-analystCommented:
Here are some tips:
- look at logs of application server (report server) for more informations about job id:28 - maybe it crashes because report is too big ...
- maybe there is problem with data - what happens if report is run for Jan only or Jan to Sept ?

I hope it can be a little help for you.
0
 
Mary YujinAuthor Commented:
- Yes, Report is too big. No of records approx.33,000. But somehow I want to generate the report as matrix. Please help me on the same.

- We tried the same report from Feb-Oct and only for Oct month. It s working fine. Also it works for Jan-sep and only for Jan. Hence we think, problem is not with data.
0
 
Mary YujinAuthor Commented:
We Changed the width & height parameters of the report and now it is working fine.

Thanks for your support
0
 
Helena Markováprogrammer-analystCommented:
You are welcome :).
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.