SQL error on the database occurred when accessing a table - SMQ2 in DOE.

[Former Member]

Hi guys, how are?

First of all, I would like to wish a Merry Christmas to all.

So, I am trying to send the information from NW Mobile(DOE) to device mobile(IOs), but when I accesses the SMQ2 all the queue are in SYSFAIL with the following error:

"SQL error on the database occurred when accessing a table".

In ST22 I saw this problem:

Information on where terminated
    Termination occurred in the ABAP program "ZDOECL_052_009_MWSR===========CP" -
     in "IF_CDS_SERVICE~DATA_STAGING_SERVICE".
    The main program was "SAPMSSY1 ".

    In the source code you have the termination point in line 1163
    of the (Include) program "ZDOECL_052_009_MWSR===========CM007".
    The termination is caused because exception "CX_SY_OPEN_SQL_DB" occurred in
    procedure "IF_CDS_SERVICE~DATA_STAGING_SERVICE" "(METHOD)", but it was neither
     handled locally nor declared
    in the RAISING clause of its signature.

    The procedure is in program "ZDOECL_052_009_MWSR===========CP "; its source
     code begins in line
    1 of the (Include program "ZDOECL_052_009_MWSR===========CM007 ".

1154 *    Execute the database operation
1155         IF lv_commitdb EQ 'X' AND NOT lt_t00[] IS INITIAL.
1156           CASE lv_task.
1157             WHEN lc_insert.
1158               TRY.
1159                   INSERT ZDOE05200900 FROM
1160                     TABLE lt_t00.
1161                   fill_shadow_node = 'I'.
1162                 CATCH CX_SY_OPEN_SQL_DB.
>>>>                   MODIFY ZDOE05200900 FROM TABLE
1164                    lt_t00.
1165                   lv_errs_list-MESSAGE_V1 = 'ZDOE05200900'.
1166                   fill_ErrorList 'E' '008'.
1167 *                      MESSAGE w008(smmwcds).
1168                   status = 'INS_FAILED'.
1169                   lv_error = 'X'.
1170                   exit.
1171               ENDTRY.


Thanks in advance,
Eder.

[masa_139]

Please try Edit -> Reset Status.

[Former Member]

Hi Masayuki, how are you

I tried, but did not work.

I found  this topic https://scn.sap.com/thread/970206 . I ll try to do this.

I also read that should be a problem with a compilation in program. Do you have another idea?

If this works I post here.

Thank you again.