SAP Knowledge Base Article - Preview

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

Symptom

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.
1>


Read more...

Environment

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

Product

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

Keywords

DBCC CHECKSTORAGE, enable granular permissions, 10331, sapsa , KBA , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , 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.