In ATF Process unable to create a new user without admin role in a test step after Zurich Upgrade

[pavi12]

While executing an ATF test case that creates a user with a specific role (not an admin role), the process fails during user creation with the following error:

"FAILED TRYING TO EXECUTE ON CONNECTION glide.2 (connpid=37009): INSERT INTO sys_user_grmember (`sys_id`,`sys_updated_by`,`sys_created_on`,`sys_domain`,`sys_updated_on`,`user`,`sys_created_by`,`group`) VALUES('494822993b50b21036672a4a85e45ade','system','2025-09-29 12:44:24','a2c564ab1bacd91018bfec60f54bcb21','2025-09-29 12:44:24','854822993b50b21036672a4a85e45abe','system','5ee74940b70022108d4406dd1e11a918') /* expoedev004, gs:glide.scheduler.worker.5, tx:9048a6593b50b21036672a4a85e45add, hash:-298895666 */ 
Unique Key violation detected by database ((conn=37009) Duplicate entry '5ee74940b70022108d4406dd1e11a918-854822993b50b21036672a4a85e4...' for key 'group_2')"

This error is blocking execution and impacts all related ATF test cases.
The issue occurs due to the group: Conditional Script Writer group 

Could anyone please help on this?

[Chidanand_VK]

Hi @pavi12 ,

This is due to the User record is already existing in the system, try to give other naming at 'Create a User' step for which there is NO user record exist in the system.

If my answer helped, please mark it as helpful or accept as the solution.

Regards,

Chidanand

[xu_lin]

I have the same problem after upgrade. If the first step is to create user, then ATF creates new user successfully. But if not the first step, create new user will fail with error as can't add to the group. Must impersonate admin user before this step to fix it. This is more like bug of ATF from new version.