Client encountering an error when running a job in Autosys

Products

• CA Workload Automation AE - Business Agents (AutoSys)
• CA Workload Automation AE - System Agent (AutoSys)
• CA Workload Automation AE - Scheduler (AutoSys)
• Workload Automation Agent
• CA Workload Automation AE

Issue/Introduction

Client is trying to force start a job and is encountering the following error:

CAUAJM_E_18416 Event Server: <lautsd1.company.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: <lautsd1.company.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.

Please let us know what can be done to fix this issue.

Environment

Release : 11.3.6 

Component : CA 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';

And then delete the invalid entry.