Getting an same error

[Former Member]

hi, i m trying to send HTTP data syn to JDBC and a response back

i checked the structure for both sending and receiving to JDBC

and my row is getting updated to data base

i m getting this error

can somebody plz help me out

<SAP:Error>

<SAP:Category>XIAdapterFramework</SAP:Category>

<SAP:Code>MESSAGE.GENERAL</SAP:Code>

<SAP:AdditionalText>com.sap.aii.af.ra.ms.api.DeliveryException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'null': java.lang.IndexOutOfBoundsException: Index: 1, Size: 1</SAP:AdditionalText>

</SAP:Error>

[Former Member]

Hi Aruna,

Facing the same problem since yesterday. It is eating my head now. Do let me know if you face any sucess in this.

Check the thread and try using the experts advice.

Let us see if any thing works for you...

Thanks & Regards,

Jai Shankar.

Message was edited by: Jai Shankar

[Former Member]

Hi Aruna,

Try sending the sql query in this format.

Atleast you would know what the sql query is..

<StatementName6>

<anyName action=” SQL_QUERY” | “SQL_DML”>

<access>SQL-String with optional placeholder(s)</access>

<key>

<placeholder1>value1</placeholder1>

<placeholder2>value2<placeholder2>

</key>

</anyName >

</StatementName6>

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

<ns6:MT_SALETARGET_REQ1 xmlns:ns6="urn:ters.com">

<STATEMENT>

<NAME ACTION="SQL_QUERY">

<ACCESS>SELECT A.YEARMONTH,A.PRODUCTCODE, SUM(A.TARGETVOLUME) AS TARGETVOLUME, SUM(A.TARGETVALUE) AS TARGETVALUE, SUM(B.SALESQTY) AS SALESQTY, SUM(B.SALESVALUE) AS SALESVALUE FROM Saletargets AS A INNER JOIN SALESINFOSTRUCTURE AS B ON A.PRODUCTCODE = B.PRODUCTCODE GROUP BY A.YEARMONTH , A.PRODUCTCODE HAVING A.PRODUCTCODE = 1 and A.YEARMONTH = 200501</ACCESS>

<KEY>

<FISCALYEAR>2006</FISCALYEAR>

<YEARMONTH>100</YEARMONTH>

</KEY>

</NAME>

</STATEMENT>

</ns6:MT_SALETARGET_REQ1>

Regards,

Sumit

[Former Member]

Hi Aruna,

have a look in the payload: SXMB_MONI

- Ist the table element set?

- is the action sttribute set?

- correspond all the fields in the payload to the table on the database?

Regards Mario

Have also a look at:

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

Message was edited by: Mario Müller