Eclipse Community Forums: BIRT » DataException : Error in saving files of data set cache.

Home » Eclipse Projects » BIRT » DataException : Error in saving files of data set cache.(DataException : Error in saving files of data set cache.)

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

DataException : Error in saving files of data set cache. [message #1097772]

Fri, 30 August 2013 06:31

purnima d

Messages: 26
Registered: April 2013

Junior Member

Hi,

We are facing below exception while generating report , Please let us know
what is the exact issue.We have executed the query and dataset is working fine.

error generating report org.eclipse.birt.report.engine.api.EngineException: There is an error in saving files of data set cache.
/apps/GTS/tmp/p_wtydm_wl/ccerrep/cache/DataEngine_698590531_9065/DataSetCacheObject_699656275_5368/data.data (No such file or directory) (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)

Caused by: org.eclipse.birt.data.engine.core.DataException: There is an error in saving files of data set cache.
/apps/GTS/tmp/p_wtydm_wl/ccerrep/cache/DataEngine_698590531_9065/DataSetCacheObject_699656275_5368/data.data (No such file or directory)
at org.eclipse.birt.data.engine.executor.dscache.CacheUtilFactory$DiskSaveUtil.saveObject(CacheUtilFactory.java:183)
at org.eclipse.birt.data.engine.executor.dscache.DataSetToCache.saveDataSetResult(DataSetToCache.java:185)
at org.eclipse.birt.data.engine.executor.DataSourceQuery.execute(DataSourceQuery.java:1031)
at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQueryExecutor.executeOdiQuery(PreparedOdaDSQuery.java:441)
at org.eclipse.birt.data.engine.impl.QueryExecutor.execute(QueryExecutor.java:1495)
at org.eclipse.birt.data.engine.impl.ServiceForQueryResults.executeQuery(ServiceForQueryResults.java:233)
at org.eclipse.birt.data.engine.impl.QueryResults.getResultIterator(QueryResults.java:173)
at org.eclipse.birt.report.engine.data.dte.QueryResultSet.<init>(QueryResultSet.java:98)
at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:168)
at org.eclipse.birt.report.engine.data.dte.DataGenerationEngine.doExecuteQuery(DataGenerationEngine.java:80)
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:265)
at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:80)
at org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:62)
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.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.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:100)
at org.eclipse.birt.report.engine.presentation.ReportDocumentBuilder.build(ReportDocumentBuilder.java:250)
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)

Caused by: java.io.FileNotFoundException: /apps/GTS/tmp/p_wtydm_wl/ccerrep/cache/DataEngine_698590531_9065/DataSetCacheObject_699656275_5368/data.data (No such file or directory)
at java.io.FileOutputStream.open(Native Method)
at java.io.FileOutputStream.<init>(FileOutputStream.java:194)
at org.eclipse.birt.data.engine.core.security.FileSecurity$5.run(FileSecurity.java:190)
at org.eclipse.birt.data.engine.core.security.FileSecurity$5.run(FileSecurity.java:1)
at org.eclipse.birt.data.engine.core.security.FileSecurity.createFileOutputStream(FileSecurity.java:186)
at org.eclipse.birt.data.engine.core.security.FileSecurity.createFileOutputStream(FileSecurity.java:170)
at org.eclipse.birt.data.engine.executor.dscache.CacheUtilFactory$DiskSaveUtil.saveObject(CacheUtilFactory.java:178)
at org.eclipse.birt.data.engine.executor.dscache.DataSetToCache.saveDataSetResult(DataSetToCache.java:185)
at org.eclipse.birt.data.engine.executor.transform.ResultSetPopulator.cacheDataSet(ResultSetPopulator.java:205)
at org.eclipse.birt.data.engine.executor.transform.CachedResultSet.<init>(CachedResultSet.java:142)
at org.eclipse.birt.data.engine.executor.DataSourceQuery.execute(DataSourceQuery.java:1031)
at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQueryExecutor.executeOdiQuery(PreparedOdaDSQuery.java:441)
at org.eclipse.birt.data.engine.impl.QueryExecutor.execute(QueryExecutor.java:1495)
at org.eclipse.birt.data.engine.impl.ServiceForQueryResults.executeQuery(ServiceForQueryResults.java:232)
at org.eclipse.birt.data.engine.impl.QueryResults.getResultIterator(QueryResults.java:173)
at org.eclipse.birt.report.engine.data.dte.QueryResultSet.<init>(QueryResultSet.java:98)
at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:168)
at org.eclipse.birt.report.engine.data.dte.DataGenerationEngine.doExecuteQuery(DataGenerationEngine.java:80)
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:265)

