Results 1 to 2 of 2

Thread: xml list - invalid column name

  1. #1

    xml list - invalid column name

    Hi Guys,
    I'm trying to use xml interoperability for the interface. I learned the example here: http://docs.oracle.com/cd/E24705_01/...htm#EOTIN00485
    I wrote below xml file and submit it to JDE. But JDE always response "invalid column name". I tried many revisions with column name/instance/alias in <CLAUSE TYPE="WHERE"> statement but same error shows.
    Could you help on this? Thanks.

    <?xml version="1.0"?>
    <jdeRequest pwd="*" type="list" user="UTL011" role="*ALL" session="" environment="CNQA910" sessionidle="1800">
    <ACTION TYPE="CreateList">
    <TABLE_NAME VALUE="F0005"/>
    <TABLE_TYPE VALUE="OWTABLE"/>
    <FORMAT VALUE="UT"/>
    <RUNTIME_OPTIONS>
    <DATA_SELECTION>
    <CLAUSE TYPE="WHERE">
    <COLUMN NAME="" TABLE="" INSTANCE="" ALIAS=""/>
    <OPERATOR TYPE="EQ"/>
    <OPERAND>
    <COLUMN NAME="" TABLE="" INSTANCE="" ALIAS=""/>
    <LITERAL VALUE=""/>
    <LIST>
    <LITERAL VALUE=""/>
    </LIST>
    <RANGE>
    <LITERAL_FROM VALUE=""/>
    <LITERAL_TO VALUE=""/>
    </RANGE>
    </OPERAND>
    </CLAUSE>
    <CLAUSE TYPE="OR">
    <COLUMN NAME="" TABLE="" INSTANCE="" ALIAS=""/>
    <OPERATOR TYPE="EQ"/>
    <OPERAND>
    <COLUMN NAME="" TABLE="" INSTANCE="" ALIAS=""/>
    <LITERAL VALUE=""/>
    <LIST>
    <LITERAL VALUE=""/>
    </LIST>
    <RANGE>
    <LITERAL_FROM VALUE=""/>
    <LITERAL_TO VALUE=""/>
    </RANGE>
    </OPERAND>
    </CLAUSE>
    </DATA_SELECTION>
    <DATA_SEQUENCING>
    <DATA SORT="ASCENDING">
    <COLUMN NAME="" TABLE="" INSTANCE="" ALIAS=""/>
    </DATA>
    </DATA_SEQUENCING>
    </RUNTIME_OPTIONS>
    </ACTION>
    </jdeRequest>

    I can submit below xml to JDE successfully.
    <?xml version="1.0"?>
    <jdeRequest pwd="*" type="list" user="UTL011" role="*ALL"
    session="" environment="CNQA910" sessionidle="1800">
    <ACTION TYPE="GetTemplate">
    <TABLE_NAME VALUE="F0005"/>
    <TABLE_TYPE VALUE="OWTABLE"/>
    <TEMPLATE_TYPE VALUE="OUTPUT"/>
    </ACTION>
    </jdeRequest>
    Last edited by catthunder; 01-18-2017 at 01:42 AM.
    E1 8.12,Windows Server 2003,Oracle

  2. #2
    I solved above "invalid column name" issue and meet below issue.
    <jdeResponse type="list" session="91644.1484732324.11">
    <returnCode code="15">TC Wrapper error</returnCode>
    <ACTION TYPE="CreateList">
    <Error>Error in running TC</Error>
    </ACTION>
    </jdeResponse>

    The log file shows:

    1644/5104MAIN_THREAD Wed Jan 18 16:04:58.885144ipcmisc.c299
    process 91644 <E910SYSCMP/JDENET_K> registered in entry 27
    91644/5104MAIN_THREAD Wed Jan 18 16:04:58.902960netcfg.c297
    Starting Kernel of Type:XML LIST KERNEL
    91644/5104MAIN_THREAD Wed Jan 18 16:04:59.985936xmllist.cpp718
    INITIALIZING XML LIST KERNEL
    91644/5104MAIN_THREAD Wed Jan 18 16:05:01.984888jdb_utl1.c12657
    JDB9900810 - Failed to populate address book number and user full name for user JDE
    91644/5104MAIN_THREAD Wed Jan 18 16:05:03.185288xmlrequest.cpp1258
    ICU0000017 - ICU CodePage for 37 is ibm-37.
    91644/5104MAIN_THREAD Wed Jan 18 16:05:07.052120jdb_ctl.c6744
    JDB4200001 - Failed to validate User handle
    91644/5104MAIN_THREAD Wed Jan 18 16:05:07.463360jdb_rq1.c6855
    JDB9900267 - Failed to find requested column -- in the table F0005
    91644/5104MAIN_THREAD Wed Jan 18 16:05:07.463928tcinit.c1348
    TCE009103 - JDB_SetSelection failed.
    91644/5104MAIN_THREAD Wed Jan 18 16:05:07.464880tcapi.c577
    TCE9000 - ITCERunTC - Failed to initialize TCHdr for runtime.
    91644/5104MAIN_THREAD Wed Jan 18 16:05:07.465000tcwrapper.c1127
    TCW - ITCERunTC failed.
    E1 8.12,Windows Server 2003,Oracle

Thread Information

Users Browsing this Thread

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

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.