"ORA-01406: fetched column value was truncated" error when running a job in Autosys

Products

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

Issue/Introduction

Below errors are seen when force starting a job in Autosys

CAUAJM_E_18416 Event Server: <somehost.example.com>  Failed Query: <SELECT hostname FROM ujo_keymaster WHERE type='x'>
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,018>
CAUAJM_E_18416 Event Server: <somehost.example.com>  Failed Query: <SELECT hostname FROM ujo_keymaster WHERE type='x'>
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,018>

When the job is run by the admin account, it completes successfully.

Environment

Workload Automation AE (AutoSys)

Resolution

Use the following query to find the entry in ujo_keymaster that may cause the issue:

SELECT hostname FROM aedbadmin.ujo_keymaster WHERE type='x';

 

Delete the invalid entry with the help from a DBA and retest.