on 07-15-2013 8:26 AM
Dear Experts,
I am trying to use stored procedure in the JDBC receiver scenario. When I am firing the scenario from the R/3 server using client proxy I am getting a clean transaction with chequered flag in SXMB_MONI. But when I am checking in RWB I am getting the following error:
I have mentioned the name of the stored procedure in the TABLE field and EXECUTE in the action field in the receiver JDBC structure. The input payload generated is as follows:
<?xml version="1.0" encoding="utf-8" ?>
</n0:MT_R3MSSQL_PRXY>
Can somebody guide how to overcome the error which I am getting while inserting the data in the database.
Thanking You
Regards
Suhas
Message processing failed. Cause: com.sap.engine.interfaces.messaging.api.exception.MessagingException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'dbo.ZFT_MIS_DATA_BRANCH_KP_modify' (structure 'STATEMENT'): java.sql.SQLException: ERROR: Invalid XML document format for stored procedure: 'type="<SQL-type>"' attribute is missing for element 'access' (Setting a SQL-type (e.g. INTEGER, CHAR, DATE etc.) is mandatory !)
Hello,
Can you paste your target structure? Your SP structure should look like below format, so you can cross check the same?
<StatementName5>
<storedProcedureName action=” EXECUTE”>
<table>realStoredProcedureeName</table>
<param1 [isInput=”true”] [isOutput=true] type=SQLDatatype>val1</param1>
</storedProcedureName >
</StatementName5>
http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm
BTW, your error suggest that you are missing out some of the attributes values in the SP structure.
Thanks
Amit Srivastava
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Amit,
As asked by you the target stuctutre is as follows:
<?xml version="1.0" encoding="UTF-8" ?>
</dbTableName>
</STATEMENT>
</ns0:MT_R3MSSQL_PRXY_REC>
Yes I too believe that some attribute is missing. Pls let me know what is that I am missing ?
Thanks
With Best Regards
Suhas
Hello,
You have used incorrect SP structure. Check below blogs:
http://scn.sap.com/people/siva.maranani/blog/2005/05/21/jdbc-stored-procedures
Thanks
Amit Srivastava
Hi,
As Amit say it will be easier to find the problem with the stored procedure call. You should check that all the parameters have a type, and put them in lower case, like:
<storedProcedureName action="EXECUTE">
<table>Example</table>
<inputparam type="char">123</inputparam>
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.