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: 2022 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: 2022 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 , 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.