Eclipse Community Forums: BIRT » Reports are failing while closing DataFileReader

Home » Archived » BIRT » Reports are failing while closing DataFileReader(Reports are failing while closing DataFileReader)

Show: Today's Messages :: Show Polls :: Message Navigator

Reports are failing while closing DataFileReader [message #1008904]

Thu, 14 February 2013 05:13

Pavan Manala

Messages: 6
Registered: February 2013

Junior Member

Hi,

Reports are failing in our production environment while closing DataFileReader. Below is the stack trace.
SEVERE [org.eclipse.birt.report.engine.api.impl.RunTask.doRun] : An error happened while running the report. Cause:java.lang.NullPointerException
at org.eclipse.birt.data.engine.executor.cache.disk.DataFileReader.close(DataFileReader.java:119)
at org.eclipse.birt.data.engine.executor.cache.disk.RowFile.closeReader(RowFile.java:284)
at org.eclipse.birt.data.engine.executor.cache.disk.RowFile.close(RowFile.java:270)
at org.eclipse.birt.data.engine.api.CloseListenerManager.closeAll(CloseListenerManager.java:38)
at org.eclipse.birt.data.engine.impl.DataEngineImpl.shutdown(DataEngineImpl.java:584)
at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.shutdown(DataRequestSessionImpl.java:509)
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.shutdown(AbstractDataEngine.java:348)
at org.eclipse.birt.report.engine.data.dte.DataGenerationEngine.shutdown(DataGenerationEngine.java:151)
at org.eclipse.birt.report.engine.executor.ExecutionContext.closeDataEngine(ExecutionContext.java:900)
at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:263)
at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask.java:85)
at com.wellsfargo.reporting.manager.ReportGenerator.sendRequestToEngine(ReportGenerator.java:549)
at com.wellsfargo.reporting.manager.ReportGenerator.runReport(ReportGenerator.java:266)
at com.wellsfargo.reporting.jms.ReportingMDP.onMessage(ReportingMDP.java:45)
at org.springframework.jms.listener.AbstractMessageListenerContainer.doInvokeListener(AbstractMessageListenerContainer.java:543)
at org.springframework.jms.listener.AbstractMessageListenerContainer.invokeListener(AbstractMessageListenerContainer.java:482)
at org.springframework.jms.listener.AbstractMessageListenerContainer.doExecuteListener(AbstractMessageListenerContainer.java:451)
at org.springframework.jms.listener.AbstractPollingMessageListenerContainer.doReceiveAndExecute(AbstractPollingMessageListenerContainer.java:323)
at org.springframework.jms.listener.AbstractPollingMessageListenerContainer.receiveAndExecute(AbstractPollingMessageListenerContainer.java:261)
SEVERE [com.wellsfargo.reporting.manager.ReportGenerator.sendRequestToEngine] : Error generating the report :/ccer/design/offline/Decline_Transactions.rptdesign
org.eclipse.birt.report.engine.api.EngineException: Error happened while running the report.
at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:269)
at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask.java:85)
at com.wellsfargo.reporting.manager.ReportGenerator.sendRequestToEngine(ReportGenerator.java:549)
at com.wellsfargo.reporting.manager.ReportGenerator.runReport(ReportGenerator.java:266)
at com.wellsfargo.reporting.jms.ReportingMDP.onMessage(ReportingMDP.java:46)
at org.springframework.jms.listener.AbstractMessageListenerContainer.doInvokeListener(AbstractMessageListenerContainer.java:544)
at org.springframework.jms.listener.AbstractMessageListenerContainer.invokeListener(AbstractMessageListenerContainer.java:482)
at org.springframework.jms.listener.AbstractMessageListenerContainer.doExecuteListener(AbstractMessageListenerContainer.java:451)
at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.invokeListener(DefaultMessageListenerContainer.java:982)
at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.executeOngoingLoop(DefaultMessageListenerContainer.java:974)
at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.run(DefaultMessageListenerContainer.java:876)
at java.lang.Thread.run(Thread.java:637)
Caused by: java.lang.NullPointerException
at org.eclipse.birt.data.engine.executor.cache.disk.DataFileReader.close(DataFileReader.java:119)
at org.eclipse.birt.data.engine.executor.cache.disk.RowFile.closeReader(RowFile.java:284)
at org.eclipse.birt.data.engine.executor.cache.disk.RowFile.close(RowFile.java:270)
at org.eclipse.birt.data.engine.api.CloseListenerManager.closeAll(CloseListenerManager.java:38)
at org.eclipse.birt.data.engine.impl.DataEngineImpl.shutdown(DataEngineImpl.java:584)
at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.shutdown(DataRequestSessionImpl.java:509)
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.shutdown(AbstractDataEngine.java:348)
at org.eclipse.birt.report.engine.data.dte.DataGenerationEngine.shutdown(DataGenerationEngine.java:151)
at org.eclipse.birt.report.engine.executor.ExecutionContext.closeDataEngine(ExecutionContext.java:900)
at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:263)
at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask.java:85)

