jdbc err

[Former Member]

Can anybody what does this messahe mean

Error while parsing or executing XML-SQL document: Error processing request in sax parser: Error when executing statement for table/stored proc. 'SKUMASTER' (structure 'insert'): java.sql.SQLException: FATAL ERROR document format: structure 'insert', no key element found

Thanx.. Vinithra

[Former Member · Accepted solution]

Hi Vinitha,

You need to check this link:

[Document Format for Receiver Adapter.|http://help.sap.com/saphelp_nw2004s/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm]

Make sure @action is INSERT, not UPDATE_INSERT.

You structure must be something like this:

<StatementName2>

<dbTableName action=u201DINSERTu201D>

<table>realDbTableName</table>

<access>

<col1>val1</col1>

<col2>val2</col2>

</access>

<access>

<col1>val11</col1>

</access>

</dbTableName>

</StatementName2>

Regards

[Former Member]

Hi,

in your JDBC msg structure, in action attribute have INSERT and in key specify the primary key of your table.

Regards,

Rajeev Gupta

[Former Member]

Hi,

Try to pattern your structure with this sample.

<IAFPOCHR action="INSERT">

<TABLE>IAFPOCHR</TABLE>

- <access>

<IAPLNT>ASSY</IAPLNT>

<IAFCID>P1</IAFCID>

<IAPONO>902341</IAPONO>

<IACUST>00852</IACUST>

<IACNM>CUS_CODE</IACNM>

<IACVL>0000000852</IACVL>

<IAPOSD>20090202120607</IAPOSD>

</access>

- <key1>

<IAPLNT>ASSY</IAPLNT>

<IAFCID>P1</IAFCID>

<IAPONO>902341</IAPONO>

<IACUST>00852</IACUST>

<IACNM>CUS_CODE</IACNM>

</key1>

</IAFPOCHR>

Thanks,

Alfred

[Former Member]

Try with upper case, I mean rather using 'insert', use 'INSERT'.

Regards,

Sarvesh

[VijayKonam]

The error is saying that you did not mention the key of the table. An insert command requires a key field in order to identify the unique record it has to update. Add the Primary Key field of the table and its value in your XML Query and it will run smooth.

VJ

[former_member750652]

Hi Vinithra,

As per the Error message that you got ,There must be some problem with the input document .Coz the XI uses a technique called XML Parsing( based on JAVA.) to read the input and convet it into XML for its processing.

Thanks,

Ram.