Symptom
- In an ASE system with auditing enabled and 'suspend audit when device full' is on (which is DEFAULT setting)
- User logins hang
- Many processes show MAINTENANCE TOKEN in cmd column in sp_who / sysprocesses output
- The Audit Process hit error 1204 'out of locks':
Error: 1204, Severity: 17, State: 1
ASE has run out of LOCKS.
Re-run your command when there are fewer active users, or contact a user with System Administrator (SA) role to reconfigure ASE with more LOCKS. - The ASE errorlog may show an message that shows there was an Audit Process Exception
Read more...
Environment
SAP Adaptive Server Enterprise (ASE)
Product
SAP Adaptive Server Enterprise all versions
Keywords
MAINTENANCE TOKEN, maintenance token, 1204, error 1204, Error: 1204, logins hang, logins hung, sysaudit, sybsecurity , sp_who . sysprocesses , 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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview