2985083 - Workload Analyzer replay hangs at 99.9% and never completes - SAP ASE

• Workload Analyzer replay hangs at 99% and never completes.

• "sp_who" output shows a connection at the target ASE still active.

• "dbcc stacktrace" output shows the hanging spid is sleeping under conn_hdlr_reg_cleanup():
  

  dbcc stacktrace (4681) -- hanging spid
  go
  Start dbcc stacktrace...
  pc: 0x00000000022160cd upsleepgeneric+0x34d()
  pc: 0x0000000002247338 ussflush+0x7e8()
  pc: 0x0000000002247c62 usseom+0x102()
  pc: 0x000000000182f461 conn_hdlr_reg_cleanup+0xa1()
  [Handler pc: 0x0x00000000021a97c0 ut_handle installed by the following function:-]
  pc: 0x0000000001831f06 conn_hdlr+0x1356()
  dbcc stacktrace finished.

• "dbcc pss" output shows the connection is hitting Msg 1622, Level 18, State 1: Line 1: Type '7' not implemented.

  dbcc pss (204,4681,0)
  go
  PSS (any state) for suid 204 - spid 4681:
  PSS at 0x0x2ab03d706088
  pcurcmd=0 (GENERIC_TOKEN)

  .... output omitted ....

  **** Printing errors starting from most recent one: ****
  
  Statement rollback is OFF perror_locn = 0
  [1] error=1622 (INIT) severity=18 (EX_INTOK) state=1
  (file=conn_hdlr.c@@/main/asecorona/ase160sp03plx/ase160sp03pl07x/2 2019-05-21 line=2375)
  curcmd=0 (GENERIC_TOKEN) stmtctr=40
  curdb=6 cmderrs=0x(nil) (0x00000000)
  begin xact=(0, 0) status=0x0x3 (0x0002 (FROM EX_RAISE), 0x0001 (FROM EX_PRINT))
  Exception hdlrfn='ut_handle' hdlr retval=3 (EX_BACKOUT) psse_exc_path=0x0
  Previous handler's retval: 3 (EX_BACKOUT)
  Previous handler's retval: 3 (EX_BACKOUT)
  Previous handler's retval: 3 (EX_BACKOUT)

• May also see in the WLACLIUtil.log:
  [WARN ] [Thread-5] [com.sybase.workload.replay.control.ReplayEngine.writeWarningLog(62)] - TDSRetriver->repository delay is too long for capture captureId=XXX,startRow=xxx,rowCount=XXX,delay=XXX
  
  

• SAP Adaptive Server Enterprise (ASE)
• Workload Analyzer

WKLD, Error 1622, CR 823290, CR823290, 823290 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed