SAP Knowledge Base Article - Preview

2700728 - Unable to add new login due to ASE hang - SAP ASE

Symptom

  • Unable to read in login record
  • sp_who shows SPID in a Maintenance Token

    spid: 1114, kpid: 353698651, pss: 0x0x238cc0470, proc: 0x0x17e6ea830 dbid: 1
    task: 0x146bf9950, threadpool: 0x1469f6e10 (syb_default_pool)
    pmemusage: 2, ptempdb_pages: 0, pcputot: 0, pcpucur: 94
      User: sa, Host: hostname, Program: ISQL, Command: 0 MAINTENANCE TOKEN
      Status: (0x00010000 (P_USERPROC), 0x00000002 (P_KILLYOURSELF))

  • Top function calls in stacktrace of a spid in Maintenance Token
    • lock_do_logical+0x960()
    • fg_lock+0x206()
    • bt__lock+0x221()
    • bt_getnext+0x11b()
    • dol_bt_getnext+0x1a1()
    • getnext+0x413()
       
  • unexplained system hang
  • unable to login to the system


Read more...

Environment

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

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

CR812460, CR#812460, 812460, kerberos login, uppushaffinity, hung, external security , 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.