2279496 - Planning Calendar with red traffic light because deadlocks in Job Scheduler - SAP ASE for BS

• ASE error log ($SYBASE/$SYBASE_ASE/install/<SID>.log) it is reporting frequent deadlocks involving the js_history table from the Job Scheduler database (sybmgmtdb), i.e.:

Deadlock Id 2902 detected. 1 deadlock chain(s) involved.

Deadlock Id 2902: Process (Familyid 0, Spid 61, Suid 3) was executing a SELECT command in the procedure 'sp_writejoboutput' at line 54 at nested level 1.
Deadlock Id 2902: Process 61 was involved in application 'JS Agent'.
Deadlock Id 2902: Process 61 was involved on host name ''.
Deadlock Id 2902: Process 61 was involved in transaction 'sp_writejoboutput'.
SQL Text: sp_writejoboutput '829687', 'Changed database context to ''saptools''.
(return status = 0)

Executing procedure: sp_writejoboutput
Subordinate SQL Text:
select @user_name=jsh_user_req, @tot_size=jsh_size from sybmgmtdb..js_history where jsh_exid=@run_id

Deadlock Id 2902: Process (Familyid 0, Spid 63, Suid 3) was executing a UPDATE command in the procedure 'sp_js_agent' at line 272 at nested level 1.
Deadlock Id 2902: Process 63 was involved in application 'JS Agent'.
Deadlock Id 2902: Process 63 was involved on host name ''.
Deadlock Id 2902: Process 63 was involved in transaction '$upd'.
SQL Text: sp_js_agent 'setstate=C1,id=829697'
Executing procedure: sp_js_agent
Subordinate SQL Text:
update sybmgmtdb..js_history set jsh_state=@state where jsh_exid = @id

Deadlock Id 2902: Process (Familyid 0, Spid 63) was waiting for a 'update row' lock on row 20 page 1896 of the 'js_history' table in database 'sybmgmtdb' but process (Familyid 0, Spid 61) already held a 'exclusive row' lock on it.
Deadlock Id 2902: Process (Familyid 0, Spid 61) was waiting for a 'shared row' lock on row 17 page 1896 of the 'js_history' table in database 'sybmgmtdb' but process (Familyid 0, Spid 63) already held a 'exclusive row' lock on it.

Deadlock Id 2902: Process (Familyid 0, Spid 61) was chosen as the victim.
Victim process host = `', user = `jstask' program name = `JS Agent' host processes = `30998778' .

• Checking the Job Scheduler Agent log ($SYBASE/$SYBASE_ASE/install/JSAGENT.log) several errors 1205 (deadlocks) are reported.

worker Server message: Your server command (family id #0, process id #61) encountered a deadlock situation. Please re-run your command.
worker jso_FlushBuffer: jsd_GetResults() failed for xid 829687

• As result, from DBACockpit of SAP Systems, the Planning Calendar is showing tasks with red traffic light.
• For the DUMP DATABASE tasks, when checking the backup filesystem you can see the DUMP DATABASE files are correctly generated despiste that red traffic light for the task in Planning Calendar.
  
  
• Restarting the Job scheduler process does not help.

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

"js stop", "js start", "reorg rebuild", sp_js_agent, js_history, SQL1205, 1205, deadlock , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem