The EarlyWatch Alert (EWA) Service Report shows that 'PAGE locking' is disallowed for tables E071 and E071K.
The warning means 'DisAllowPageLocks' is set to TRUE in the system. Tables E071 and E071K should not have disallowed 'PAGE locking', the correct setting is FALSE.
MSSPROCS script sap_z_set_parameters shows which tables require disallow 'PAGE locks, see note 1648817.
In some cases, during the SAP system upgrade process, 'DisAllowPageLocks' can be temporarily set to TRUE as indicated in note 2934875.
SAP NetWeaver systems based on an ABAP or Java stack and Microsoft SQL Server
DisAllowPageLocks, Page locking, disallowed, EarlyWatch Alert, EWA, SQL Server, script, sap_z_set_parameters, deadlock , KBA , BC-DB-MSS , SQL Server in SAP NetWeaver Products , SV-SMG-SER-EWA , EarlyWatch Alert , Problem
About this pageThis 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.