When I log in to my Autosys, everything works fine, except when I try to see the job properties, I get errors. The services are up,
Release : 12.0
In this specific case when we looked at the as_server.DES file we saw the following errors:
[03/21/2023 11:45:35] CAUAJM_E_18407 Failed to connect to Oracle server: cawa
[03/21/2023 11:45:35] CAUAJM_E_18400 An error has occurred while interfacing with ORACLE.
[03/21/2023 11:45:35] CAUAJM_E_18401 Function <Olog> invoked from <openProc> failed <163>
[03/21/2023 11:45:35] CAUAJM_E_18402 ORA-28001: the password has expired
This is the reason the product was having problems.
AutoSys cannot connect to the oracle db because the autosys db password expired.
When you see "ORA-" those errors are coming directly from Oracle.
When AE starts it connects to the db using the information it has in the $AUTOUSER/config.$AUTOSERV file.
DBAccess=
EventServer_1=
You should stop AE (the scheduler and application servers) and use the autosys_secure utility to update the autosys database user's password.
You can engage the DBA to unlock the user and/or change the autosys db password within the database.
Then follow the steps :
1)Execute autosys_secure command.
2)Select option [6] Get encrypted password.
3)Enter a new password and copy the encrypted password.
4)In your config file located at $AUTOUSER/config.$AUTOSERV, update the following parameter:
DBAccess=autosys/<encrypted_password>
Replace <encrypted_password> with the new encrypted password from step 3.
5)Save the changes.
6)ReStart AutoSys (Scheduler, Application server, WebService)
In case of High Availability setup, you must do the same procedure on the other schedule/as_server hosts.