Error while upgrading a legacy 11.3 environment to 11.3.6 SP6 with aedbadmin user No login with the specified name exists. (return status = 1)

Document ID : KB000008707
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

Error while upgrading CA Workload Automation AE (WAAE) from a legacy 11.3 environment to 11.3.6 SP6 with 'aedbadmin' as the Sybase ASE database user.

1> sp_displaylogin aedbadmin
2> go
No login with the specified name exists.
(return status = 1)

Environment:
CA Workload Automation AE R11.3.6 SP6Database: SAP (Sybase) Adaptive Server Enterprise all supported versions.
Cause:

For SAP (Sybase) Adaptive Server Enterprise database, WAAE does not create the "aedbadmin" database user for operation. The "aedbadmin" user is only applicable for Oracle database.

Resolution:

For SAP (Sybase) ASE database, use the System Administrator ("sa" ) account while upgrading from legacy 11.3 environment to 11.3.6 SP6.

The installer verifies the database connection for both the first and second databases using  the "sa" user and password for Sybase.

Additional Information:

 

Upgrade CA Workload Automation AE r11.3 or a Later Release to the Current Release