RSS

Cannot insert multiple records in Security user role (SecurityUserRole). The record already exists.

14 Dec

I have made a copy of production environment and restored on development environment and deleted all the users from userinfo table.

I got an request to provide  access to an user but whenever i tried to import new user i started getting error.

Cannot insert multiple records in Security user role (SecurityUserRole).

This error itself giving you solution of the problem,we have to delete the record from this table with USER_= “new user”.

Route cause: The route cause of this error is inconsistency between userinfo table and securityUserRole.

 

Solution: Open SQL Server Management Studio, SQL DB, Select the MicrosoftDynamicsAX database and run the below query

delete from dbo.SECURITYUSERROLE where USER_ = ‘deepakKal’

To check user details run:

select * from dbo.SECURITYUSERROLE.

Now if you will try again to add same user then you will see its added without any error.

Happy Daxing 🙂

Advertisements
 

Tags: , , , ,

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: