@floatingpurrif you're on UCCX, I do not have the fix. For CCE, the fix is below.
1. SSH Into the CUIC Publisher
2. Run the below SQL Query
run sql select * from cuic_data:cuicuser cuic, (select t.ADLoginName, t.personid from cuic_data:cuicuser as c, cuic_data:cuic_temp_users as t where c.personid = t.personid and c.name!= t.ADLoginName ) as temp where cuic.name = temp.ADLoginName and (cuic.personid !=temp.personid or cuic.personid is NULL)
3. If you get any output for the SQL Query in step 2 then those problematic users in CUIC will need to be deleted (DO NOT delete them from CUIC with SQL statements via CLI)
a. Log into CUIC GUI and search for the user and delete them.
b. If the user has associated things owned by them, you'll see the following Error. If that's the case, follow the List Entities Owned by User Process and Failed to Delete User Process - Change Owner.
ERROR: Failed to delete the user because it still owns other objects (such as Dashboard, Report, Report Definition, or Value List)
List Entities Owned by User Process
1. SSH Into the CUIC Publisher
2. Run query to find out the CUIC ID of the user who needs to be deleted.
run sql select id, name from cuic_data:cuicuser where name in ('domain_name\OldOwner54321')
id name
================================ =====================
A272DD241000015700000ABC0AB5E42E domain_name\OldOwner543213. Now that you have the CUIC ID, you can run all of the queries needed to validate what entities that owner has.
List all Scheduled Reports owned by a certain user.
run sql select Id, ScheduledreportName from cuic_data:cuicScheduledReports where UserId = 'A272DD241000015700000ABC0AB5E42E'
List all Category's owned by a certain user.
run sql select Id, name from cuic_data:cuicCategory where Owner = 'A272DD241000015700000ABC0AB5E42E'
List all Dashboards owned by a certain user.
run sql select Id, name from cuic_data:cuicDashboard where Owner = 'A272DD241000015700000ABC0AB5E42E'
List all Reports owned by a certain user.
run sql select Id, name from cuic_data:cuicReport where Owner = 'A272DD241000015700000ABC0AB5E42E'
List all Report Definitions owned by a certain user.
run sql select Id, name from cuic_data:cuicReportDefinition where Owner = 'A272DD241000015700000ABC0AB5E42E'
List all Data Sources owned by a certain user.
run sql select Id, name from cuic_data:cuicDatasource where Owner = 'A272DD241000015700000ABC0AB5E42E'
List all Value Lists owned by a certain user.
run sql select Id, name from cuic_data:cuicValueList where Owner = 'A272DD241000015700000ABC0AB5E42E'
List all Collections owned by a certain user.
run sql select Id, name from cuic_data:cuicCollection where Owner = 'A272DD241000015700000ABC0AB5E42E' and ValueListId is not null
Failed to Delete User Process - Change Owner
1. Ask the Customer who the new Owner should be for those Entities found.
2. SSH into the publisher
3. Perform a search to find out what that new owners CUIC ID is.
*** At the end of the below query, enter the new Owners users User Name as it appears in CUIC.
run sql select id, name from cuic_data:cuicuser where name in ('domain_name\NewOwner12345')
id name
================================ =====================
37EA476B1000016F00020AD50AB5E455 domain_name\NewOwner123454. Fill out the following SQL Update statements below. Use the previous List Entities Owned by User Process and only run as needed.
a. Make sure the set owner = the CUIC ID from the above statement.
b. Make sure the end name in is equal to the user you are trying to delete.
c. These updates will look for everything that is assigned to the user you are trying to delete and then associate those to the new ID. Its weird because you are using a combination of CUIC ID and the actual UserID.
run sql update cuic_data:cuicreport set owner = '37EA476B1000016F00020AD50AB5E455' where owner in ( select id from cuic_data:cuicuser where name in ('domain_name\OldOwner54321'))
run sql update cuic_data:cuiccategory set owner = '37EA476B1000016F00020AD50AB5E455' where owner in ( select id from cuic_data:cuicuser where name in ('domain_name\OldOwner54321'))
run sql update cuic_data:cuicdashboard set owner = '37EA476B1000016F00020AD50AB5E455' where owner in ( select id from cuic_data:cuicuser where name in ('domain_name\OldOwner54321'))
run sql update cuic_data:cuicscheduledreports set userid = '37EA476B1000016F00020AD50AB5E455' where userid in ( select id from cuic_data:cuicuser where name in ('domain_name\OldOwner54321'))5. Go into the CUIC App Admin page and perform a UCCE User Integration Sync
a. Select Cluster Configuration from the left then select UCCE User Integration
b. Select "Synchronize Now"
6. Go back to where you are trying to delete the user. Perform a search and see if they are still there. If they are, then select them and click delete.
