Security Group cannot be deleted

Resolving The Problem

Steps to resolve:

Error Case 1 : When trying to delete a Security Group, error "BMXAA3894E - Cannot delete group TESTGRP1 because users exist for that group" might be encountered.

You need to delete users belonging to that group.

1) Go to the Security Groups application - open that Group - go to the Users tab.

Delete users belonging to that group like in the screenshot below.

2) Or you can use the script below:

DELETE FROM GROUPUSER WHERE GROUPNAME = 'TESTGRP1';

COMMIT;

Error Case 2 : When trying to delete a security group, error "BMXAA5602W - The security group you are deleting is used in the UI configuration of the following applications: CUSTWOT1. Are you sure you want to delete this record? " might be encountered.

This error is occurring because there is a conditional UI setting for that group.

You need to delete that group from the conditional UI setting referencing that group.

1) Go to the Application Designer application - Open the CUSTWOT1 application mentioned in the error message.

Pinpoint the conditional UI setting referencing that group like below . Then delete that Security Group.

2) Or you can use the script below.

DELETE FROM CTRLGROUP WHERE GROUPNAME = 'TESTGRP1';

COMMIT;

You will then be able to delete your group from the Security Groups application.