Symptom
- Auditing segment filled up:
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. - Auditing was turned off, truncated the audit table, ran "sp_configure 'current audit table', 1 'with truncate'", set up a second audit segment and audit table, and turned-on auditing.
- Auditing as turned off and on and switched the tables a few times.
- Originally. the "suspend audit when device is full" configuration option was set to 1.
- It was then set to 0 to flush the audit queue and then set "suspend audit when device is full" back to 1.
- Everything looks ok but nothing is getting logged in either table.
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 16.0
Product
SAP Adaptive Server Enterprise 16.0
Keywords
audproc, terminating, terminate, sp_audit, restart, status , 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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.