Autoping fails with CAUAJM_E_18416 and CAUAJM_E_18402 ORA-01400 messages.

Document ID : KB000038943
Last Modified Date : 14/02/2018
Show Technical Document Details

Symptom:

Autoping fails with the following messages:
CAUAJM_I_30033 Client [CA WAAE AutoPing:x][x][xx] session ended
CAUAJM_E_18416 Event Server:<x> Failed Query: <BEGIN :RetVal := ujo_put_job ..
CAUAJM_E_18402 ORA-01400: cannot insert NULL in ("AEDBADMIN"."UJO_SCHED_INFO"."JOB_VER")
ORA-06512: a "AEDBADMIN.UJO_PUT_JOB", ligne 590
ORA-06512: a ligne 1 

....

CAUAJM_I_10165 The previously failed query below succeeded after 1 attempt(s)

 

Cause:

Most likely there is an intermittent database OCI API failure so as_server failed to complete the SQL operation at that time. 

 

Resolution:

Nothing to do, this is just a temporarily error at the base level. There should not be any worry about this SQL error as it is generally successful after 1 re-attempt (1 second after the symptom).