DBMaint Errors

Products

• Autosys Workload Automation

Issue/Introduction

We have patched to 12.0 01.03 but we are still seeing these errors in the DBMaint log:

CAUAJM_I_60019 dbstatistics: Running dbstatistics at: Mon Sep 19 03:31:13 2022

CAUAJM_E_18416 Event Server: <AUTOSYS_PRD>  Failed Query: <begin dbms_stats.gather_table_stats('aedbadmin','ujo_proc_event',ESTIMATE_PERCENT=>DBMS_STATS.AUTO_SAMPLE_SIZE ,METHOD_OPT=>'FOR ALL INDEXED COLUMNS SIZE AUTO',CASCADE=>TRUE);end;>
CAUAJM_E_18402 ORA-12609: TNS: Receive timeout occurred
CAUAJM_I_18403 Processing OCI function ODEFIN(34)
CAUAJM_E_18400 An error has occurred while interfacing with ORACLE.
CAUAJM_E_18401 Function <doExecute> invoked from <execute> failed <919>
CAUAJM_E_18416 Event Server: <AUTOSYS_PRD>  Failed Query: <begin dbms_stats.gather_table_stats('aedbadmin','ujo_proc_event',ESTIMATE_PERCENT=>DBMS_STATS.AUTO_SAMPLE_SIZE ,METHOD_OPT=>'FOR ALL INDEXED COLUMNS SIZE AUTO',CASCADE=>TRUE);end;>
CAUAJM_E_18402 ORA-12609: TNS: Receive timeout occurred
CAUAJM_I_18403 Processing OCI function ODEFIN(4)
CAUAJM_E_18400 An error has occurred while interfacing with ORACLE.
CAUAJM_E_18401 Function <doExecute> invoked from <execute> failed <919>
CAUAJM_E_18416 Event Server: <AUTOSYS_PRD>  Failed Query: <begin dbms_stats.gather_table_stats('aedbadmin','ujo_proc_event',ESTIMATE_PERCENT=>DBMS_STATS.AUTO_SAMPLE_SIZE ,METHOD_OPT=>'FOR ALL INDEXED COLUMNS SIZE AUTO',CASCADE=>TRUE);end;>
CAUAJM_E_18402 ORA-12609: TNS: Receive timeout occurred
CAUAJM_I_18403 Processing OCI function ODEFIN(4)
CAUAJM_E_18400 An error has occurred while interfacing with ORACLE.
CAUAJM_E_18401 Function <doExecute> invoked from <execute> failed <919>
CAUAJM_E_18416 Event Server: <AUTOSYS_PRD>  Failed Query: <begin dbms_stats.gather_table_stats('aedbadmin','ujo_proc_event',ESTIMATE_PERCENT=>DBMS_STATS.AUTO_SAMPLE_SIZE ,METHOD_OPT=>'FOR ALL INDEXED COLUMNS SIZE AUTO',CASCADE=>TRUE);end;>
CAUAJM_E_18402 ORA-12609: TNS: Receive timeout occurred
CAUAJM_I_18403 Processing OCI function ODEFIN(4)
CAUAJM_E_18400 An error has occurred while interfacing with ORACLE.
CAUAJM_E_18401 Function <doExecute> invoked from <execute> failed <919>
CAUAJM_E_18416 Event Server: <AUTOSYS_PRD>  Failed Query: <begin dbms_stats.gather_table_stats('aedbadmin','ujo_proc_event',ESTIMATE_PERCENT=>DBMS_STATS.AUTO_SAMPLE_SIZE ,METHOD_OPT=>'FOR ALL INDEXED COLUMNS SIZE AUTO',CASCADE=>TRUE);end;>
CAUAJM_E_18402 ORA-12609: TNS: Receive timeout occurred
CAUAJM_I_18403 Processing OCI function ODEFIN(4)
CAUAJM_E_18400 An error has occurred while interfacing with ORACLE.
CAUAJM_E_18401 Function <doExecute> invoked from <execute> failed <919>
CAUAJM_E_18416 Event Server: <AUTOSYS_PRD>  Failed Query: <begin dbms_stats.gather_table_stats('aedbadmin','ujo_proc_event',ESTIMATE_PERCENT=>DBMS_STATS.AUTO_SAMPLE_SIZE ,METHOD_OPT=>'FOR ALL INDEXED COLUMNS SIZE AUTO',CASCADE=>TRUE);end;>
CAUAJM_E_18402 ORA-12609: TNS: Receive timeout occurred
CAUAJM_I_18403 Processing OCI function ODEFIN(4)
CAUAJM_E_18400 An error has occurred while interfacing with ORACLE.
CAUAJM_E_18401 Function <doExecute> invoked from <execute> failed <919>
CAUAJM_E_18416 Event Server: <AUTOSYS_PRD>  Failed Query: <begin dbms_stats.gather_table_stats('aedbadmin','ujo_proc_event',ESTIMATE_PERCENT=>DBMS_STATS.AUTO_SAMPLE_SIZE ,METHOD_OPT=>'FOR ALL INDEXED COLUMNS SIZE AUTO',CASCADE=>TRUE);end;>
CAUAJM_E_18402 ORA-12609: TNS: Receive timeout occurred
CAUAJM_I_18403 Processing OCI function ODEFIN(4)
CAUAJM_E_18400 An error has occurred while interfacing with ORACLE.
CAUAJM_E_18401 Function <doExecute> invoked from <execute> failed <919>
CAUAJM_E_18416 Event Server: <AUTOSYS_PRD>  Failed Query: <begin dbms_stats.gather_table_stats('aedbadmin','ujo_proc_event',ESTIMATE_PERCENT=>DBMS_STATS.AUTO_SAMPLE_SIZE ,METHOD_OPT=>'FOR ALL INDEXED COLUMNS SIZE AUTO',CASCADE=>TRUE);end;>
CAUAJM_E_18402 ORA-12609: TNS: Receive timeout occurred
CAUAJM_I_18403 Processing OCI function ODEFIN(4)
CAUAJM_E_18400 An error has occurred while interfacing with ORACLE.
CAUAJM_E_18401 Function <doExecute> invoked from <execute> failed <919>
CAUAJM_E_18416 Event Server: <AUTOSYS_PRD>  Failed Query: <begin dbms_stats.gather_table_stats('aedbadmin','ujo_proc_event',ESTIMATE_PERCENT=>DBMS_STATS.AUTO_SAMPLE_SIZE ,METHOD_OPT=>'FOR ALL INDEXED COLUMNS SIZE AUTO',CASCADE=>TRUE);end;>
CAUAJM_E_18402 ORA-12609: TNS: Receive timeout occurred
CAUAJM_I_18403 Processing OCI function ODEFIN(4)
CAUAJM_E_18400 An error has occurred while interfacing with ORACLE.
CAUAJM_E_18401 Function <doExecute> invoked from <execute> failed <919>
CAUAJM_E_18416 Event Server: <AUTOSYS_PRD>  Failed Query: <begin dbms_stats.gather_table_stats('aedbadmin','ujo_proc_event',ESTIMATE_PERCENT=>DBMS_STATS.AUTO_SAMPLE_SIZE ,METHOD_OPT=>'FOR ALL INDEXED COLUMNS SIZE AUTO',CASCADE=>TRUE);end;>
CAUAJM_E_18402 ORA-12609: TNS: Receive timeout occurred
CAUAJM_I_18403 Processing OCI function ODEFIN(4)
CAUAJM_E_18400 An error has occurred while interfacing with ORACLE.
CAUAJM_E_18401 Function <doExecute> invoked from <execute> failed <919>
CAUAJM_E_10163 Exhausted maximum number of query retries.
CAUAJM_E_10160 The execution of the below query experienced an unrecoverable error and will not be retried:
dbstatistics: failed to update statistics.

Environment

Autosys 12.x

Oracle 19c

Cause

Database performance issue

Resolution

The oracle database was taking 120+ seconds to return the Stats query.
The DBA had to resolve the underlying performance issue or increase the timeouts in the sqlnet.ora file to allow for this to complete.