Error while parsing or executing XML-SQL document

[Former Member]

Hi all,

I am working on an HTTP-JDBC scenario (stored procedure). My scenario throws an error at Call Adapter phase. The error description is as follows:

Error while parsing or executing XML-SQL document: Error processing request in sax parser: Error when executing statement for table/stored proc. 'spSAPXIDemo' (structure 'Statement'): java.lang.IllegalArgumentException.

Could anyone please help me in resolving the issue?

Thanks

Chilanka

[bhavesh_kantilal]

><i>java.lang.IllegalArgumentException.</i>

One of the arguments passed to the Stored Procedure is incorrect.

What is the message going out of XI to the Stored Procedure?

1. Have you accoaited every element with the attribute type?

2. Have you give theattribuite isInput / isOutput as needed.

Regards

Bhavesh

[Former Member]

Hi Bhavesh,

I have associated every element with attribute 'type'.

But haven't defined attribute 'isInput' since optional. Anyways lemme try that and 'll let you know.

Thanks

Chilanka

[Former Member]

Hi Bhavesh,

I have defined the attribute isInput too. Still getting the same error message.

Kindly check the message going out of XI to stored procedure.

<ns1:JDBC_REQ_MT xmlns:ns1="http://POC">

- <Statement>

- <Storedprocedure action="EXECUTE">

<table>spSAPXIDemo</table>

<SONum isInput="true" type="CHAR">000000930181</SONum>

<Projectcode isInput="true" type="CHAR">SAPXI</Projectcode>

<Validfrom isInput="true" type="DATE">01012006</Validfrom>

<Validto isInput="true" type="DATE">01012007</Validto>

</Storedprocedure>

</Statement>

</ns1:JDBC_REQ_MT>

Thanks

Chilanka

[bhavesh_kantilal]

Hi,

The isInput = should have a value 1 and not true.

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

Also, make sure that the date parameters that a date in a valid format, i.e, the date fromat should be as per the format expected by the database.

Regards

Bhavesh

[Former Member]

Hi,

Please check the structure as per JDBC approved / specified structure which was in above link (ref by bhavesh). Also see the order of the fields which are mensioned in stored procedure and the structure which you have in receiver side.

order is also important

Regards

Chilla