Unable to add user

Finance and Operations/AX Technical Forum
1

Hi All,

when i add trainee users in axapta through (Admin–>users form) i get this error.
Cannot create a record in Group/user relationships (UserGroupList). Group: Admin.

The record already exists.

but i saw in database userinfo table their is no record.

other than trainees they are added.

can anyone give suggestions to solve this problem.

2

  1. Make sure, such a user does not exists

  2. Try to create the user: Administration / Commont forms/ Users / Import and follow the wizard

  3. I would try to synchronize followong tables: sysUserInfo, sysUserProfile

3

Hi Tomas,

yes the user doen’t exit in user form as well as in the db table.I create the user in admin permissions.

Their is no record in the 2 tables

4

run

update SystemSequences set nextval = (select max(Recid+1) from USERGROUPLIST) where tabid = ( select TableId FROM SQLDICTIONARY SD WHERE SD.FIELDID = 0 AND SD.ARRAY = 0 AND Name = ‘USERGROUPLIST’)

update SystemSequences set nextval = (select max(Recid+1) from USERINFO) where tabid = ( select TableId FROM SQLDICTIONARY SD WHERE SD.FIELDID = 0 AND SD.ARRAY = 0 AND Name = ‘USERINFO’)