I have problem with Table Conversion
From Flat file to EnterpriseOne Tables
1) Why do I need to use Unicode for my flat file before I can insert into the EnterpriseOne Table?
2) But after I use Unicode for my flat file, I got this error:
From jde.log:
3980/152 Wed Mar 16 09:22:19.734 JDBODBC.C5844
ODB0000164 - STMT:00 [22018][30200] [IBM][iSeries Access ODBC Driver]Column 1: CWBNL0107 - Converted 10 bytes, 1 errors found beginning at offset 0
From the TC log file:
TCEngine Level 11 c:\b9\system\TCEngine\tcdump.c : Fetched Format C:\Documents and Settings\dev0,4,"2415 27 S01 10000 PCSGD031405031505"
TCEngine Level 3 c:\b9\system\TCEngine\tcrun.c : Map format designator columns
TCEngine Level 3 c:\b9\system\TCEngine\tcrun.c : Input row matched format TextLine1
TCEngine Level 2 c:\b9\system\TCEngine\tcrun.c : Inside TCMapFormatColumns for format TextLine1
TCEngine Level 7 c:\b9\system\TCEngine\tcdump.c : Contents for format TextLine1.
TCEngine Level 7 c:\b9\system\TCEngine\tcdump.c : C:/Documents and Settings/dev04/Desktop/FORMAT1U.txt.TextLine1.LITM = '2415 '
TCEngine Level 7 c:\b9\system\TCEngine\tcdump.c : C:/Documents and Settings/dev04/Desktop/FORMAT1U.txt.TextLine1.MCU = '27 '
TCEngine Level 7 c:\b9\system\TCEngine\tcdump.c : C:/Documents and Settings/dev04/Desktop/FORMAT1U.txt.TextLine1.CPGP = 'S01 '
TCEngine Level 7 c:\b9\system\TCEngine\tcdump.c : C:/Documents and Settings/dev04/Desktop/FORMAT1U.txt.TextLine1.UPRC = 10000
TCEngine Level 7 c:\b9\system\TCEngine\tcdump.c : C:/Documents and Settings/dev04/Desktop/FORMAT1U.txt.TextLine1.UOM = 'PC'
TCEngine Level 7 c:\b9\system\TCEngine\tcdump.c : C:/Documents and Settings/dev04/Desktop/FORMAT1U.txt.TextLine1.CRCD = 'SGD'
TCEngine Level 7 c:\b9\system\TCEngine\tcdump.c : C:/Documents and Settings/dev04/Desktop/FORMAT1U.txt.TextLine1.EFTJ = 3/14/2005
TCEngine Level 7 c:\b9\system\TCEngine\tcdump.c : C:/Documents and Settings/dev04/Desktop/FORMAT1U.txt.TextLine1.EXDJ = 3/15/2005
TCEngine Level 3 c:\b9\system\TCEngine\tcrun.c : Performing eTCOnFormatFetched for format TextLine1
TCEngine Level 5 c:\b9\system\TCEngine\tcgbr.c : jdeCallObject for GetAuditInfo
TCEngine Level 5 c:\b9\system\TCEngine\tcgbr.c : F584106.F584106.LITM = C:/Documents and Settings/dev04/Desktop/FORMAT1U.txt.TextLine1.LITM
TCEngine Level 6 c:\b9\system\TCEngine\tcgbr.c : F584106.F584106.LITM = '2415 '
TCEngine Level 5 c:\b9\system\TCEngine\tcgbr.c : F584106.F584106.MCU = C:/Documents and Settings/dev04/Desktop/FORMAT1U.txt.TextLine1.MCU
TCEngine Level 6 c:\b9\system\TCEngine\tcgbr.c : F584106.F584106.MCU = '27 '
TCEngine Level 5 c:\b9\system\TCEngine\tcgbr.c : F584106.F584106.CPGP = C:/Documents and Settings/dev04/Desktop/FORMAT1U.txt.TextLine1.CPGP
TCEngine Level 6 c:\b9\system\TCEngine\tcgbr.c : F584106.F584106.CPGP = 'S01 '
TCEngine Level 5 c:\b9\system\TCEngine\tcgbr.c : jdeCallObject for DisplayDecimalsSet
TCEngine Level 5 c:\b9\system\TCEngine\tcgbr.c : F584106.F584106.UPRC = C:/Documents and Settings/dev04/Desktop/FORMAT1U.txt.TextLine1.UPRC
TCEngine Level 6 c:\b9\system\TCEngine\tcgbr.c : F584106.F584106.UPRC = 1.0000
TCEngine Level 5 c:\b9\system\TCEngine\tcgbr.c : F584106.F584106.UOM = C:/Documents and Settings/dev04/Desktop/FORMAT1U.txt.TextLine1.UOM
TCEngine Level 6 c:\b9\system\TCEngine\tcgbr.c : F584106.F584106.UOM = 'PC'
TCEngine Level 5 c:\b9\system\TCEngine\tcgbr.c : F584106.F584106.CRCD = C:/Documents and Settings/dev04/Desktop/FORMAT1U.txt.TextLine1.CRCD
TCEngine Level 6 c:\b9\system\TCEngine\tcgbr.c : F584106.F584106.CRCD = 'SGD'
TCEngine Level 5 c:\b9\system\TCEngine\tcgbr.c : F584106.F584106.EFTJ = C:/Documents and Settings/dev04/Desktop/FORMAT1U.txt.TextLine1.EFTJ
TCEngine Level 6 c:\b9\system\TCEngine\tcgbr.c : F584106.F584106.EFTJ = 3/14/2005
TCEngine Level 5 c:\b9\system\TCEngine\tcgbr.c : F584106.F584106.EXDJ = C:/Documents and Settings/dev04/Desktop/FORMAT1U.txt.TextLine1.EXDJ
TCEngine Level 6 c:\b9\system\TCEngine\tcgbr.c : F584106.F584106.EXDJ = 3/15/2005
TCEngine Level 5 c:\b9\system\TCEngine\tcgbr.c : F584106.F584106.USER = rpt_S_USER_UserId
TCEngine Level 6 c:\b9\system\TCEngine\tcgbr.c : F584106.F584106.USER = 'DEV04'
TCEngine Level 5 c:\b9\system\TCEngine\tcgbr.c : F584106.F584106.UPMJ = rpt_S_UPMJ_DateUpdated
TCEngine Level 6 c:\b9\system\TCEngine\tcgbr.c : F584106.F584106.UPMJ = 3/16/2005
TCEngine Level 5 c:\b9\system\TCEngine\tcgbr.c : F584106.F584106.JOBN = rpt_S_JOBN_WorkStationId
TCEngine Level 6 c:\b9\system\TCEngine\tcgbr.c : F584106.F584106.JOBN = 'SGNXDEV005'
TCEngine Level 5 c:\b9\system\TCEngine\tcgbr.c : F584106.F584106.PID = ReportName
TCEngine Level 6 c:\b9\system\TCEngine\tcgbr.c : F584106.F584106.PID = 'R584106C'
TCEngine Level 5 c:\b9\system\TCEngine\tcgbr.c : F584106.F584106.TDAY = rpt_S_TDAY_TimeOfDay
TCEngine Level 6 c:\b9\system\TCEngine\tcgbr.c : F584106.F584106.TDAY = 92219
TCEngine Level 2 c:\b9\system\TCEngine\tcrun.c : Inside TCInsertRow
TCEngine Level 9 c:\b9\system\TCEngine\tcdump.c : Contents for format F584106.
TCEngine Level 9 c:\b9\system\TCEngine\tcdump.c : F584106.F584106.LITM = '2415 '
TCEngine Level 9 c:\b9\system\TCEngine\tcdump.c : F584106.F584106.MCU = '27 '
TCEngine Level 9 c:\b9\system\TCEngine\tcdump.c : F584106.F584106.CPGP = 'S01 '
TCEngine Level 9 c:\b9\system\TCEngine\tcdump.c : F584106.F584106.UPRC = 1.0000
TCEngine Level 9 c:\b9\system\TCEngine\tcdump.c : F584106.F584106.UOM = 'PC'
TCEngine Level 9 c:\b9\system\TCEngine\tcdump.c : F584106.F584106.CRCD = 'SGD'
TCEngine Level 9 c:\b9\system\TCEngine\tcdump.c : F584106.F584106.EFTJ = 3/14/2005
TCEngine Level 9 c:\b9\system\TCEngine\tcdump.c : F584106.F584106.EXDJ = 3/15/2005
TCEngine Level 9 c:\b9\system\TCEngine\tcdump.c : F584106.F584106.MVSTBLERA1 = ''
TCEngine Level 9 c:\b9\system\TCEngine\tcdump.c : F584106.F584106.MVSTBLERA2 = ''
TCEngine Level 9 c:\b9\system\TCEngine\tcdump.c : F584106.F584106.MVSTBLERA3 = ''
TCEngine Level 9 c:\b9\system\TCEngine\tcdump.c : F584106.F584106.MVSTBLERA4 = ''
TCEngine Level 9 c:\b9\system\TCEngine\tcdump.c : F584106.F584106.MVSTBLERA5 = ''
TCEngine Level 9 c:\b9\system\TCEngine\tcdump.c : F584106.F584106.MVSTBLERN1 =
TCEngine Level 9 c:\b9\system\TCEngine\tcdump.c : F584106.F584106.MVSTBLERN2 =
TCEngine Level 9 c:\b9\system\TCEngine\tcdump.c : F584106.F584106.MVSTBLERN3 =
TCEngine Level 9 c:\b9\system\TCEngine\tcdump.c : F584106.F584106.MVSTBLERN4 =
TCEngine Level 9 c:\b9\system\TCEngine\tcdump.c : F584106.F584106.MVSTBLERN5 =
TCEngine Level 9 c:\b9\system\TCEngine\tcdump.c : F584106.F584106.URCD = ''
TCEngine Level 9 c:\b9\system\TCEngine\tcdump.c : F584106.F584106.USRCD1 = ''
TCEngine Level 9 c:\b9\system\TCEngine\tcdump.c : F584106.F584106.URC1 = ''
TCEngine Level 9 c:\b9\system\TCEngine\tcdump.c : F584106.F584106.URC2 = ''
TCEngine Level 9 c:\b9\system\TCEngine\tcdump.c : F584106.F584106.URD =
TCEngine Level 9 c:\b9\system\TCEngine\tcdump.c : F584106.F584106.URDT =
TCEngine Level 9 c:\b9\system\TCEngine\tcdump.c : F584106.F584106.USRDT1 =
TCEngine Level 9 c:\b9\system\TCEngine\tcdump.c : F584106.F584106.USER = 'DEV04'
TCEngine Level 9 c:\b9\system\TCEngine\tcdump.c : F584106.F584106.TDAY = 92219
TCEngine Level 9 c:\b9\system\TCEngine\tcdump.c : F584106.F584106.PID = 'R584106C'
TCEngine Level 9 c:\b9\system\TCEngine\tcdump.c : F584106.F584106.JOBN = 'SGNXDEV005'
TCEngine Level 9 c:\b9\system\TCEngine\tcdump.c : F584106.F584106.UPMJ = 3/16/2005
TCEngine Level 2 c:\b9\system\TCEngine\tcrun.c : Insert row 4 for table F584106
TCEngine Level 2 c:\b9\system\TCEngine\tcrun.c : Inside ProcessTblInsertRtnCode
TCEngine Level 11 c:\b9\system\TCEngine\tcdump.c : Insert Row Format F584106,1,"2415 ","27 ","S01 ",1.0000,"PC","SGD",3/14/2005,3/15/2005,"DEV04",92219,"R584106C","SGNXDEV005",3/16/2005
TCEngine Level 2 c:\b9\system\TCEngine\tcrun.c : Fetch row 5 from C:/Documents and Settings/dev04/Desktop/FORMAT1U.txt
TCEngine Level 3 c:\b9\system\TCEngine\tcrun.c : End of File for table C:/Documents and Settings/dev04/Desktop/FORMAT1U.txt
TCEngine Level 3 c:\b9\system\TCEngine\tcrun.c : No eTCOnProcessEnd event to process
TCEngine Level 3 c:\b9\system\TCEngine\tcrun.c : Ending TCRunJDBConversion
TCEngine Level 2 c:\b9\system\TCEngine\tcrun.c : Call JDB_FlushBufferInserts on table F584106
TCEngine Level 0 c:\b9\system\TCEngine\tcrun.c : TCE009173 - JDB_FlushBufferInserts failed on table F584106.
TCEngine Level 2 c:\b9\system\TCEngine\tcrun.c : Inside ProcessTblInsertRtnCode
TCEngine Level 2 c:\b9\system\TCEngine\tcrun.c : Buffered insert is effective for format F584106 of table F584106. Error details are available.
TCEngine Level 0 c:\b9\system\TCEngine\tcrun.c : TCE009174 - Buffered insert failed for table F584106.
TCEngine Level 2 c:\b9\system\TCEngine\tcrun.c : Inside InitBuffInsertErrPtr
TCEngine Level 2 c:\b9\system\TCEngine\tcrun.c : Pointers of buffered detail error values for format F584106 of table F584106 are initialized successfully.
TCEngine Level 2 c:\b9\system\TCEngine\tcrun.c : Logging detail error information for format F584106 of table F584106.
TCEngine Level 11 c:\b9\system\TCEngine\tcdump.c : Buffered Insert Row Format F584106,0,"1001","10","S01",15000.1000,"EA","USD",2/2/2005,3/2/2005,"DEV04",92219,"R584106C","SGNXDEV005",3/16/2005
TCEngine Level 2 c:\b9\system\TCEngine\tcrun.c : Logging detail error information for format F584106 of table F584106.
TCEngine Level 11 c:\b9\system\TCEngine\tcdump.c : Buffered Insert Row Format F584106,0,"220","10","SLIST",1.0010,"EA","SGD",3/13/2005,3/15/2005,"DEV04",92219,"R584106C","SGNXDEV005",3/16/2005
TCEngine Level 2 c:\b9\system\TCEngine\tcrun.c : Logging detail error information for format F584106 of table F584106.
TCEngine Level 11 c:\b9\system\TCEngine\tcdump.c : Buffered Insert Row Format F584106,0,"222","20","S02",7.8061,"EA","SGD",3/14/2005,3/15/2005,"DEV04",92219,"R584106C","SGNXDEV005",3/16/2005
TCEngine Level 2 c:\b9\system\TCEngine\tcrun.c : Logging detail error information for format F584106 of table F584106.
TCEngine Level 11 c:\b9\system\TCEngine\tcdump.c : Buffered Insert Row Format F584106,0,"2415","27","S01",1.0000,"PC","SGD",3/14/2005,3/15/2005,"DEV04",92219,"R584106C","SGNXDEV005",3/16/2005
TCEngine Level 1 c:\b9\system\TCEngine\tcrun.c : Conversion R584106C SIBA001 done successfully. Elapsed time - 2.656000 Seconds.
TCEngine Level 2 c:\b9\system\TCEngine\tcrun.c : Fetched 4 rows from C:/Documents and Settings/dev04/Desktop/FORMAT1U.txt
TCEngine Level 2 c:\b9\system\TCEngine\tcrun.c : Inserted 0 rows, failed to insert 4 rows into F584106
Can someone help me?
Thanks.