Error when executing statement for table/stored proc

[Former Member]

Hi,

I am doing a IDOC to JDBC scenario. Every thing is fine in SXMB_MONI messages.

But in message monitoring and component monitoring this is the error showing...

<i>Error while parsing or executing XML-SQL document: Error processing request in sax parser: Error when executing statement for table/stored proc. 'COGRP_TMP_PROC' (structure 'Statement'): java.sql.SQLException: General error</i>

Here is the mapping from IDOC to Stored Procedure...

                               *RTACOGRP_RECEIVER_MT
*COGRP01   ------------------->  *Statement
   * IDOC                                 *COGRP_TMP_PROC
       * BEGIN                              action
       * EDI_DC40                         *IDOCNUMBER
             SEGMENT                        isInput(TRUE)
             TABNAME                        type(CHAR)
              -------
              --------
             --------
        *E1COGH  ----------------->E1COGH_MSGFN
            SEGMENT
            MSGFN

Is there any error in mapping to Statement...

Can any body please let me know the error

Thanks in Advance

Murthy

[bhavesh_kantilal]

Murthy,

Maybe you should also link the same question you raised earlier so that you do not get repetitive answers,

Regards

Bhavesh

[Former Member]

Hay Murthy,

did you managed to activate the stored proc without SAP XI? are you sure it's working? I'd do a double check and then use the XI test tool to make sure that the structure is (a) exactly the right structure and (b) have the right values.

good luck,

Uri.

[Former Member]

Uri,

I tried to execute the stored procedure by giving the same values as passed through IDOC and was running fine in sql server.

I have also tried from xi side by commenting the insertion part of stored procedure , in that case that was running fine. when come to the entering of values in to the table error are occurning.

Please check my previous theread..

Can you please correct the mapping as told.

Thanks,

Murthy.

[bhavesh_kantilal]

Murthy,

><i>I have also tried from xi side by commenting the insertion part of stored procedure</i>

Can you try explaining this with the Stored Procedure? Does this imply that when you comment the Insert statement in the Stored procedure there is no error in XI?

If yes, does nt this imply that there is some issue with the Stored Procedure? Maybe an authorization issue wit the user id in the JDBC adapter? Maybe you can check the logs of the database and see if there is any info.

Regards

Bhavesh

[Former Member]

Bhavesh,

I completly mis understood, that XI was not giving any errors when I commented the insertion part of the Strored Procedure.

In SXMB_MONI there was no errors, but when in message monitoring and component monitoring these are the errors....

<i>Error while parsing or executing XML-SQL document: Error processing request in sax parser: Error when executing statement for table/stored proc. 'COGRP_TMP_PROC' (structure 'Statement'): java.sql.SQLException: General error</i>

Do we need mapping to the Statement tag with any of the IDOC tag.

I am trying to map to Statement <----

---

COGRP01 and also tried Statement --->EDI_DC40.

Can you tell me is there any problem with mapping ...

Thanks

Murthy