Symptom
- While upgrading SAP ASE database from version 15.7 to 16.0 SP03 PL10, the SAP Host Agent returns this just before completion of the database server upgrade:
Error: sapdbctrl: Failed to enable granular permissions. - Trying to execute the below commands to update granular permissions as per Note, 2800483 - "SYB: Upgrade / Update SAP ASE with SAP Host Agent 7.21 PL43 and later", but still encounter the same error:
/saphostctrl -function LiveDatabaseUpdate -dbname <SID> -dbtype syb -updatemethod Execute -updateoption TASK=CONFIG_GP
/saphostctrl -user sapadm - -function LiveDatabaseUpdate -dbname <SID> -dbtype syb -updatemethod Execute -updateoption TASK=CONFIG_GP - Additionally, this message is reported in the dev_sapdbctrl log file:
ERROR AT sybOpenClient.cpp:SybOcsConnection::executeQuery(const string &, int, bool, CS_INT):2228 TIME: 20XX Jun 05 13:37:35 DESCRIPTION:
Server message: Number 5861, Severity 16, State 2, Line 1335, Server <SID>,
Procedure sp_configure --- Message string:
The current 'max memory' value '<current_value>', is not sufficient to change the parameter 'permission cache entries' to '1024'. 'max memory' should be greater than 'total logical memory' '<expected_value>' required for the configuration.
LAST OS-ERROR: (0) : Error 0
ERROR AT sybServer.cpp:SybServer::luAppendResult(SAP_DB_KeyValuePairArray **, const string &, const string &, bool):42297 TIME: 20XX Jun 05 13:37:35 DESCRIPTION:
Failed to enable granular permissions LAST OS-ERROR: (0) : Error 0
*** ERROR => 'Database live update' failed: Failed to enable granular permissions. [sapdbctrl.cp 5044]
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) for Business Suite 16.0
- SAP NetWeaver (All versions)
Product
SAP Adaptive Server Enterprise 16.0 ; SAP NetWeaver all versions
Keywords
KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.
SAP Knowledge Base Article - Preview