SAP Knowledge Base Article - Preview

2792054 - Execution of DBCC CHECKSTORAGE for sybsecurity database may fail due to error 10331 - SAP ASE for BS


When DBCC CHECKSTORAGE is run on Business Suite environment, it may fail due to error 10331. This phenomenon happens when the below conditions fit:

  • "enable granular permissions" configuration parameter is set to 1
  • sapsa runs DBCC CHECKSTORAGE for sybsecurity database

isql -Usapsa -P<password> -S<SID> -X

1> dbcc checkstorage(sybsecurity)
2> go
Checking sybsecurity: Logical pagesize is 16384 bytes
Msg 10331, Level 14, State 2:
Server 'SID', Line 1:
Permission denied, database sybsecurity, owner dbo. You need the following permission(s) to run this command: DBCC CHECKSTORAGE.



SAP Adaptive Server Enterprise (ASE) 16.0 SP03 and later for Business Suite


SAP Adaptive Server Enterprise 16.0 ; SAP Customer Relationship Management 7.0 ; SAP ERP 6.0 ; SAP NetWeaver all versions ; SAP Solution Manager 7.1 ; SAP Solution Manager 7.2 ; SAP Supplier Relationship Management 7.0 ; SAP Supply Chain Management 7.0


DBCC CHECKSTORAGE, enable granular permissions, 10331, sapsa , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.