UIM 20.3 Cabi 4.30 deploy fails

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

cabi 4.30 fails and probe status goes red. 

Environment

Release : 20.3

Component : UIM - CABI

Cause

The uim database CM_AUTHENTICATION table had more than one row.

Resolution

Run this query: 
SELECT * FROM CM_AUTHENTICATION

Backup the table, and then from the above output determin the latest row. 

Delete all the older rows. 
Can use: 
delete from CM_AUTHENTICATION where auth_id = <ID of older row from above query>

Then restart the cabi robot for the deployment to continue. 

Additional Information

cabi log has:

Dec 15 20:17:31:413 [main, cabi] I logged in with the default superuser password. Re-setting the CABI Rest user now. 
Dec 15 20:17:31:414 [main, cabi] Resetting rest user 'CABI_REST_USER' 
Dec 15 20:17:34:900 [main, cabi] Deleting rest user CABI_REST_USER 
Dec 15 20:17:37:298 [main, cabi] deleteJasperUser(): userDeleteUrl: http://<IP address removed>:80/cabijs/rest_v2/users/CABI_REST_USER 
Dec 15 20:17:41:526 [main, cabi] Switched to secure CABI login. "superuser" can now be disabled. 
Dec 15 20:17:41:526 [main, cabi] successfully saved the new CABI rest user to CABI 
Dec 15 20:17:41:526 [main, cabi] Resetting the password in the UIM database for the CABI rest user. 
Dec 15 20:17:41:548 [main, cabi] Unable to save rest user password to UIM database. Reverting the password in jasperserver to the last known value. 
Dec 15 20:17:41:548 [main, cabi] Resetting rest user 'CABI_REST_USER' 
Dec 15 20:17:44:035 [main, cabi] Deleting rest user CABI_REST_USER 
Dec 15 20:17:46:508 [main, cabi] deleteJasperUser(): userDeleteUrl: http://<IP address removed>:80/cabijs/rest_v2/users/CABI_REST_USER 
Dec 15 20:17:50:454 [main, cabi] JasperUserUtility:login(): URL attempted :http://<IP address removed>:80/cabijs/login.html 
Dec 15 20:17:50:454 [main, cabi] JasperUserUtility:login(): Response code :403 
Dec 15 20:17:50:454 [main, cabi] JasperUserUtility:login(): Got an unauthorized response, I should fall back to superuser login 
Dec 15 20:17:51:742 [0176] Controller: Probe 'cabi' (command = <startup java>) returns no-restart code (42) 

In cabi server cabi_rest_user is deleted but not recreated.