SAP Knowledge Base Article - Preview

2284055 - sp_who shows 1000s of spids with loginame Null and cmd in Maintenance Token. Error 1601 in the errrolog - SAP ASE

Symptom

  • sp_who shows loginame as NULL and cmd in MAINTENANCE TOKEN  for thousands of logins:   

fid spid status      loginame   origname   hostname   blk_spid dbname      tempdbname  cmd               block_xloid threadpool
--- ---- ----------- ---------- ---------- -------------- -------- ----------- ----------- ----------------- ----------- ----------------
   0   17 sleeping    NULL       NULL        bs041         0 master      master      MAINTENANCE TOKEN           0 NULL
   0   18 sleeping    NULL       NULL        bs039         0 master      master      MAINTENANCE TOKEN           0 NULL
   0   19 sleeping    NULL       NULL        bs040         0 master      master      MAINTENANCE TOKEN           0 NULL
   0   20 sleeping    NULL       NULL        bs038         0 master      master      MAINTENANCE TOKEN           0 NULL
   0   21 sleeping    NULL       NULL        bs038         0 master      master      MAINTENANCE TOKEN           0 NULL
(...deleted for brevity...)

  • The only login for the hosts shown is locked.  
     
  • The errorlog has thousands of Error 1601:

Error: 1601, Severity: 17, State: 3
There are not enough 'user connections' available to start a new process. Retry when there are fewer active users, or ask your System Administrator to reconfigure ASE with more user connections.  

  • CPU usage is near 100%.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.x
  • SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; Sybase Adaptive Server Enterprise 15.0 ; Sybase Adaptive Server Enterprise 15.5

Keywords

authentication, engine , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To

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.