Cannot Enable User – Dynamics CRM 4.0

Problem

I recently encountered a strange issue in our Microsoft Dynamics CRM 4.0 environment. We could not ENABLE a user that had previously been disabled, instead we encountered the following error.

Analysis

Monitoring the CRM IIS web server process (W3WP.exe) with the Sysinternals ProcDump analysis tool showed the following unique constraint database errors occurring.

Solution

Remove the duplicate rows in the dbo.SystemUserPrincipals database table.

I used the following SQL script.

 --
 -- SELECT SystemUserId
 -- FROM systemuserbase
 -- WHERE Fullname like '%Tompkins%'
 --
 -- Returns A0BAE3A7-6B76-DE11-A727-005056B44698
 --
 

USE HRPAYS_MSCRM
GO

BEGIN TRANSACTION

BEGIN TRY

DELETE FROM SystemUserPrincipals
WHERE SystemUserId IN (SELECT systemuserid
FROM systemuserbase
WHERE isdisabled = 1
AND SystemUserId = 'A0BAE3A7-6B76-DE11-A727-005056B44698')

PRINT N'Committing transaction';

COMMIT TRANSACTION;
END TRY

BEGIN CATCH
DECLARE @ERR_MESSAGE nvarchar(1000);
SET @ERR_MESSAGE = (SELECT CAST(ERROR_NUMBER() as NVARCHAR) + N' ... ' +
CAST(ERROR_MESSAGE() as NVARCHAR) + N' ... ' +
CAST(ERROR_LINE() as NVARCHAR));

PRINT @ERR_MESSAGE;
ROLLBACK TRANSACTION;
PRINT N'An error occurred ...';
END CATCH

GO

• About
• Latest Posts

Shane Bartholomeusz

G’day, I’m a technical solutions consultant based in Perth, Australia that specialises in the Microsoft technology stack, including .NET, Dynamics 365, Azure and general web development etc.

This blog is my place to share my thoughts, helpful solutions and just random nerdy stuff.

Latest posts by Shane Bartholomeusz (see all)

• Solved: Cmder – ‘ls’ is not recognized as an internal or external command, operable program or batch file. - 16th April 2024
• Solved: ‘Unable to find package specflow.plus.license’ error - 14th February 2024
• How to: Use GitHub Actions with OIDC to Authenticate with Azure - 16th November 2023