Workflows that use SQL Plug-In in the Orchestrator of VMware Aria Automation 8.17 are frozen in the step of executing SQL queries

Products

• VCF Operations/Automation (formerly VMware Aria Suite)

Issue/Introduction

In attempting to run vRO workflows that leverage the vRO SQL plugin the workflow hangs on the SQL plugin elements. When the SQL inventory is expanded it never loads. 

Environment

Aria Automation 8.17

Resolution

If the Aria Automation appliance is brought down and restarted with the standard procedure and then brought back up this appears to resolve the issue. It is believed that upgrading to 8.18.1 latest patch may resolve this issue.