jdbc error

[Former Member]

Scenario: IDOC - Oracle DB

When I post an idoc in r/3, its triggering fine and also in sxmb_moni is showing a chequered flag. so idoc is reching xi properly.

but when i monitor CC in runtime workbench... i am getting the below error.

Error while parsing or executing XML-SQL document: Error processing request in sax parser: Error when executing statement for table/stored proc. 'REPLIC_CHASSIS_VENDA' (structure 'STATEMENTNAME'): java.sql.SQLException: ORA-00913: too many values

Please lemme know.

Thanks

Kiran

[Former Member]

Hi,

Can u try with the following structureas this is working very well for my scenario:

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

- <ns0:MT_JDBC_MARA xmlns:ns0="urn:abc:mm">

- <Statement>

- <MARA_UPDATE action="EXECUTE">

<MATERIAL_CODE type="CHAR">000000000001001425</MATERIAL_CODE>

<DESCRIPTION type="CHAR">NEOLIPID </DESCRIPTION>

<MATERIAL_GROUP_CODE type="CHAR">4000</MATERIAL_GROUP_CODE>

<MATERIAL_GROUP_DESC type="CHAR">Exports-USA</MATERIAL_GROUP_DESC>

<BASE_UNIT type="CHAR">S10</BASE_UNIT>

<SAP_ADD_DATE type="CHAR">19990511 00:00:00.000</SAP_ADD_DATE>

<SAP_MODIFY_DATE type="CHAR">20050124 00:00:00.000</SAP_MODIFY_DATE>

<EXTRACT_DATE type="CHAR">20080107 00:00:00.000</EXTRACT_DATE>

</MARA_UPDATE>

</Statement>

</ns0:MT_JDBC_MARA>

Warm Regards,

N.Jain

[Former Member]

hai nishu

i didnot understand what u meant?

can u correct my structure and let me know plz.

thansk

kiran

[Former Member]

any clues plz

[prabhu_s2]

it is an error with the recv CC. Check the XML strucutre for the target.

http://help.sap.com/saphelp_nw04/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm

Edited by: Prabhu S on Jan 9, 2008 8:06 AM

[Former Member]

i ve checked the pay load too..

its seems fine

i am doing 3 similar scenarios with different idocs. 1st was fine. so i almost done the similar config.

any more plz

thanks

kiran

Edited by: kiran dasari on Jan 9, 2008 12:37 PM

[prabhu_s2]

is the below strucute as per ur target efintion:

<root>

<StatementName1>

<dbTableName action=”UPDATE” | “UPDATE_INSERT”>

<table>realDbTableName</table>

<access>

<col1>val1</col1>

<col2>val2new</col2>

</access>

<key1>

<col2>val2old</col2>

<col4>val4</col4>

</key1>

<key2>

<col2>val2old2</col2>

</key2>

</dbTableName>

</StatementName1>

or can u post the payload of ur target strucutre def

Edited by: Prabhu S on Jan 9, 2008 8:10 AM

[Former Member]

yes its the same.

however, here is the payload.

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

- <ns0:MTUpdateNFDataReceiver xmlns:ns0="http://deere.com/xi/ijdsouthamerica/Warranty">

- <STATEMENTNAME>

- <ROW action="INSERT">

<TABLE>REPLIC_CHASSIS_VENDA</TABLE>

- <access>

<VNUMEROCHASSIS>000000000000000003</VNUMEROCHASSIS>

<DDATAFATURAMENTO>26/10/2007</DDATAFATURAMENTO>

<NVALORBCCR>0,02</NVALORBCCR>

<VCLIENTE>99999S2410</VCLIENTE>

<VCONCESSIONARIO>99999S2401</VCONCESSIONARIO>

<VPAISDESTINO>AP</VPAISDESTINO>

<NPRODUTOCOMPLETO />

<VCOMENTARIO />

</access>

</ROW>

</STATEMENTNAME>

</ns0:MTUpdateNFDataReceiver>

[prabhu_s2]

maybe chekc for the number of fields inserted.

[Former Member]

sender structure is equivalent to receiver

plz concentrate on the last phrase in the error message: "too many values"

thanks

kiran

[Former Member]

Hi,

The field name and the table name are case-sensitve, so check the exact table name and the field name specified in the Oracle table and also provide the same name in the data structure created for the JDBC structure.

Regards,

Nithiyanandam

[Former Member]

hi..

i ve verified that 22

any more clues plz.

thanks

kiran

[prabhu_s2]

plz concentrate on the last phrase in the error message: "too many values"

yeah thats the reason for asking to check the number of fields inserted; to se if the total number of fields are in sync with the table.

also check for the right namespace

[Former Member]

hi prabu

they r in sync.

and its in the right namespace 2.

any more plzz.

thanx

kiran

[Former Member]

Hi Kiran,

There is a small mistake in your structure. Just after "STATEMENTNAME" you should write the table name "REPLIC_CHASSIS_VENDA" and then under your table name rest of the things will come. Just see the hierarchy as I have declared below and follow the same.

Make the same changes in you structure and activate the scenario. I hope it will work.

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

<ns0:MTUpdateNFDataReceiver xmlns:ns0="http://deere.com/xi/ijdsouthamerica/Warranty">

<STATEMENTNAME>

-

---

< REPLIC_CHASSIS_VENDA >

-

---

< action="INSERT">

-

---

<TABLE>REPLIC_CHASSIS_VENDA</TABLE>

-

---

<access>

-

---

<VNUMEROCHASSIS>000000000000000003</VNUMEROCHASSIS>

-

---

<DDATAFATURAMENTO>26/10/2007</DDATAFATURAMENTO>

-

---

<NVALORBCCR>0,02</NVALORBCCR>

-

---

<VCLIENTE>99999S2410</VCLIENTE>

-

---

<VCONCESSIONARIO>99999S2401</VCONCESSIONARIO>

-

---

<VPAISDESTINO>AP</VPAISDESTINO>

-

---

<NPRODUTOCOMPLETO />

-

---

<VCOMENTARIO />

-

---

</access>

</STATEMENTNAME>

</ns0:MTUpdateNFDataReceiver>

Regards,

Sarvesh

[Former Member]

hai sarvesh

as i said i am working onl almost 3 scenarios and my 1st scenario is working fine with the similar kind of structure and i guess it shud be like that only. first come action and then table name.

thanks

kiran