Table Conversion Error

[Ellen_Deak]

Hello,

I'm trying to run a table conversion from a tab delimited file into F1201Z1.
We're running OneWorld Xe. I'm taken the table conversion class, but this is
the first "real" thing I've tried. I'm getting the following in my log:

TCEngine Level D:\b7\system\TCEngine\tcdtacnv.c(321) : TCE009021 - Size of
delimited column TextLine is greater than 32769 and will not fit in the
format buffer.
TCEngine Level D:\b7\system\TCEngine\tcdtacnv.c(321) : TCE009021 - Size of
delimited column TextLine is greater than 32769 and will not fit in the
format buffer.
TCEngine Level D:\b7\system\TCEngine\tcdtacnv.c(321) : TCE009021 - Size of
delimited column TextLine is greater than 32769 and will not fit in the
format buffer.
TCEngine Level 1 D:\b7\system\TCEngine\tcrun.c(933) : Call
JDB_FlushBufferInserts on table F1201Z1
TCEngine Level 1 D:\b7\system\TCEngine\tcrun.c(952) : Conversion R89551201
EPC0002 done successfully. Elapsed time - 42.657000 Seconds.
TCEngine Level 1 D:\b7\system\TCEngine\tcrun.c(960) : Fetched 2944 rows from
C:\B7\DV7333\import\conversion of ross to jde.csv
TCEngine Level 1 D:\b7\system\TCEngine\tcrun.c(968) : Inserted 0 rows,
failed to insert 0 rows into F1201Z1
TCEngine Level 1 D:\b7\system\TCEngine\tcinit.c(2196) : Inside TCFreeTCHdr
TCEngine Level 1 D:\b7\system\TCEngine\tcinit.c(2117) : Inside TCCloseTable
TCEngine Level 1 D:\b7\system\TCEngine\tcinit.c(2127) : Close Table
C:\B7\DV7333\import\conversion of ross to jde.csv
TCEngine Level 1 D:\b7\system\TCEngine\tcinit.c(2117) : Inside TCCloseTable
TCEngine Level 1 D:\b7\system\TCEngine\tcinit.c(2127) : Close Table F1201Z1
--UBE--[0]-- End Time : 14:33:02
UBE Job Finished SuccessFully.


It's almost as if the table conversion isn't recognizing the end of each
line in the input file. I double checked, and my longest input line is just
over 1,000 characters.

Any help would be appreciated.

Ellen Deak
Lead Programmer
Elkhart Products Corporation

 

[Zoltan_Gyimesi]

Hi Ellen,
I also suppose that the problem is the End of Line.
You have forgotten to share your system configuration informations (eg. OneWorld version, etc.) and in this case the Operation System can be very important (eg. Unix vs. NT). Please attach these informations to your posts next time.

Q1.) What is your OpSys?
Q2.) What is/are your New Line character(s)? (e.g. Cr, LF or Cr+LF, etc.)
Q3.) How do you acces your input text file (directly as Text in TC or as Foreign table using Text ODBC driver)?

You can detect that is this a New Line issue or is not if you try to run your TC for a text file containing only a single line.
Please, share your results with us. Thanks.

FYI: My TCs runs well on text input files with CR+LF (OD+0A in hexadecimal) New Line characters, accessing it as Foreign Table based on a Text ODBC data Source on NT 4.0 operating system.
Zoltán

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)

 

[Ellen_Deak]

My workstation is running NT 4.0, the server is an AS400.

I'm using a tab delimited file generated from Excel.

I defined my table conversion as an input text file with a user defined
format.

OneWorld is down at the moment, but as soon as I can get back in I'll try it
with a single line.

Thanks,

Ellen

 

[Zoltan_Gyimesi]

Re: RE: Table Conversion Error

Ellen,
I have never used TC with Text Input because in earlier release of OneWorld it was not available. (What is your OneWorld release level?)
You can examine your Line Separator character(s) with any tool which is able to show your text in Hexadecimal format.

If you will find that you also have CR+LF line separators then maybe the text input in TC doesn't work properly. In this case access your text file as Foreign Table. If you will have trouble with this method then let us know.
In any case, please share all your results. Thanks again.
Zoltán

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)