Ellen_Deak
Active Member
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
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