Data could not be saved. Violation of PRIMARY KEY constraint 'PK_APPUSER'

When attempting to add multiple Custom-Application Users we receive the following error message
 
Data could not be saved. Violation of PRIMARY KEY constraint 'PK_APPUSER'. Cannot insert duplicate key in object 'dbo.APPUSER'. The duplicate key value is (''). 
BBERR_ORIGINAL_ERROR:2627
BBERR_ORIGINAL_PROCEDURE:USP_APPUSER_ADDCUSTOMAPPUSER
BBERR_ORIGINAL_LINE_NUMBER:44

Work around: Add the users one at a time.
Download and install the latest patch which contains all fixes from previous patches. If you are running an older version, download and install the latest version and then the patch. 

Environment

 Blackbaud CRM
 3.0
 4.0
 4.0.131.0

Was this article helpful?