The "Connection test" within the SQL job produces the error message : Connection test failed

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

The "Connection test" within the SQL job  produces the error message in AWI when testing a CONN (Connection) object for an Oracle database. 

Connection test failed

Environment

Products: Automation Engne version 24.x, SQL Agent version 24.x

Environment: Oracle Database

 

Cause

The issue was traced to the database user XXXX not owning any tables. In Oracle, the JDBC getTables() call (used by the "Test Connection" button) queries ALL_TABLES filtered by OWNER. Since the user XXXX only has grants on other schemas' objects but owns nothing itself, the check returns an empty list, which the AWI interprets as a failed connection.

Resolution

The DBA should ensure the XXXX user owns at least one table to satisfy the JDBC metadata check. A simple dummy table can be created owned by the user XXXX. This confirms ownership and resolves the cosmetic warning without impacting existing permissions.