New privileges not granted during upgrade to version 24.4 to user UC/UC

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

I have performed and upgrade of an old AE System from version 21 to 24.4.x.

Before performing dbload I have exported 2 admin users as ADMIN_USERS variable so that we will have proper access granted for new privileges.

However, the system is very old and had been after plenty of changes noone remember today.
This resulted in missing privileges for both Admin users provided AND the UC/UC user.

Cause

From dbload logs we can see that the procedure is to grant proper access to UC/UC and propagate it to provided Admins.

Sadly as the UC/UC user has different OH_Idnr then 5, privilege was not granted, this can be checked with the query:

select oh_idnr from oh where oh_name = 'UC/UC';

If the oh_idnr resulting is not 5, the user UC/UC has to be fixed so that it has oh_idnr=5.

Example of an affected system:

select oh_client,oh_otype,oh_name,oh_idnr from oh where oh_name = 'UC/UC';

oh_client    oh_otype    oh_name    oh_idnr

0                USER         UC/UC        109310

 

 

 

Resolution

Please open a case with Technical Support referencing this article so that the procedure to restore the user UC/UC and renaming of the current UC/UC user is provided.