Error: Data could not be saved. Cannot insert duplicate key row in object 'dbo.PROSPECTRESEARCHREQUEST' with unique index 'UIX_PROSPECTRESEARCHREQUEST_REQUESTNO'. The duplicate key value is (4) - when adding a new Prospect Research Request

When a user adds a new Prospect Research Request they may receive the error:

Data could not be saved.   Cannot insert duplicate key row in object 'dbo.PROSPECTRESEARCHREQUEST' with unique index 'UIX_PROSPECTRESEARCHREQUEST_REQUESTNO'. The duplicate key value is (4).

We are currently evaluating this issue and will update this article when we have more information.

Environment

 2.94.1524, patch 47

Was this article helpful?