Skip to Content
0
Former Member
Jun 07, 2007 at 01:14 PM

Error when executing statement for table/stored proc

959 Views

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