cancel
Showing results for 
Search instead for 
Did you mean: 

jdbc error

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

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
0 Kudos

hai nishu

i didnot understand what u meant?

can u correct my structure and let me know plz.

thansk

kiran

Former Member
0 Kudos

any clues plz

prabhu_s2
Active Contributor
0 Kudos

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
0 Kudos

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
Active Contributor
0 Kudos

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
0 Kudos

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
Active Contributor
0 Kudos

maybe chekc for the number of fields inserted.

Former Member
0 Kudos

sender structure is equivalent to receiver

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

thanks

kiran

Former Member
0 Kudos

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
0 Kudos

hi..

i ve verified that 22

any more clues plz.

thanks

kiran

prabhu_s2
Active Contributor
0 Kudos

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
0 Kudos

hi prabu

they r in sync.

and its in the right namespace 2.

any more plzz.

thanx

kiran

Former Member
0 Kudos

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
0 Kudos

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