2608960 - Deadlock between two processes with shared lock - SAP ASE

• SAP ASE database server reported deadlock on processes both with shared locks.
• server Deadlock Id 10 detected
  Deadlock Id 10 detected. 1 deadlock chain(s) involved.
  Deadlock Id 10: Process (Familyid 0, Spid 841, Suid 45) was executing a INSERT command in the procedure '<stored procedure name>' at line 29 at nested level 1.
  Deadlock Id 10: Process 841 was involved in application ''.
  Deadlock Id 10: Process 841 was involved on host name '<host name>'.
  Deadlock Id 10: Process 841 was involved in transaction '$ins'.
  SQL Text: <executing line from the stored procedure>
  Executing procedure: <stored procedure name>
  Subordinate SQL Text:
  .............................
  Deadlock Id 10: Process (Familyid 0, Spid 938, Suid 45) was executing a SELECT command in the procedure '<stored procedure name>' at line 279 at nested level 1.
  Deadlock Id 10: Process 938 was involved in application ''.
  Deadlock Id 10: Process 938 was involved on host name 'host name>.
  SQL Text: etl_curr
  Executing procedure: <stored procedure name>
  Subordinate SQL Text:
  ...................................
  Deadlock Id 10: Process (Familyid 0, Spid 938) was waiting for a 'shared page' lock on page 295761 of table 'table name' in database 'database name' but process (Familyid 0, Spid 841) already held a 'shared page' lock on it.
  Deadlock Id 10: Process (Familyid 0, Spid 841) was waiting for a 'shared page' lock on page 295742 of table 'table name' in database 'database name' but process (Familyid 0, Spid 938) already held a 'shared page' lock on it.
  Deadlock Id 10: Process (Familyid 0, Spid 841) was chosen as the victim.
  Victim process host = `host name', user = `user name' program name = `' host processes = `' .
  End of deadlock information.

• SAP Adaptive Server Enterprise (ASE) 15.7
• SAP Adaptive Server Enterprise (ASE) 16.0

isolation level 0, dirty reads, dead lock, shared lock , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem