Existing DBs vanish and add a database workflow fails with Name already exists! for Aria Automation Orchestrator SQL plugin

Products

• VCF Operations/Automation (formerly VMware Aria Suite)

Issue/Introduction

• When leveraging the Aria Automation Orchestrator SQL plugin database previously added suddenly no longer appear in the inventory.
• Attempting to re-add the missing databases fails with:
  
  

Error "com.vmware.o11n.plugin.database.DatabaseException: Name already exists! (Dynamic Script Module name : addDatabase#9)"

 

Environment

Aria Automation Orchestrator SQL plugin version 1.3.0.24974166.vmoapp & below

Cause

The plugin object is not initialized properly, the platform uses null instead of a normal plugin factory. This breaks the mechanism for reloading the DB endpoint settings.

Resolution

The issue is resolved in the SQL plugin build attached to this article: o11n-plugin-sql-1.3.0+24997542.vmoapp

To install the Plugin follow the install instructions in the documentation

To workaround the issue in the interim you can disable and enable again the sql plugin. After this you should be able to run the workflow to re-add the databases manually.