The transaction exceeds the maximum number of row locks allowed by the database. User action is required. (4296294)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

The transaction exceeds the maximum number of row locks allowed by the database. User action is required.
Description

The transaction requires more row locks than the number permitted in a transaction by the current setting of the MaxRowHashBlocksPercent parameter in the database.
Cause

The transaction requires more row locks than the number permitted in a transaction by the current setting of the MaxRowHashBlocksPercent parameter in the database.
Resolution

Do one of the following:
(A) Increase the value of MaxRowHashBlocksPercent to allow more locks per transaction or :
(B) run the following SharePlex command to configure Post to break large transactions into smaller ones to work around the current limit:
sp_ctrl> target r.{target_DB} [queue {post_queue}] set resources commit_frequency={number of operations per transaction}.
See the SharePlex Reference Guide for full syntax details.
Additional Information

SP-OPX01013

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title