3648905 - Database locking error when executing report RPUDELPN for mass deletion of personnel numbers in sap netweaver

Symptom

When executing report RPUDELPN to delete a large number of personnel numbers (for example, approximately 60,000 PERNRs), the report terminates with a short dump due to a database locking error.

For eg.- The following error message is displayed:
SQL0912N The maximum number of lock requests has been reached for the database. Reason code = '1'. SQLSTATE=57011.

This issue may occur even after increasing the database lock limit, particularly when de-clustered Data Synchronization is switched on and a large volume of de-clustered data exists in the system.

Environment

Payroll Control Center
SAP enhancement package for SAP ERP, version for SAP HANA
Human Capital Management (HCM)
SAP enhancement package for SAP ERP

Product

SAP ERP Central Component all versions ; SAP R/3 all versions ; SAP SuccessFactors Employee Central Payroll all versions ; SAP SuccessFactors HCM Core all versions ; SAP enhancement package for SAP ERP all versions ; SAP enhancement package for SAP ERP, version for SAP HANA all versions

Keywords

rpudelpn, rpcdct_del_dct_data, database locking error, sql0912n, personnel numbers, mass deletion, declustered data, sap netweaver, payroll control center, locking issue, db lock limit, runtime error, sqlstate 57011. , KBA , PY-XX-PYP , Payroll Control Center , 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.