SAP Knowledge Base Article - Preview

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

Symptom

  • 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


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE)
  • Workload Analyzer

Product

SAP Adaptive Server Enterprise 16.0

Keywords

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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.