AMDP -Virtual table update - Deadlock on lock resources

[former_member543781]

Hello,

we try to update one line in virtual table:

  METHOD update_data_dup_vis_sum
      BY DATABASE PROCEDURE
      FOR HDB
      LANGUAGE SQLSCRIPT.

    UPDATE "STG"."CF_TABLE"
       SET "Current_Ind" = :iv_current_ind
     WHERE x   = :iv_x
       AND y   = :iv_y;
  endmethod.

In SAP - ABAP we call this method multiple times inside LOOP.

We get dump: CX_AMDP_EXECUTION_FAILED

Is there any why to avoid deadlock on update? maybe with HINT{for sql server}?

Can we lock only one row in the table? or cancel the table lock?