Reading oracle dynamic variable fails

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Reading oracle dynamic variable fails

Environment

Release: AOATAM99000-9.0-Automic-One Automation Tools-Application Manager
Component:

Resolution

Symptoms

Issue trying to read oracle dynamic variable it fails with getmetadata error.

?Investigation

Data needed for analysis:

• Agent logfile from the time the error occurred

Error-Message from Agent logfile:

U2012045 The database returned an error for Run ID '1332020/1':
                  statement handle not executed: getMetaData
  
This Issue is caused by an oracle bug in the oracle JDBC driver. ?

Solution

• The Issue is caused by a bug in the oracle JDBC driver.
• Please download the newest driver from http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html and replace the jar in the jdbc folder of the SQL Agent.
  
  ?