3487885 - Load database taking long time with "send sleep" - SAP ASE

• Load database processing does not complete for a long time
• According to the Backup Server error log, the file load is 100% complete, but the load process on the ASE side stops at "send sleep" status
  
  
    :
  00765: 01: Jun 20 05:09:36 2024: Backup Server: 4.188.1.1: Database SYB: 6320067828 kilobytes (99%) LOADED.
  00765: 01: Jun 20 05:14:52 2024: Backup Server: 4.188.1.1: Database SYB: 6383761540 kilobytes (100%) LOADED.
  00765: 01: Jun 20 05:15:13 2024: Backup Server: 4.188.1.1: Database SYB: 6386552314 kilobytes (100%) LOADED.
  00765: 01: Jun 20 05:15:13 2024: Backup Server: 3.42.1.1: LOAD is complete (database SYB).     <=============
  
  
  
• dbcc stacktrace shows ex_printmsg() and senderror() function
  
  1> dbcc stacktrace(765)
  2> go
  Start dbcc stacktrace...
  pc: 0x0000000001646ba8 upsleepgeneric+0x2f8()
  pc: 0x000000000165624b ussflush+0x68b()
  pc: 0x0000000001c8edb4 senderror+0xda4()
  pc: 0x0000000001c8dc76 ex_printmsg+0xe6()
  [Handler pc: 0x0x0000000000e74fe3 ex_stop_recursion installed by the following function:-]
  pc: 0x0000000001c8d3bd ex__doprint+0x2fd()
  pc: 0x0000000001c900a2 exc_callprint+0x82()
  pc: 0x0000000000921250 redo_endxact+0x502()
    :
  
  

• SAP Adaptive Server Enterprise (ASE) 16.0

runnable, SITE HANDLER, BS, CommVault , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem