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)

Products

• CA Workload Automation AE - Business Agents (AutoSys)
• CA Workload Automation AE - Scheduler (AutoSys)
• Workload Automation Agent

Issue/Introduction

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