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
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.
This blog is my place to share my thoughts, helpful solutions and just random nerdy stuff.
Latest posts by Shane Bartholomeusz (see all)
Leave a Reply