Why is this flat file not valid?
Hey, I'm designing a report and the CSV file I'm using as a data source is apparently not valid. Any idea why?
Thanks,
Jason
ACCOUNT, STMT_DATE, CLIENT_NAME, ADDRESS1, ADDRESS2, CITY, STATE, ZIP, INVOICE_DATE, INVOICE_NUM, DESCRIPTION, CHARGES, PAYMENTS, BALANCE, CURRENT, 30_DAYS, 60_DAYS, 90_DAYS, AMT_DUE
00020, 07/21/09, COLD HOLLOW CIDER MILL, ATTN: MICHELLE / A/P, PO BOX 420, WATERBURY CTR, VT, 05677, 03/09/09, 20427, INVOICE, 663.36, 663.36, 13235.80, .00, .00, 663.36, 13899.16
00020, 07/21/09, COLD HOLLOW CIDER MILL, ATTN: MICHELLE / A/P, PO BOX 420, WATERBURY CTR, VT, 05677, 05/26/09, 21844, INVOICE, 162.72, 162.72, 13235.80, .00, .00, 663.36, 13899.16
00020, 07/21/09, COLD HOLLOW CIDER MILL, ATTN: MICHELLE / A/P, PO BOX 420, WATERBURY CTR, VT, 05677, 06/02/09, 22003, INVOICE, 2832.96, 2832.96, 13235.80, .00, .00, 663.36, 13899.16
00020, 07/21/09, COLD HOLLOW CIDER MILL, ATTN: MICHELLE / A/P, PO BOX 420, WATERBURY CTR, VT, 05677, 06/04/09, 22071, INVOICE, 434.40, 434.40, 13235.80, .00, .00, 663.36, 13899.16
00020, 07/21/09, COLD HOLLOW CIDER MILL, ATTN: MICHELLE / A/P, PO BOX 420, WATERBURY CTR, VT, 05677, 06/04/09, 22072, INVOICE, 316.80, 316.80, 13235.80, .00, .00, 663.36, 13899.16
00020, 07/21/09, COLD HOLLOW CIDER MILL, ATTN: MICHELLE / A/P, PO BOX 420, WATERBURY CTR, VT, 05677, 06/09/09, 22125, INVOICE, 248.20, 248.20, 13235.80, .00, .00, 663.36, 13899.16
00020, 07/21/09, COLD HOLLOW CIDER MILL, ATTN: MICHELLE / A/P, PO BOX 420, WATERBURY CTR, VT, 05677, 06/09/09, 22126, INVOICE, 163.88, 163.88, 13235.80, .00, .00, 663.36, 13899.16
00020, 07/21/09, COLD HOLLOW CIDER MILL, ATTN: MICHELLE / A/P, PO BOX 420, WATERBURY CTR, VT, 05677, 06/16/09, 22261, INVOICE, 1056.00, 1056.00, 13235.80, .00, .00, 663.36, 13899.16
00020, 07/21/09, COLD HOLLOW CIDER MILL, ATTN: MICHELLE / A/P, PO BOX 420, WATERBURY CTR, VT, 05677, 06/16/09, 22262, INVOICE, 164.00, 164.00, 13235.80, .00, .00, 663.36, 13899.16
00020, 07/21/09, COLD HOLLOW CIDER MILL, ATTN: MICHELLE / A/P, PO BOX 420, WATERBURY CTR, VT, 05677, 06/29/09, 22558, INVOICE, 1867.20, 1867.20, 13235.80, .00, .00, 663.36, 13899.16
00020, 07/21/09, COLD HOLLOW CIDER MILL, ATTN: MICHELLE / A/P, PO BOX 420, WATERBURY CTR, VT, 05677, 06/30/09, 22619, INVOICE, 277.44, 277.44, 13235.80, .00, .00, 663.36, 13899.16
00020, 07/21/09, COLD HOLLOW CIDER MILL, ATTN: MICHELLE / A/P, PO BOX 420, WATERBURY CTR, VT, 05677, 07/07/09, 22728, INVOICE, 3573.60, 3573.60, 13235.80, .00, .00, 663.36, 13899.16
00020, 07/21/09, COLD HOLLOW CIDER MILL, ATTN: MICHELLE / A/P, PO BOX 420, WATERBURY CTR, VT, 05677, 07/09/09, 22836, INVOICE, 428.44, 428.44, 13235.80, .00, .00, 663.36, 13899.16
00020, 07/21/09, COLD HOLLOW CIDER MILL, ATTN: MICHELLE / A/P, PO BOX 420, WATERBURY CTR, VT, 05677, 07/13/09, 22882, INVOICE, 692.16, 692.16, 13235.80, .00, .00, 663.36, 13899.16
00020, 07/21/09, COLD HOLLOW CIDER MILL, ATTN: MICHELLE / A/P, PO BOX 420, WATERBURY CTR, VT, 05677, 07/14/09, 22905, INVOICE, 103.68, 103.68, 13235.80, .00, .00, 663.36, 13899.16
00020, 07/21/09, COLD HOLLOW CIDER MILL, ATTN: MICHELLE / A/P, PO BOX 420, WATERBURY CTR, VT, 05677, 07/14/09, 22911, INVOICE, 556.80, 556.80, 13235.80, .00, .00, 663.36, 13899.16
00020, 07/21/09, COLD HOLLOW CIDER MILL, ATTN: MICHELLE / A/P, PO BOX 420, WATERBURY CTR, VT, 05677, 07/20/09, 23027, INVOICE, 257.52, 257.52, 13235.80, .00, .00, 663.36, 13899.16
00020, 07/21/09, COLD HOLLOW CIDER MILL, ATTN: MICHELLE / A/P, PO BOX 420, WATERBURY CTR, VT, 05677, 07/21/09, TEST1, INVOICE, 100.00, 100.00, 13235.80, .00, .00, 663.36, 13899.16
org.eclipse.birt.data.engine.odaconsumer.OdaDataException: Cannot fetch the next data row.
org.eclipse.datatools.connectivity.oda.OdaException: The flatfile data source is not valid.
at org.eclipse.birt.data.engine.odaconsumer.ExceptionHandler.newException(ExceptionHandler.java:52)
at org.eclipse.birt.data.engine.odaconsumer.ExceptionHandler.throwException(ExceptionHandler.java:108)
at org.eclipse.birt.data.engine.odaconsumer.ExceptionHandler.throwException(ExceptionHandler.java:84)
at org.eclipse.birt.data.engine.odaconsumer.ResultSet.fetch(ResultSet.java:143)
at org.eclipse.birt.data.engine.executor.cache.OdiAdapter.fetch(OdiAdapter.java:153)
at org.eclipse.birt.data.engine.executor.cache.RowResultSet.next(RowResultSet.java:105)
at org.eclipse.birt.data.engine.executor.transform.SimpleResultSet.<init>(SimpleResultSet.java:85)
at org.eclipse.birt.data.engine.executor.DataSourceQuery.execute(DataSourceQuery.java:874)
at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQueryExecutor.executeOdiQuery(PreparedOdaDSQuery.java:427)
at org.eclipse.birt.data.engine.impl.QueryExecutor.execute(QueryExecutor.java:1094)
at org.eclipse.birt.data.engine.impl.ServiceForQueryResults.executeQuery(ServiceForQueryResults.java:232)
at org.eclipse.birt.data.engine.impl.QueryResults.getResultIterator(QueryResults.java:172)
at org.eclipse.birt.report.engine.api.impl.ExtractionResults.nextResultIterator(ExtractionResults.java:74)
at org.eclipse.birt.report.designer.data.ui.dataset.DataSetPreviewer.preview(DataSetPreviewer.java:59)
at org.eclipse.birt.report.designer.data.ui.dataset.ResultSetPreviewPage$5.run(ResultSetPreviewPage.java:333)
at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121)
Caused by: org.eclipse.datatools.connectivity.oda.OdaException: The flatfile data source is not valid.
at org.eclipse.datatools.connectivity.oda.flatfile.util.FlatFileDataReader.fetchQueriedDataFromRow(FlatFileDataReader.java:552)
at org.eclipse.datatools.connectivity.oda.flatfile.util.FlatFileDataReader.fetchQueriedDataFromFileToList(FlatFileDataReader.java:442)
at org.eclipse.datatools.connectivity.oda.flatfile.util.FlatFileDataReader.getSourceData(FlatFileDataReader.java:196)
at org.eclipse.datatools.connectivity.oda.flatfile.ResultSet.next(ResultSet.java:110)
at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaResultSet.next(OdaResultSet.java:180)
at org.eclipse.birt.data.engine.odaconsumer.ResultSet.fetch(ResultSet.java:138)
... 12 more
