SAP Knowledge Base Article - Preview

2442169 - Set "allocationlimit" in tenant fails with error 'DATABASE' layer does not need 'layername' in tenant database'


You try to set global allocation limit for a tenant database with a sql statement like:

ALTER SYSTEM ALTER CONFIGURATION ('global.ini', 'DATABASE', 'STE') SET ('memorymanager', 'allocationlimit') = '250000' WITH RECONFIGURE;

The sql statement can't be executed and terminates with an error:

'DATABASE' layer does not need 'layername' in tenant database'



  • SAP HANA Multitenant Database


SAP HANA 1.0, platform edition


SYSTEM database, tenant, global allocation limit, allocationlimit , KBA , HAN-DB , SAP HANA Database , 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.