Workflow dependent upon SQL plugin fails in Aria Automation Orchestrator 8.18.1 with TypeError: Cannot find function registerOutParameter in object DynamicWrapper

Products

• VCF Operations/Automation (formerly VMware Aria Suite)

Issue/Introduction

• You recently upgraded to Aria Automation / Aria Automation Orchestrator 8.18.1
• You are using an Oracle JDBC Driver similar to ojdbc8.jar
• You have a workflow with OJDBC registerOutParameter that now fails with a TypeError with a message similar to:

  [STRATEGIC] [OJDBC] ERROR: TypeError: Cannot find function registerOutParameter in object DynamicWrapper (Instance) : [PreparedStatement]-[interface java.sql.PreparedStatement] – VALUE : oracle.jdbc.driver.OracleCallableStatementWrapper@#######

Environment

VMware Aria Automation 8.18.1

VMware Aria Automation Orchestrator SQL plugin

 

Cause

After upgrading to Aria Automation Orchestrator 8.18.1, workflows using Oracle JDBC CallableStatement fail due to a change in how the scripting engine treats the relationship between PreparedStatement and CallableStatement.

• Before 8.18.1, the prepareCall() function correctly returned a CallableStatement object, allowing the use of registerOutParameter().
• After 8.18.1, prepareCall() incorrectly returns a PreparedStatement instead of a CallableStatement, causing workflows to fail when calling registerOutParameter().

Resolution

VMware is aware of this issue and a fix is being considered for inclusion in a later patch. [8.18.1 P2]

• If your workflows depend on CallableStatement functionality, avoid upgrading to 8.18.1 until patch2 is released.
• If you have already upgraded and cannot roll back, please subscribe to this article for additional future information.

Additional Information

For further updates, please refer to this article or contact Broadcom support.