Error: Cannot insert duplicate key row in object dbo.CLIENTUSERSTIPSSEEN - when logging in to the NetCommunity site

When attempting to login to the administrative functions in Blackbaud NetCommunity, the user receives the following error:

Server Error in '/' Application.
System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> Blackbaud.AppFx.Server.ServiceException: Data could not be saved. 
Cannot insert duplicate key row in object 'dbo.CLIENTUSERSTIPSSEEN' with unique index 'UIX_CLIENTUSERSTIPSSEEN_TIPGUID_CLIENTUSERID'. The duplicate key value is (df29aaf9-f827-4557-954b-0a718eba5473, 18). ---> System.Data.SqlClient.SqlException: Cannot insert duplicate key row in object 'dbo.CLIENTUSERSTIPSSEEN' with unique index 'UIX_CLIENTUSERSTIPSSEEN_TIPGUID_CLIENTUSERID'. The duplicate key value is (df29aaf9-f827-4557-954b-0a718eba5473, 18).
BBERR_ORIGINAL_ERROR:2601
BBERR_ORIGINAL_PROCEDURE:USP_DATAFORMTEMPLATE_ADD_CLIENTUSERTIPSEEN
BBERR_ORIGINAL_LINE_NUMBER:24
  at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
  at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
  at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
  at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
  at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
  at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
  at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
  at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
  at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
  at Blackbaud.AppFx.Server.DataFormSaveProcessor.ExecuteAddNewSP()
  --- End of inner exception stack trace ---
  at Blackbaud.AppFx.Server.DBErrorHandler.HandleDBError(SqlException ex, ExpectedDBExceptions definedExceptions)
  at Blackbaud.AppFx.Server.DBErrorHandler.HandleDBError(SqlException ex)
  at Blackbaud.AppFx.Server.DataFormSaveProcessor.HandleDBError(SqlException ex)
  at Blackbaud.AppFx.Server.DataFormSaveProcessor.ExecuteAddNewSP()
  at Blackbaud.AppFx.Server.DataFormSaveProcessor.ProcessRequest()
  at Blackbaud.AppFx.Server.RequestProcessor`2.GetReply()
  at Blackbaud.AppFx.Server.AppService.DispatchSyncRequest(RequestProcessorBase processor)
  at Blackbaud.AppFx.Server.AppService.DispatchRequest(RequestProcessorBase processor)
  at Blackbaud.AppFx.Server.AppFxWebService.DataFormSave(DataFormSaveRequest req)
  --- End of inner exception stack trace ---
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.


Or the following error may occur that is similar: 

Cannot insert duplicate key row in object 'dbo.ClientUsersDeletedRERecordMap' with unique index 'IX_ClientUsersDeletedRERecordMap'. The duplicate key value is (6, 0).
The statement has been terminated.
 
This error occurs when more than 1 instance of that user logging in happens at the same instance.  This should be a rare occurrence and is caused by the table that compares the relationship between client users and the tips they have seen once attempts to update a primary key in the table at the same time.

To fix this error, delete and undelete the Blackbaud NetCommunity User record from the User Gallery.

If this occurs with the Supervisor user:
1. Login as a user with Supervisor rights. 
2. Edit the supervisor user account.
3. Break any links to The Education Edge or The Raiser's Edge records.
4. Save Supervisor user record
5. Logout and login with Supervisor account
 

Environment

 6.45.2034

Was this article helpful?