WinXP Job File error

4 posts / 0 new
Last post
starjuancho
starjuancho's picture
Offline
Last seen: 3 years 11 months ago
Joined: Jul 27 2010
Junior Boarder

Posts: 2

Juan Sanchez
WinXP Job File error

Hi.

I'm trying import data from a sqlserver table.

First, create the data file in "C:\Calpont\bulk\data\import\oss.tbl" with columns separated by commas.

Then create the database oss and the table cdr in infinidb (via mysql-workbench)

Finaly when i run the "C:\>Calpont\bin\colxml oss -t cdr -d ," i get the message:

2010-07-27 09:20:13 (5912) ERR : colxml exception: IDB-2006: 'oss.cdr' does not exist in InfiniDB.
XMLProc encountered exception, abnormal exit and file not created.
Check error log at: C:/Calpont/bulk/log/Jobxml_299.err

I hope you can helpme.
Thanks

davidhill
davidhill's picture
Offline
Last seen: 1 month 4 days ago
Joined: Oct 27 2009
Administrator

Posts: 595

david hill
Re:WinXP Job File error

First off, thanks for download and checking out InfiniDB.

Your problem is very simular to the problem of this user in a previous thread.
Possibly the table didn't get created correctly within 'infinidb'.

Please follow the investigatation procedure posted in this thread and see if it helps discover your problem:

http://www.infinidb.org/community/forums/11-general-infinidb/1177-colxml...

David H.

starjuancho
starjuancho's picture
Offline
Last seen: 3 years 11 months ago
Joined: Jul 27 2010
Junior Boarder

Posts: 2

Juan Sanchez
Re:WinXP Job File error

:)
Thanks D avid

That solved my problem.

I could import my data

davidhill
davidhill's picture
Offline
Last seen: 1 month 4 days ago
Joined: Oct 27 2009
Administrator

Posts: 595

david hill
Re:WinXP Job File error

Cool, glad to here...

Let us know how things go and if you have any other questions..

We are always glad to here from the user community.