vRO, an External SQL Database, and the case of the Missing Plugins

After setting up a fresh deployment of the vRO 5.5.2.1 appliance and configuring it to use an external SQL database I noticed that many of the default plugins appeared to be missing in the Workflow library folder:

(there should be a lot more than listed here)

Logging into the vRO configuration page  showed the below list of plugins (and more going off the screen) appeared to exist and be installed correctly.

 

Having mostly worked with Windows based vRO servers before and not seen this issue I got a few clues from this blogpost and this communities post  which suggests it appears to be a bug relating to configuring vRO to work with a different database.

The workaround is to navigate to the Troubleshooting section of the configuration page and select Reset current version

All being well you will receive the below green message:

I then restarted the vRO appliance, logged back in with the vRO client and lo and behold all of the plugins were then present.

I checked this against a default deployment of the vRO appliance with the embedded database and the issue is not present.