SAP Knowledge Base Article - Preview

3210675 - Error: sapdbctrl: Failed to enable granular permissions on SAP Production HCM Portal

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.