dynamobi/dynamobi — Issue #259: [LDB-62] informative messages for schema import
Author: dynamobi-build
Created: 2011-12-30 02:25:01+00:00
State: open
Labels: Flatfile, LDB

[reporter="jpham", created="Wed, 12 Apr 2006 12:47:20 -0500 (GMT-05:00)"]
The following errors were returned for a failed import:

0: jdbc:farrago:> import foreign schema bcp

. . . . . . . . > LIMIT TO ("customer,lineitem,nation,orders,part,partsupp,region,supplier")

. . . . . . . . > from server tpcd_server

. . . . . . . . > into tpcd;

Error: Control file unitsql/optimizer/data/supplier.bcp is not valid (state=,code=0)

It might be nice to say what was not valid, for example:

- a problem with the header

- too many/too few column descriptions

- a problem with column 3 delimiter

- an empty line in the file

...

0: jdbc:farrago:> import foreign schema bcp

. . . . . . . . > LIMIT TO ("customer,lineitem,nation,orders,part,partsupp,region,supplier")

. . . . . . . . > from server tpcd_server

. . . . . . . . > into tpcd;

Error: One or more tables not found while importing foreign schema "BCP": [customer,lineitem,nation,orders,part,partsupp,region,supplier] (state=,code=0)

This one tricked me too... which table was not found?

(In this case, maybe all tables failed)