SAP Knowledge Base Article - Preview

3230835 - Tables E071 and E071K 'Page locking disallowed' warning in EarlyWatch Alert report

Symptom

 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.


Read more...

Environment

SAP NetWeaver systems based on an ABAP or Java stack and Microsoft SQL Server

Keywords

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 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.