Getting a login failed error message during AutoSys (CA Workload Automation AE) from v11.3.6.SP8.1643 to v12.0.01 upgrade with Sybase database
search cancel

Getting a login failed error message during AutoSys (CA Workload Automation AE) from v11.3.6.SP8.1643 to v12.0.01 upgrade with Sybase database

book

Article ID: 255000

calendar_today

Updated On:

Products

CA Workload Automation AE

Issue/Introduction

Started the upgrade and unable to connect to database during installation. Getting a login failed error message.

Can successfully isql into the Sybase database using the same database user. Verified the permissions on the database files and directories. 

Verified that all of the database environmental variables were set correctly

Upgrading following AutoSys (CA Workload Automation AE) from v11.3.6.SP8.1643 to v12.0.01. The EEM will remain the same EEM 12.6.0.5.

 

Environment

Release : 12.0.1

Database type: Sybase

Operating System: AIX

 

Resolution

The database user had special characters in it. It had the @ in it. Ran autosys_secure and chose option 3 to change the database password without any special characters. Then the upgrade got past the login error message.