topic Re: Short dump- cx_sy_open_sql_db during Modify statement in Application Development and Automation Discussions

Short dump- cx_sy_open_sql_db during Modify statement

Anja292027 — Thu, 09 Oct 2014 09:55:20 GMT

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

Re: Short dump- cx_sy_open_sql_db during Modify statement

Former Member — Thu, 09 Oct 2014 10:00:33 GMT

Hi,

Check the index in the statement "MODIFY DBTAB".

Regards,

Re: Short dump- cx_sy_open_sql_db during Modify statement

former_member188724 — Thu, 09 Oct 2014 10:01:22 GMT

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

Re: Short dump- cx_sy_open_sql_db during Modify statement

Anja292027 — Thu, 09 Oct 2014 10:07:00 GMT

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

Re: Short dump- cx_sy_open_sql_db during Modify statement

Former Member — Thu, 09 Oct 2014 10:07:59 GMT

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.

Re: Short dump- cx_sy_open_sql_db during Modify statement

former_member188724 — Thu, 09 Oct 2014 11:15:35 GMT

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