Error: java.lang.AbstractMethodError with SEC_SQL VARA in AWA v24

Products

• Automic Automation

Issue/Introduction

When executing SQL VARA objects or performing previews in AWA v24 with an Oracle database, the agent may encounter java.lang.AbstractMethodError or ORA-00942 errors. This is often caused by the use of outdated Oracle JDBC drivers that do not support the JDBC 4.1 (Java 7+) standards required by the v24 agent.

Environment

• AWA v24
• Oracle Database
• Java 17+

Cause

 The error java.lang.AbstractMethodError: Receiver class oracle.jdbc.driver.T4CConnection does not define or inherit an implementation of the resolved method 'abstract java.lang.String getSchema()' occurs because the AWA v24 agent requires a modern JDBC driver that implements the java.sql.Connection interface. Older drivers (e.g., ojdbc6.jar, ojdbc7.jar) lack this functionality. Additionally, having multiple ojdbc*.jar files in the agent directory can lead to the agent loading an incompatible driver.

Resolution

To resolve this issue, download and install the ojdbc17.jar driver.

1. Download the ojdbc17.jar driver from the official Oracle JDBC Downloads page.
2. Navigate to the agent's /bin/jdbc directory.
3. Remove all older versions of the JDBC driver (e.g., ojdbc6.jar, ojdbc7.jar, ojdbc8.jar). Ensure ojdbc17.jar is the only JDBC driver file present in the directory.
4. Restart the agent.
5. Retry the SQL VARA object preview or execution.

Additional Information

If the issue persists, ensure that the SQL queries do not contain unnecessary line feeds between the table name and the WHERE clause, as older parsers or misconfigurations can occasionally trigger ORA-00942 if the SQL is not properly formatted.

For further assistance, please contact Broadcom Support.