DBMaint script failing and causing problems with the scheduler

Products

• Autosys Workload Automation

Issue/Introduction

The following error messages similar to the following are logged in DBMaint.out:

CAUAJM_I_60436 Archiving Machines...
CAUAJM_E_18416 Event Server: <EVENT123>  Failed Query: <select administrator, agent_name, character_code, description, factor, heartbeat_attempts, heartbeat_freq, mach_name, mach_status, max_load, node_name, opsys, parent_name, port, prepjobid, provision, que_name, type from ujo_machine where round((update_stamp-to_date('19700101','YYYYMMDD'))*24*60*60+(select int_val from ujo_alamode where type='gmt_offset')) < 1605180607 and is_active=0>
CAUAJM_E_18402 ORA-01406: fetched column value was truncated
CAUAJM_I_18403 Processing OCI function not used(4)
CAUAJM_E_18400 An error has occurred while interfacing with ORACLE.
CAUAJM_E_18401 Function <Ofetch> invoked from <nextRow> failed <1,048>
CAUAJM_E_60010 get_archive_machines() failed.  Exiting...

Environment

Release : 12.0

Component : CA Workload Automation AE (AutoSys)

Cause

A machine name that is 80 characters in length cannot be handled by the get_archive_machines() module.

Resolution

Name of one of the machines is 80 character long and needs to be removed manually from the database.

Run the following query to identify the one that causes the error messages:

select administrator, agent_name, character_code, description, factor, heartbeat_attempts, heartbeat_freq, mach_name, mach_status, max_load, node_name, opsys, parent_name, port, prepjobid, provision, que_name, type from ujo_machine where round((update_stamp-to_date('19700101','YYYYMMDD'))*24*60*60+(select int_val from ujo_alamode where type='gmt_offset')) < 1605180607 and is_active=0;