xml list - invalid column name

catthunder

Member
Hi Guys,
I'm trying to use xml interoperability for the interface. I learned the example here: http://docs.oracle.com/cd/E24705_01/doc.91/e24253/undrstnd_xml_list.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:
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.
 
Back
Top