Short dump- cx_sy_open_sql_db during Modify statement

[Anja292027]

Hello Expert,

I am getting a short dump with exception CX_SY_OPEN_SQL_DB on MODIFY statement on database.

We have sechduled a job in background in ECC production and we are getting below dump

Category: Installation Error

Runtime Error:   DBIF_RSQL_SQL_ERROR

Exception: cx_sy_open_sql_db

Could you pls suggest here.

Thanks & Regards,

Anjana

[Former Member]

Hi,

Check the index in the statement "MODIFY DBTAB".

Regards,

VS

[former_member188724]

Hi,

How are you using the modify Statement. It is not used correctly to modify the database as it may be missing key fields for updation.

Please send your code used for modify and also work area used for the same.

Regards,

K.S

[Anja292027]

Hello K.S

kindly find the code below.

   FORM update_tvarvc .

* Local data
  DATA : ls_rdate TYPE tvarvc.

  ls_rdate-name = gc_rdate.
  ls_rdate-type = gc_p.
  ls_rdate-numb = gc_numb.
  ls_rdate-low  = p_rdate.

  MODIFY  tvarvc FROM ls_rdate.

ENDFORM.                    " UPDATE_TVARVC

This is not a new program. we run this program everyday

Thanks

[former_member188724]

Hi,

Did the program run successfully yesterday?

If success then check the values that you would have got for today's run.

Pls check for value passed in gc_numb as it's size could have been more than 4 length.

Regards,

K.S

[Former Member]

Probably there is some field wrong when you try to modify. Something like the field is a number and you're sending a text

Try to use try-catch to avoid this dump, maybe you can get the error

DATA:
  o_cx_root TYPE REF TO cx_root.

DATA:
  v_erro TYPE string.

START-OF-SELECTION.

  TRY.

*  modify.....

    CATCH cx_root INTO o_cx_root.
      v_erro = o_cx_root->get_text( ).
  ENDTRY.