ARCHIVE JOB RUNS fails with an error

book

Article ID: 195926

calendar_today

Updated On:

Products

CA Workload Automation AE - Scheduler (AutoSys) CA Workload Automation AE

Issue/Introduction

The command archive_events fails with the following error while archiving the job_runs.

$ archive_events -A -j 3 -B 10000

CAUAJM_I_60014 Archiving Job Runs...
CAUAJM_E_18416 Event Server: <AUTODP1A.bankofamerica.com>  Failed Query: <BEGIN :RetVal := UJO_CLEANUP_JOBRUNS (:I_endtime, :I_batch_size, :I_delete_orphans); END; <<1595188915,10000,1>>>
CAUAJM_E_18402 ORA-06550: line 1, column 18:
PLS-00306: wrong number or types of arguments in call to 'UJO_CLEANUP_JOBRUNS'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
CAUAJM_I_18403 Processing OCI function ODEFIN(34)
CAUAJM_E_18400 An error has occurred while interfacing with ORACLE.
CAUAJM_E_18401 Function <doExecute> invoked from <execute> failed <892>
CAUAJM_E_18416 Event Server: <AUTODP1B.bankofamerica.com>  Failed Query: <BEGIN :RetVal := UJO_CLEANUP_JOBRUNS (:I_endtime, :I_batch_size, :I_delete_orphans); END; <<1595188915,10000,1>>>
........
......
....

Cause

The error occurred due to corruption or changes made to the database function: UJO_CLEANUP_JOBRUNS on the CA Workload Automation AE database.

Environment

Release : 11.3.6

Component : CA Workload Automation AE (AutoSys)

Resolution

Execute the RefreshAEDB.pl. It will refresh the Workload Automation AE database.

http://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/intelligent-automation/workload-automation-ae-and-workload-control-center/11-3-6-SP8/installing/ae-installation/refresh-a-ca-workload-automation-ae-database.html

 

Additional Information

The script needs to be executed on both the database individually in dual event server environments.