Event Server: <> Failed Query: <alter session set current_schema = aedbadmin>

Products

• CA Workload Automation AE

Issue/Introduction

We need to use a different user than aedbadmin. We have installed using a different user <atsys_dbo> however when we startup, we get the following error:

Event Server: <AOATSYS1_SSL.WORLD>  Failed Query: <alter session set current_schema = aedbadmin>

Where is it pulling aedbadmin from?

Environment

Release : 12.0

Component : CA Workload Automation AE (AutoSys)

Resolution

The 11.x versions did not allow for a different schema username.

It was hardcoded as aedbadmin in the 11.x version.

As of 12 you can choose a different schema owner.

 

https://techdocs.broadcom.com/us/en/ca-enterprise-software/intelligent-automation/workload-automation-ae-and-workload-control-center/11-3-6-SP8/monitoring-and-reporting/ae-monitoring-and-reporting/maintain-highly-available-environments.html
vs
https://techdocs.broadcom.com/us/en/ca-enterprise-software/intelligent-automation/autosys-workload-automation/12-0-01/monitoring-and-reporting/ae-monitoring-and-reporting/maintain-highly-available-environments.html