Invalid table name

jasonws

Hi, I get the following error when attempting to run a report in linux. Any chance someone could help troubleshoot it with me? Thanks! -Jason

Nov 4, 2011 3:54:09 PM org.eclipse.birt.data.engine.odaconsumer.Connection prepareOdaQuery
SEVERE: Failed to prepare the following query for the data set type (org.eclipse.datatools.connectivity.oda.flatfile.dataSet).
[select "ORDER NUMBER", "BO SEQ.", "CUSTOMER NO.", "PURCHASE ORDER NO.", "BILL TO NAME", "SHIP TO NAME", "BILL TO ADDR 1", "SHIP TO ADDR 2", "BILL TO ADDR 2", "SHIP TO ADDR 3", "BILL TO ADDR 3", "SHIP TO ADDR 4", "BILL TO ADDR 4", "SHIP TO ADDR 5", "BILL TO COUNTRY", "SHIP TO ADDR 6", "DATE", "SHIP VIA", "TERMS DESC", "ORDER DATE", "SALESPERSON", "ITEM NUMBER", "DESCRIPTION", "REQUIRED QTY", "SHIPPED QTY", "B.O. QTY", "MSG1", "MSG2", "SERIAL MSG1", "SERIAL MSG2", "SERIAL MSG3", "SERIAL MSG4", "SERIAL MSG5", "SERIAL MSG6", "SERIAL MSG7" from "reports.tsv" : {"ORDER NUMBER","ORDER NUMBER",STRING;"BO SEQ.","BO SEQ.",STRING;"CUSTOMER NO.","CUSTOMER NO.",STRING;"PURCHASE ORDER NO.","PURCHASE ORDER NO.",STRING;"BILL TO NAME","BILL TO NAME",STRING;"SHIP TO NAME","SHIP TO NAME",STRING;"BILL TO ADDR 1","BILL TO ADDR 1",STRING;"SHIP TO ADDR 2","SHIP TO ADDR 2",STRING;"BILL TO ADDR 2","BILL TO ADDR 2",STRING;"SHIP TO ADDR 3","SHIP TO ADDR 3",STRING;"BILL TO ADDR 3","BILL TO ADDR 3",STRING;"SHIP TO ADDR 4","SHIP TO ADDR 4",STRING;"BILL TO ADDR 4","BILL TO ADDR 4",STRING;"SHIP TO ADDR 5","SHIPTO ADDR 5",STRING;"BILL TO COUNTRY","BILL TO COUNTRY",STRING;"SHIP TO ADDR 6","SHIP TO ADDR 6",STRING;"DATE","DATE",STRING;"SHIP VIA","SHIP VIA",STRING;"TERMS DESC","TERMS DESC",STRING;"ORDER DATE","ORDER DATE",STRING;"SALESPERSON","SALESPERSON",STRING;"ITEM NUMBER","ITEM NUMBER",STRING;"DESCRIPTION","DESCRIPTION",STRING;"REQUIRED QTY","REQUIRED QTY",STRING;"SHIPPED QTY","SHIPPED QTY",STRING;"B.O. QTY","B.O. QTY",STRING;"MSG1","MSG1",STRING;"MSG2","MSG2",STRING;"SERIAL MSG1","SERIAL MSG1",STRING;"SERIAL MSG2","SERIAL MSG2",STRING;"SERIAL MSG3","SERIAL MSG3",STRING;"SERIAL MSG4","SERIAL MSG4",STRING;"SERIAL MSG5","SERIAL MSG5",STRING;"SERIAL MSG6","SERIAL MSG6",STRING;"SERIAL MSG7","SERIAL MSG7",STRING}]
org.eclipse.datatools.connectivity.oda.OdaException: Invalid table name:./"reports.tsv"

Tubal

It's not seeing your table file. (reports.tsv)

Either it's named wrong, it's not in your default tables directory, or it doesn't need quotes around the name.