JDBC Error Statement

[Former Member]

Hi experts,

I've a scenario IDOC to JDBC, give me the error: FATAL ERROR document format: structure 'STATEMENT'

I don't understand becausse payload is OK:

<?xml version="1.0" encoding="UTF-8" ?>

• <ns0:MT_MATERIALES xmlns:ns0="http://PP/Materiales">

- <STATEMENT>

• <TABLENAME ACTION="UPDATE_INSERT">

<TABLE>MAESTRO_MATERIALES</TABLE>

</TABLENAME>

• <ACCESS>

<MATERIAL>100000016</MATERIAL>

<DESCRIPCION>mmpp1</DESCRIPCION>

<TIPO_ARTICULO>3</TIPO_ARTICULO>

<GRUPO_ARTICULOS>014</GRUPO_ARTICULOS>

<LEADTIME>00</LEADTIME>

<CENTRO>0101</CENTRO>

</ACCESS>

</STATEMENT>

</ns0:MT_MATERIALES>

somebody can help me please?

very thanks,

[udo_martens]

Hi Silvia,

spell the key fields just like in the [docu|http://help.sap.com/saphelp_nw2004s/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm]:

action, INSERT, table, access

Regards,

Udo

[Shabarish_Nair]

>

> Hi experts,
> 
> I've a scenario IDOC to JDBC, give me the error: FATAL ERROR document format: structure 'STATEMENT'
> I don't understand becausse payload is OK:
> 
> <?xml version="1.0" encoding="UTF-8" ?>
> 
>     * <ns0:MT_MATERIALES xmlns:ns0="http://PP/Materiales">
> 
> - <STATEMENT>
> 
>     * <TABLENAME ACTION="UPDATE_INSERT">
> 
> <TABLE>MAESTRO_MATERIALES</TABLE>
> </TABLENAME>
> 
>     * <ACCESS>
> 
> <MATERIAL>100000016</MATERIAL>
> <DESCRIPCION>mmpp1</DESCRIPCION>
> <TIPO_ARTICULO>3</TIPO_ARTICULO>
> <GRUPO_ARTICULOS>014</GRUPO_ARTICULOS>
> <LEADTIME>00</LEADTIME>
> <CENTRO>0101</CENTRO>
> </ACCESS>
> </STATEMENT>
> </ns0:MT_MATERIALES>
> 
> somebody can help me please?
> 
> very thanks,

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

refer the above to get the correct structure for UPDATE_INSERT

your structure is not consistent with the standard one

[prateek]

Put </TABLENAME> just before </STATEMENT>

At end, it should be

</ACCESS>

</TABLENAME>

</STATEMENT>

</ns0:MT_MATERIALES>

Regard,

Prateek

[Former Member]

Hi,

your JDBC structure should be like below:

<STATEMENT>

<TABLENAME ACTION="UPDATE_INSERT">

<TABLE>MAESTRO_MATERIALES</TABLE>

<ACCESS>

<MATERIAL>100000016</MATERIAL>

<DESCRIPCION>mmpp1</DESCRIPCION>

<TIPO_ARTICULO>3</TIPO_ARTICULO>

<GRUPO_ARTICULOS>014</GRUPO_ARTICULOS>

<LEADTIME>00</LEADTIME>

<CENTRO>0101</CENTRO>

</ACCESS>

</TABLENAME>

</STATEMENT>

</ns0:MT_MATERIALES>

I hope you see the difference that Access node should be inside TABLENAME node. So please change it and re-run your scenario.

Regards,

Rajeev Gupta

Edited by: RAJEEV GUPTA on Feb 26, 2009 11:41 AM