The following steps are being provided to allow a cleanup of the UMP Liferay tables and reinstall of UMP.
The following steps assume that there has been no customization of users as, following the drop and recreate, the Liferay tables will contain default values.
1.Stop UIM and UMP via the Nimsoft Robot Watcher service on those servers.
2.Take snapshots of the UIM server, UMP server and the UIM DB server.
3.Take a separate backup of the "portal-ext.properties" file located on the UMP server under the Nimsoft directory \probes\service\wasp\webapps\ROOT\WEB-INF\classes
4.Take a further backup of the wasp folder on the UMP server under the Nimsoft directory \probes\service\wasp
5. Run the drop query mentioned in the link -
https://ca-broadcomcsm.wolkenservicedesk.com/wolken/esd/knowledgebase_search?articleId=382156.Verify that all the tables are deleted from the DB ( A few tables from the drop query may not exist, please ignore them)
7. From the Primary Hub server run the UMP upgrade process for 9.20
8. Once complete allow the UMP wasp to obtain a port and pid then deactivate.
9. Replace the "portal-ext.properties" from the backup taken in 3 then activate wasp and check/confirm that everything else is working fine and if the problem with the users has also been resolved.
Any problems encountered during the process will require a fallback to the snapshots taken in 2.
It is strongly advised to run through the steps in a Test environment first before attempting in a Production environment.
Snaphots/Backups of the servers must be taken as noted.