Error when executing statement for table/stored proc DB2 - Data Truncation

[Former Member]

Hi,

I have one call sp in XI with n parameters int and two parameters out.

well, to implement the interface gives the following error

com.sap.aii.af.ra.ms.api.DeliveryException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'SPSAPAR9' (structure 'Statement'): java.sql.SQLException: The number of parameter values set or registered does not match the number of parameters

Thanks for your help

Ximena

Edited by: Ximena Gonzalez on Feb 19, 2008 11:50 AM

Edited by: Ximena Gonzalez on Feb 20, 2008 12:17 PM

[Former Member]

in MM is defined

Error when executing statement for table/stored proc. 'SPSAPAR9' (structure 'Statement'): java.sql.SQLException: Símbolo $OUT no válido. Símbolos válidos:

without "out"

error ->com.sap.aii.af.ra.ms.api.DeliveryException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'SPSAPAR9' (structure 'Statement'): java.sql.SQLException: The number of parameter values set or registered does not match the number of parameters

thank's for you help

[Former Member]

<ISAPSW IsOutput="TRUE" type="INTEGER" />

is wrong.

The parameter for stored procedure is OUTISAPSW. then you should use the same.

[nikhil_bose]

1. Number of parameters in the Call function is not equal to what is in the <key>

2. <ISAPSW IsOutput="TRUE" type="INTEGER" /> This is wrong

</> describes an empty string.

3. Check in the database stored proc for the parameters.

I thing error is because of the last XML tag, make it correct and reply status

regards,

nikhil

[Former Member]

The Store Procedure is definid this.

CREATE PROCEDURE SAPPRG/SPSAPAR9 (

IN ISAPNU1 INTEGER,

IN ISAPEM1 CHAR(2),

IN ISAPC05 INTEGER,

IN ISAPSEC INTEGER,

IN ISAPLOT CHAR(15),

IN ISAPCA1 DEC(9),

IN ISAPCA2 DECIMAL (9),

IN ISAPKIL DECIMAL (15),

IN ISAPES1 CHAR(1),

OUT ISAPSW INTERGER)

/* OUT ISAERR INTEGER) */

[Former Member]

My Error is change

Error while parsing or executing XML-SQL document: Error processing request in sax parser: Error when executing statement for table/stored proc. 'SAPPRG.SPSAPAR9' (structure 'Statement'): java.sql.DataTruncation: Data truncation

but de change DT SP

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

<ns1:AlistReqDet2_MT xmlns:ns1="urn:proxl:tmuc:proxl01:AlistReqItems">

<Statement>

<SPSAPAR9 action="EXECUTE">

<table>SAPPRG.SPSAPAR9</table>

<ISAPNU1 isInput="TRUE" type="STRING">0080000353</ISAPNU1>

<ISAPEM1 isInput="TRUE" type="STRING">'LU'</ISAPEM1>

<ISAPC05 isInput="TRUE" type="STRING">15353</ISAPC05>

<ISAPSEC isInput="TRUE" type="STRING">10</ISAPSEC>

<ISAPLOT isInput="TRUE" type="STRING">'lats'</ISAPLOT>

<ISAPCA1 isInput="TRUE" type="STRING">10</ISAPCA1>

<ISAPCA2 isInput="TRUE" type="STRING">10</ISAPCA2>

<ISAPKIL isInput="TRUE" type="STRING">10</ISAPKIL>

<ISAPES1 isInput="TRUE" type="STRING">'T'</ISAPES1>

<ISAPSW isOutput="TRUE" type="STRING" />

</SPSAPAR9>

</Statement>

</ns1:AlistReqDet2_MT>

[Former Member]

Check :

- Value in your Date Field

- in your JDBC CC, you have an "advanced" tab where you can manage data/time format for procedured stock calls. Verify that you have put the right things like 'yyyymmdd'.

Regards,

JP

Edited by: Jean-Philippe PAIN on Feb 19, 2008 3:54 PM

[Former Member]

The error continue....

The configuration is

Data/TIme Format For Stored-Procedure Calls

Date-> dd

Time ->hh.mm

TimeStamp ->yyyyMMdd

com.sap.aii.af.ra.ms.api.DeliveryException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'SAPPRG.SPSAPAR9' (structure 'Statement'): java.sql.DataTruncation: Data truncation