How to migrate job owners from WA AE 11.3 SP1 to 11.3.6 SP5?

Document ID:  TEC1250074
Last Modified Date:  08/02/2017
{{active ? 'Hide' : 'Show'}} Technical Document Details

Products

  • CA Workload Automation AE

Releases

  • CA Workload Automation AE:Release:11.3
  • CA Workload Automation AE:Release:11.3.6

Components

  • AUTOSYS JAVA GUI:ATSJAV
Introduction:

We have more than 170 users in autosys_secure user@host in an old WA AE 11.3 SP1 instance used for running jobs. 

We have installed WA AE 11.3.6 SP5 on a new machine and we need to get the users and their passwords from the old instance. 

So we copied over the ujo_cred table from the 11.3 SP1 instance to the 11.3.6 SP5 instance. But when we go to autosys_secure, Manage users, Manage users with password, Show all users, we can find only the users created originally in the 11.3.6 SP5 instance.

Background:

We cannot recreate users directly in the new WA AE 11.3.6 SP5 instance because for security reasons we do not have access to the users passwords.

We cannot interrupt our production the time necessary for creation of users and their passwords.

Environment:
Workload Automation AE 11.3 SP1 (migration to) Workload Automation AE 11.3.6 SP5
Instructions:

The 11.3 SP1 and 11.3.6 passwords encryption are compatible.

You cannot see the users imported from 11.3 SP1 because of a difference in the tables content.

 

The solution will be to run the following query to fix the difference between 11.3 SP1 and 11.3.6 release:

 

update aedbadmin.ujo_cred set cred_type = 4 ;

commit;

 

After the above queries, you will be able to find back all your users and passwords.

Problem resolved by applying the solution.

 

 

Please help us improve!

Will this information enable you to resolve your issue?

Please tell us what we can do better.

{{feedbackText.length ? feedbackText.length : '0'}}/255

{{status}}

Not what you were looking for?

Search Again >

Product Information

Support by Product >

Communities

Join a Community >