Page 3 of 3 FirstFirst 1 2 3
Results 21 to 28 of 28

Thread: Problem with Table Conversion

  1. #21

    Re: 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
    Hemant

  2. #22

    Re: Problem with Table Conversion

    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
    Hemant

  3. #23

    Re: Problem with Table Conversion

    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 .
    EnterpriseOne Technical Consultant
    ERP8.11,Webmethods,AS400,SQL

  4. #24

    Re: Problem with Table Conversion

    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.

  5. #25

    Re: Problem with Table Conversion

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

  6. #26

    Re: Problem with Table Conversion

    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
    Hemant

  7. #27

    Re: Problem with Table Conversion

    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!

  8. #28
    New Member
    Join Date
    Apr 2004
    Posts
    7

    Re: Problem with Table Conversion

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

    Regards,
    Yesjde

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Comma delimited Table Conversion problem
    By BBritain in forum JD Edwards® EnterpriseOne Developers
    Replies: 1
    Last Post: 01-28-2014, 06:29 PM
  2. Problem with Table Conversion E1 8.10
    By Nicolas_V in forum JD Edwards® EnterpriseOne Developers
    Replies: 5
    Last Post: 02-23-2005, 08:03 AM
  3. problem during Table conversion
    By J_J in forum JD Edwards® EnterpriseOne
    Replies: 1
    Last Post: 05-23-2004, 03:31 AM
  4. OWXe Table Conversion Problem
    By OWXer in forum JD Edwards® EnterpriseOne Developers
    Replies: 4
    Last Post: 07-19-2001, 08:41 AM
  5. Table Conversion - F00165 - CR Problem
    By cory_rau in forum JD Edwards® EnterpriseOne
    Replies: 1
    Last Post: 04-10-2001, 12:58 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company, Oracle or Peoplesoft.