Report message to a moderator

Re: DataException : Error in saving files of data set cache. [message #1098430 is a reply to message #1097772]

Sat, 31 August 2013 03:55

Michael Williams

Messages: 1925
Registered: July 2009

Senior Member

What version of BIRT are you using? What is your dataSet type? Are you able to reproduce this error in a report that I can run?

Michael

Developer Evangelist, Silanis

[Updated on: Sat, 31 August 2013 04:01]

Report message to a moderator

Re: DataException : Error in saving files of data set cache. [message #1099699 is a reply to message #1098430]

Mon, 02 September 2013 04:41

purnima d

Messages: 26
Registered: April 2013

Junior Member

Version of BIRT - 3.7.0
it is regular dataset (SQL select Query)
We are not able to reproduce this error.This error is occuring randomly.

Report message to a moderator

Re: DataException : Error in saving files of data set cache. [message #1101081 is a reply to message #1099699]

Wed, 04 September 2013 01:36

Michael Williams

Messages: 1925
Registered: July 2009

Senior Member

Are you reading/writing in or out to any files? Can you attach the design that's not working? Is this error coming from the designer or while deployed? Let me know.

Michael

Developer Evangelist, Silanis

Report message to a moderator

Re: DataException : Error in saving files of data set cache. [message #1101539 is a reply to message #1097772]

Wed, 04 September 2013 15:39

purnima d

Messages: 26
Registered: April 2013

Junior Member

We have encountered this exception when the report is running under app server not in report designer.
This issue is intermittent
We are using weblogic 11
We don't see this issue always
Looks like it is DataEngine related issue

Report message to a moderator

Re: DataException : Error in saving files of data set cache. [message #1102249 is a reply to message #1101539]

Thu, 05 September 2013 15:06

Michael Williams

Messages: 1925
Registered: July 2009

Senior Member

Are you stuck using 3.7.0? Or could you try using the 3.7.2 runtime to run the reports to see if that makes a difference?

Michael

Developer Evangelist, Silanis

Report message to a moderator

Re: DataException : Error in saving files of data set cache. [message #1106485 is a reply to message #1097772]

Wed, 11 September 2013 06:47

purnima d

Messages: 26
Registered: April 2013

Junior Member

Hi Williams,

This issue is intermitent , it is not occuring frequently.
But we would like to know the root cause.
We are using Weblogic 11 app server running under JDK 1.6 with oracle 11g
Please let us know what might be the root cause for this type of exception.

Note: We have encountered this issue in production environmnet so we will not be able to upgrade to 3.7.2.

Thanks,
Purnima

Report message to a moderator

Re: DataException : Error in saving files of data set cache. [message #1106770 is a reply to message #1106485]

Wed, 11 September 2013 14:26

Michael Williams

Messages: 1925
Registered: July 2009

Senior Member

Understood. I just wanted to see if you could run a parallel deployment of 3.7.2 and test it to see if it has issues. It could be a bug in 3.7.0 that was fixed. If you absolutely cannot do testing with 3.7.2 or higher, I'll just have to let you know if I find something that might be the cause. I've not seen this error before or heard of anyone else getting it either. Hopefully I can find something for you. Please log a bug for this in the bugzilla to see if they have any info on it.

Michael

Developer Evangelist, Silanis

Report message to a moderator

Re: DataException : Error in saving files of data set cache. [message #1106773 is a reply to message #1106770]

Wed, 11 September 2013 14:28

Michael Williams

Messages: 1925
Registered: July 2009

Senior Member

One more question. Is this only with one report? Or does this happen with random reports? If it's just one report, can you attach the report in here? Or email it to me at mwilliams.actuate at gmail? Thanks!

Michael

Developer Evangelist, Silanis

Report message to a moderator