Symptom
Users are not allowed to login - they get stuck on a maintenance token.
- ASE log shows:
AUDIT PROCESS EXCEPTION: Can't allocate space for either syslogs or the current sysaudit table in database 'sybsecurity' because the corresponding segment is full/has no free extents. Please refer to Security Administration Guide for details.
- sp_who shows:
172 XXXXXX YYYYYY user sleeping MAINTENANCE TOK 0
- dbcc stacktrace shows:
1> dbcc stacktrace(172)
2> go
Start dbcc stacktrace...
pc: 0x00C8AF72 kpsuspend+ 0x7e (0x63040000, 0x63040010, 0x00000004, 0x00000001)
pc: 0x00CA1991 upsleepgeneric+ 0x6fa (0x63040000, 0x00000000, 0x0116E9C0, 0x0172AFFB)
pc: 0x00CC061C uboallocw+ 0x152 (0x0000002D, 0x00000001, 0x00000001, 0x02030001)
pc: 0x007270A6 send_audit+ 0xda9 (0x0000002D, 0x00000001, 0x21790001, 0x00000000)
pc: 0x00729C32 form_and_send_audit+ 0x7ea (0x0000002D, 0x00000001, 0x00000000, 0x00000000)
pc: 0x0072A6C0 chk_and_send_audit+ 0xa81 (0x00000000, 0x00000000, 0x00000000, 0x00000000)
[Handler pc: 0x00489122 hdl_backout installed by the following function:-]
pc: 0x0043C517 login+ 0x2247 (0x0000003D, 0x00000000, 0x00000000, 0x22184200)
[Handler pc: 0x00489122 hdl_backout installed by the following function:-]
[Handler pc: 0x00757D40 ut_handle installed by the following function:-]
[Handler pc: 0x00757D40 ut_handle installed by the following function:-]
pc: 0x00422E4D conn_hdlr+ 0xb03 (0x22184200, 0x00000000, 0x00000000, 0x22184200)
pc: 0x00C8B017 kpntwrapper+ 0x84 (0x00C8AF93, 0x22184200, 0x00310077, 0x00700070)
pc: 0x77E6481F GetModuleHandleA+ 0xdf (0x00000000, 0x00000000, 0x00000000, 0x00000000)
dbcc stacktrace finished.
DBCC execution completed. If DBCC printed error messages, contact a user with System Administrator (SA) role.
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 15.7
Product
Keywords
Connectivity, Maintenance Token , 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.