Client encountering an error when running a job in Autosys
search cancel

Client encountering an error when running a job in Autosys

book

Article ID: 142602

calendar_today

Updated On:

Products

CA Workload Automation AE - Scheduler (AutoSys) 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

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.