Getting Sybase related errors while doing WAAE upgrade

Products

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

Issue/Introduction

Getting below errors while we are running DVD01136SP8E.iso to upgrade CA WAAE from 11.3.6 SP* to 11.3.6 SP8.

 Database Tests     

*****************************************************************************************************************                              │

Warnings or errors occurred during the database connection test. Make sure that the database is active and that the connection information is specified correctly. Click Back to specify different connection information. Click Cancel

to cancel the setup program.

│ The Sybase environment cannot be found. Make sure that the Sybase home directory is specified correctly. 

****************************************************************************************************************

 

Cause

Sybase database connection fail to connect unless all the Sybase related variables not declared in the server that is upgrading CA WAAE.

Environment

Release : 11.3.6*

Component : CA Workload Automation AE (AutoSys)

O.S : Unix/Linux

Resolution

- Copy Sybase folder from database server to current host where scheduler reside.

- Set below variables

SYBASE
SYBROOT
SYBASE_OCS
SYBASE_ASE
SYBASE_WS

- Export in to bash_profile 

- While running upgrade :

• Provide sa user (admin user recommended)
• Sybase path need to be set to $SYBASE_OCS

- Run the upgrade

Additional Information

Install CA Workload Automation AE with Sybase