Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
Flat file not Valid
invincible
<p> I'm designing a report and the TSV file I'm using as a data source is apparently not valid. Any idea why?
Here is the error log.</p><p>Thanks,
Ashi
</p><p> </p><p> </p><p>org.eclipse.birt.data.engine.odaconsumer.OdaDataException: Cannot fetch the next data row.
org.eclipse.datatools.connectivity.oda.OdaException: Invalid flat file format</p><p> at org.eclipse.birt.data.engine.odaconsumer.ExceptionHandler.newException(ExceptionHandler.java:52)</p><p> at org.eclipse.birt.data.engine.odaconsumer.ExceptionHandler.throwException(ExceptionHandler.java:108)</p><p> at org.eclipse.birt.data.engine.odaconsumer.ExceptionHandler.throwException(ExceptionHandler.java:84)</p><p> at org.eclipse.birt.data.engine.odaconsumer.ResultSet.fetch(ResultSet.java:143)</p><p> at org.eclipse.birt.data.engine.executor.cache.OdiAdapter.fetch(OdiAdapter.java:214)</p><p> at org.eclipse.birt.data.engine.executor.cache.RowResultSet.fetch(RowResultSet.java:145)</p><p> at org.eclipse.birt.data.engine.executor.cache.RowResultSet.doNext(RowResultSet.java:118)</p><p> at org.eclipse.birt.data.engine.executor.cache.RowResultSet.next(RowResultSet.java:96)</p><p> at org.eclipse.birt.data.engine.executor.transform.SimpleResultSet$RowResultSetWithResultSetScope.fetch(SimpleResultSet.java:945)</p><p> at org.eclipse.birt.data.engine.executor.cache.RowResultSet.doNext(RowResultSet.java:118)</p><p> at org.eclipse.birt.data.engine.executor.cache.RowResultSet.next(RowResultSet.java:96)</p><p> at org.eclipse.birt.data.engine.executor.transform.SimpleResultSet.prepareFirstRow(SimpleResultSet.java:309)</p><p> at org.eclipse.birt.data.engine.executor.transform.SimpleResultSet.getResultSetIterator(SimpleResultSet.java:328)</p><p> at org.eclipse.birt.data.engine.executor.DataSourceQuery.execute(DataSourceQuery.java:1042)</p><p> at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQueryExecutor.executeOdiQuery(PreparedOdaDSQuery.java:445)</p><p> at org.eclipse.birt.data.engine.impl.QueryExecutor.execute(QueryExecutor.java:1208)</p><p> at org.eclipse.birt.data.engine.impl.ServiceForQueryResults.executeQuery(ServiceForQueryResults.java:232)</p><p> at org.eclipse.birt.data.engine.impl.QueryResults.getResultIterator(QueryResults.java:178)</p><p> at org.eclipse.birt.report.engine.api.impl.ExtractionResults.nextResultIterator(ExtractionResults.java:157)</p><p> at org.eclipse.birt.report.designer.data.ui.dataset.DataSetPreviewer.preview(DataSetPreviewer.java:69)</p><p> at org.eclipse.birt.report.designer.data.ui.dataset.ResultSetPreviewPage$5.run(ResultSetPreviewPage.java:365)</p><p> at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121)</p><p>Caused by: org.eclipse.datatools.connectivity.oda.OdaException: Invalid flat file format</p><p> at org.eclipse.datatools.connectivity.oda.flatfile.FlatFileQuery$FlatFileBufferedReader.readLine(FlatFileQuery.java:1097)</p><p> at org.eclipse.datatools.connectivity.oda.flatfile.util.FlatFileDataReader.fetchQueriedDataFromFileToList(FlatFileDataReader.java:313)</p><p> at org.eclipse.datatools.connectivity.oda.flatfile.util.FlatFileDataReader.getSourceData(FlatFileDataReader.java:109)</p><p> at org.eclipse.datatools.connectivity.oda.flatfile.ResultSet.next(ResultSet.java:115)</p><p> at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaResultSet.next(OdaResultSet.java:180)</p><p> at org.eclipse.birt.data.engine.odaconsumer.ResultSet.fetch(ResultSet.java:138)</p><p> ... 18 more</p><p> </p>
Find more posts tagged with
Comments
bricombs
<p>Good Day,</p><p> </p><p>The error log does not say what is wrong with your file. You will need to post your flat file so that we can look to see what is wrong with the formatting in the file.</p><p> </p><p>[color=rgb(0,0,0);font-family:helvetica, arial, sans-serif;font-size:10px;]Brian Combs[/color]<br />
[color=rgb(0,0,0);font-family:helvetica, arial, sans-serif;font-size:10px;]Actuate Corporation | The BIRT Company?[/color]<br />
<a data-ipb='nomediaparse' class="bbc_url" href='
http://www.actuate.com/'
title="External link">
http://www.actuate.com</a>[color=rgb(0,0,0);font-family:helvetica
, arial, sans-serif;font-size:10px;] | [/color]<a data-ipb='nomediaparse' class="bbc_url" href='
http://birtondemand.com/'
title="External link">
http://birtondemand.com</a></p>
;
invincible
<p>My file is a big file, about 54 MB and it has lot of records. If i strip the records to couple of hundreds then the tool works and shows the data correctly but if i attempt to load the complete file it is failing. I am not sure whether it is failing due to the size of the file or some record in it..</p>
kclark
<p>I don't think it would fail from the size. Can you try to run it again from eclipsec.exe and post the stack trace? Sometimes you get more detailed information from the console.</p>