HSQL database driver updated in Unified Workspace

HSQL database driver updated in Unified Workspace

As of Unified Workspace 6.3.1.x, the driver used to communicate with the built-in HSQL databases is being updated.

This update changes the delimiter used when storing the information.  If you are using HSQL for anything other than webStore (which natively uses an HSQL database and has been adjusted accordingly) you will run into issues with those databases.

If your Analytics/Audit database is still using the built-in (demo) HSQL database.
1. You will need to delete all of the Analytics forms and report objects, through webAdmin (inside of Report Admin).
2. Run upgrade Wizard #2 in the 8090 Console, to recreate all of the objects with new ones that support the changed delimiter.  Select that you are upgrading from 6.0.

If you are using HSQL for any custom databases that you created on the servers, now would be a good time to switch to an Enterprise level database (such as MySQL or Microsoft SQL).  Otherwise, you will need to manually adjust your existing forms/reports for your custom database.