2664726 - Processes hang in SAPLSEUAX on SNAPT, REPOLOAD, TADIR - SAP ASE for Business Suite

SAP work processes hang in FM SAPLSEUAX accessing table SNAP

Per SM50 & SM66, there are several calls hung in SAPLSEUAX due to a deadlock situation between the READs on REPOLOAD / SNAPT and INSERTs on SNAP.

There are sequential reads on tables: REPOLOAD, SNAP* as well as while updating table: TADIR.

The developer (work process) trace shows:

*** ERROR => reload_user_parameter: *** no current user logged on *** [sign.c 4641] {root-id=35423136313041353542313631304135}_{conn-id=00000000000000000000000000000000}_0
Wed Jun 6 01:41:13:001 2018 ERROR: -1 in function ExeNormalModify (execute) [line 30293] (1205) [40001] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]Your server command (family id #0, process id #234) encountered a deadlock situation. Please re-run your command.
statement id is ==> [13 RIS_PROG_TADIR 34304 20121022154204] ERROR: -1 in function GetTranState (SQLExecDirect failed) [line 47081] evaluation of transaction state failed. DbSlEndModify after transaction was aborted: only rollback permitted


Primarily in this ABAP class -

Calls R=1 T=a S=vhgbafidci_FID_00 I=CL_RIS_HANA_INDEX_HANDLER=====CP F=RS_UPDATE_PROG_TADIR_INDEX_RFC C=10

There are no corresponding active processes for these wps, on the database. The hung wps, on rare occasions, may still be holding onto the transaction log space on the database.

• SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
• SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
• SAP NetWeaver (NW) - All versions 

CL_RIS_HANA_INDEX_HANDLER, deadlock, SNAP, REPOLOAD, SNAPT, SAPLSEUAX, TADIR, 1205, RIS_PROG_TADIR , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BC-DWB-UTL-INR , Repository Infosystem , Problem