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) , Problem

About this page

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

Search for additional results

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