Survey Completed while Progress is 0% and ResourceAssignment is in Pending state

In certain situations, a rare condition may occur when one user submits a significant number of survey questions all at once, while another user simultaneously submits a large batch of questions in a subsequent step. This scenario often results in the user in the second step unintentionally closing work items for assignees who were anticipating new questions from the user in the first step.

To address this issue, the solution utilizes a rowlock mechanism on tblactivity to ensure that only one user can submit questions for a specific survey instance at any given time. This guarantees exclusive access and effectively prevents race conditions, thereby maintaining a systematic processing of survey submissions.

INC-257734