SAP Knowledge Base Article - Preview

3737442 - Server not starting due to sybsecurity set to read-only - ASE

Symptom

  • The following auditing configuration parameter are enabled

current audit table
suspend audit when device full
auditing

  • sybsecurity database is set to read-only

1> sp_helpdb sybsecurity
2> go
 name                   db_size                    owner      dbid
         created                  durability           lobcomplvl
         inrowlen
         status
 ---------------------- -------------------------- ---------- ----------
         ------------------------ -------------------- --------------------
         ----------------
         ----------------------------------------------------------------------------------------------------------------------
 sybsecurity                 200.0 MB              sa         31515
         Apr 04, 2026             full                          0
             NULL
         select into/bulkcopy/pllsort, trunc log on chkpt, read only

  • sysdatabases status 1024 is set

1> select name, status from sysdatabases where name = "sybsecurity"
2> go
 name                                                         status
 ------------------------------------------------------------ ------
 sybsecurity                                                    1036

  • booting the server the following message appears in the error log and server does not come up

server  Database 'sybsecurity' is now online.
server  Error: 7632, Severity: 16, State: 1
server  Cannot enable auditing because the 'sybsecurity' database is read-only.
kernel  ueshutdown: exiting


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.0 SP04

Product

SAP Adaptive Server Enterprise 16.0.4

Keywords

sybsecurity, server, down, read only, read-only, auditing , 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.