We also found another stacktrace from our logs.
error generating report org.eclipse.birt.report.engine.api.EngineException: Exception in reading temporary file for large data set.
Stream closed (Element ID:2634)
at org.eclipse.birt.data.engine.executor.cache.disk.DiskCache.next(DiskCache.java:185)
at org.eclipse.birt.data.engine.executor.cache.disk.DiskCache.fetch(DiskCache.java:206)
at org.eclipse.birt.data.engine.executor.cache.SmartCache.fetch(SmartCache.java:165)
at org.eclipse.birt.data.engine.executor.transform.group.GroupInformationUtil.doGrouping(GroupInformationUtil.java:466)
at org.eclipse.birt.data.engine.executor.transform.pass.PassUtil.pass(PassUtil.java:71)
at org.eclipse.birt.data.engine.executor.transform.pass.ResultSetProcessUtil.prepareAggregations(ResultSetProcessUtil.java:154)
at org.eclipse.birt.data.engine.executor.transform.pass.ResultSetProcessUtil.populateResultSet(ResultSetProcessUtil.java:110)
at org.eclipse.birt.data.engine.executor.transform.pass.ResultSetProcessUtil.doPopulate(ResultSetProcessUtil.java:85)
at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.prepareQueryResultSet(PassManager.java:108)
at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.pass(PassManager.java:126)
at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.populateResultSet(PassManager.java:74)
at org.eclipse.birt.data.engine.executor.transform.ResultSetPopulator.populateResultSet
Below is another trace.
generating report org.eclipse.birt.rep
ort.engine.api.EngineException: There is an error in saving files of data set cache.
/apps/GTS/tmp/p_wtydm/ccerrep/cache/DataEngine_670338467_23829/DataSetCacheObject_671625063_13907/data.data (Too many open files) (Element ID:2026
)
at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1206)
at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1185)
at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:96)
at org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:62)
at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46)
at org.eclipse.birt.report.engine.internal.executor.emitter.ReportItemEmitterExecutor.execute(ReportItemEmitterExecutor.java:46)
at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43)
at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46)
at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:34)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65)
at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:92)
at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:100)
at org.eclipse.birt.report.engine.presentation.ReportDocumentBuilder.build(ReportDocumentBuilder.java:249)
at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:260)
at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask.java:85)

We are using eclipse 3.7 and deploying the reports in BEA WL10.0.2 with JDK 1.5. We are creating only one engine and wrapping it in singleton. We are closing Task and Report documents properly. Reports started working fine after bouncing the server. This has become high priority issue in production. Any help on this is highly appreciated.

Thanks,
Pavan.

Report message to a moderator

Re: Reports are failing while closing DataFileReader [message #1009235 is a reply to message #1008904]

Thu, 14 February 2013 18:14

Jason Weathersby

Messages: 9167
Registered: July 2009

Senior Member

Pavan

Can you open a bugzilla entry for this? I assume this is on Linux? BTW have you tried something like:
http://www.cyberciti.biz/faq/linux-unix-nginx-too-many-open-files/

Jason

Report message to a moderator

Re: Reports are failing while closing DataFileReader [message #1010856 is a reply to message #1009235]

Mon, 18 February 2013 10:51

Pavan Manala

Messages: 6
Registered: February 2013

Junior Member

Thanks Jason. I will open an entry in bugzilla.

Thanks,
pavan.

Report message to a moderator

Re: Reports are failing while closing DataFileReader [message #1011045 is a reply to message #1010856]

Mon, 18 February 2013 18:17

Jason Weathersby

Messages: 9167
Registered: July 2009

Senior Member

That would be good. Can you post the bugzilla entry here when you do it?

Jason

Report message to a moderator

Re: Reports are failing while closing DataFileReader [message #1014978 is a reply to message #1011045]

Wed, 27 February 2013 05:54

Pavan Manala

Messages: 6
Registered: February 2013

Junior Member

Hi Jason,

I created a bug in bugzilla. Bug Id is: 401068

Thanks,
Pavan.

Report message to a moderator

Re: Reports are failing while closing DataFileReader [message #1017247 is a reply to message #1011045]

Mon, 11 March 2013 09:49

Pavan Manala

Messages: 6
Registered: February 2013

Junior Member

Hi Jason,

Please let us know if you have any update on this issue.

Thanks,
Pavan.

Report message to a moderator

Re: Reports are failing while closing DataFileReader [message #1017816 is a reply to message #1008904]

Tue, 12 March 2013 15:43

vlad Mising name

Messages: 3
Registered: March 2013

Junior Member

No Message Body

[Updated on: Wed, 13 March 2013 10:08]

Report message to a moderator

Re: Reports are failing while closing DataFileReader [message #1017890 is a reply to message #1017247]

Tue, 12 March 2013 18:03

vlad Mising name

Messages: 3
Registered: March 2013

Junior Member

Hi Pavan,

I have investigated the theme and written the result down in the issue:
https://bugs.eclipse.org/bugs/show_bug.cgi?id=401068

Do your reports contain crosstabs?

Best regards,
Vlad

[Updated on: Wed, 13 March 2013 10:08]

Report message to a moderator

Re: Reports are failing while closing DataFileReader [message #1018556 is a reply to message #1017890]

Thu, 14 March 2013 04:05

Pavan Manala

Messages: 6
Registered: February 2013

Junior Member

Hi,

Thanks for your reply. None of our reports contans crosstabs.

Thanks,
Pavan.

Report message to a moderator

Re: Reports are failing while closing DataFileReader [message #1031662 is a reply to message #1011045]

Tue, 02 April 2013 03:31

Pavan Manala

Messages: 6
Registered: February 2013

Junior Member

Hi jason,

As per the latest comments from bugzilla for this bug, this issue seems to be resolved in 4.2.2 version. can you please confirm.

Thanks,
Pavan.

Report message to a moderator

Re: Reports are failing while closing DataFileReader [message #1032183 is a reply to message #1031662]

Tue, 02 April 2013 17:13

Michael Williams

Messages: 1925
Registered: July 2009

Senior Member

You might try downloading a copy of 4.2.2 and setting it up to run a quick check on if it works with your actual application. That would definitely be the most absolute way to check that it'll work for you, anyways.

Michael

Developer Evangelist, Silanis

Report message to a moderator

Previous Topic:	by checkbox
Next Topic:	The problem about OSGI

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Sep 26 13:59:32 GMT 2023

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter