Problem with Table Conversion

Hello all,
Once again I need some help from you guys on Table Conversion. I have tried to Transfer data from a table to a text file, with delimeter ','. I have made a user defined format for the output file, modeled on the Table from which I am retrieving the data. But alas, I get no result.
In the Mapping section, I get only 1 TextLine, even though I have used a user defined format. Therefore I cannot do any mapping. I have been playing around with it; making User defined Format for the Input table also, as well as concatenating all the fields together......but it is a bit frustrating.
Can you help me on this plz?
Regards,
Hemant
PS: About my TC problem on PSE1, well the Peoplesoft guys are working on the version we have. It seems to be a technical problem. So, I thank all of you who have generously advised me and helped me. I hope that the PS people will be able to solve this problem soon

Hello Guys,
Thanks for all the help. Finally TC is working on PSE1. Firstly, I should have used the P93081 application to convert my text file into unicode. I was saving my text file as Unicode in notepad, but this did not work. Better leave that to the P93081 application and save your file in ANSI.
When this was resolved, I realised that I needed an ODBC connection for my file location. In JDE local, the demo version, my default location was Local, but on PSE1, it was not the case. Since I did not have the rights to create a Data Source or an Environment, I got somebody higher up to do this for me.
Finally when I executed the Batch application Locally, it worked.
All this time I was searching in the jde.log and jdedebug.log, in the PrintQueue directory; I could not debug my program.
So thanks to all of you for your support.
Regards,
Hemant

Hi,

I havn't gone thro' all the post regarding this issue but Still I assumed that are having problem in conversion.Im not sure which version ur in ,

Case1:
If your in ERP8.9 you have unicode problem.
P93081 is the application there you need setup for IBM-37.

Case2:
In Demo Junior most of times conversion wont work.

I do hope this might be helpful .

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.

And also, How do I use P93081 to save my Flat File?

Hello,
I use Peoplesoft EnterpriseOne 8.1. In the beginning when I was trying to perform a data conversion from a text file to a table in EnterpriseOne, I was saving my file in ANSI, that's why Table conversion was not working. The P93081( Work with Flat File) is used to tell EnterpriseOne in which format your file has been saved. In this way, everytime you run your batch application, it knows how to read it. I saw that your application was reading -,"2415 "," . When you get the '', this indicates that it is not reading data rightly.
When you run the P93081 application, add an entry for your Table Conversion Batch Application, the version you are using, and select the Encoding name. For text files saved in ANSI, use the CP1252 Encoding Name.
When you are done, activate your entry by selecting Row->Change status.
Then you can go to BV, execute your application, but while submitting, check the 'Overide Location' and 'Properties' options. When you are selecting your Data Source, choose local.
In the properties, set your debug level to 10; in this way you will be able to know where your application messed up.
When you are done, TC.exe should pop up in your tray bar, indicating that Table Conversion is up and running. If you have any problem, you can also check your application's log in the PrintQueue directory.
I hope this will help you. I am a newbie to JD Edwards and Peoplesoft myself, and I have just got Table Conversion to work OK.
Regards,
Hemant

THANK YOU SO MUCH!!! It works REAL good!!
=)

Same as you, i'm quite new to JDE, it's my first time doing Table Conversion.. it's quite a challenge to use JDE..
Once again, Thank You, Hemant and JDELIST!

Hi,
Just explain us the steps u follwed for TC.

Regards,
Yesjde