Getting Sybase related errors while doing WAAE upgrade

Article Id: 145148
Status: Published
Updated On: 07-09-2020 23:53
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