Error: Agents showing down in Automic Web Interface due to Oracle Tablespace Exhaustion

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Automic Automation agents appear as "Down" or "Disconnected" in the Automic Web Interface (AWI) even though the agent services are running. This occurs when the Automation Engine (AE) cannot write to the Oracle database.

Symptom

• All agents show as "Down" in AWI.
• AE logs show errors: ORA-01653, ORA-02002, or ORA-01691.

Environment

• Automic Automation Engine
• Oracle Database

Cause

The Oracle tablespaces (typically AUD_DATA or UC4_DATA) are full and do not have AUTOEXTEND enabled. The AE is unable to write job statuses, agent connection states, or internal messages to the database.

Resolution

1. Stop the Automation Engine (AE) services on all servers.
2. Consult the Database Administrator (DBA) to extend the impacted tablespaces:
   • Increase the size of the data files.
   • Enable AUTOEXTEND for AUD_DATA and UC4_DATA.
3. Start AE services.
4. Verify agent connectivity in AWI.

If the system is in an inconsistent state and the problem doesn't clear after fixing the tablespace issues, contact technical support for additional guidance. 

 

Additional Information

Proactive Measures:

• Configure monitoring alerts for tablespace usage (e.g., alert at 80% capacity).