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.

    Can't find the KB

    Unable to find the KB to address your issue ?  

      • Recent Articles

      • Change Reset Password Button Text

        Change the text of the "Reset Password" button on the UW Login Page How to change the text of the Reset Password button on the Login Page. Login to webNetwork and open webAdmin on your Relay Central Server Expand Customization Center Expand Tenants ...

      • Remove Reset Password Button From Login Page

        Remove the Reset Password Button from the Login Page How to remove the Reset Password button from the Unified Workspace login page. Login to webNetwork and open webAdmin on your Relay Central Server Expand Customization Center Expand Tenants Expand ...

      • Lenovo Unified Workspace End-of-Life Questions and Answers

        As of January 31st 2024, Lenovo Unified Workspace (formerly Stoneware WebNetwork) is no longer supported. This means that we no longer provide licenses, downloads, updates, patches, or technical assistance for this product. If you have any questions ...

      • How do I determine my Unified Workspace license expiration date?

        The best method for determining the licensing information including the expiration date of your Unified Workspace license: Login to your 8090 management console on each server This may take remoting into each LUW server and relay, opening a browser, ...

      • Lenovo Unified Workspace 7.0.2.13 Released

        Highlights of Unified Workspace 7.0.2.13 Before you install: Please view the installation notes here. 7.0.2.13 requires a 7.0 license file. Below is a list of enhancements and fixes released in Unified Workspace 7.0.2.13 Fixed external storage ...

      • Related Articles

      • Restore Audit Services HSQL database to shipping state

        Prerequisite: Unified Workspace is still configured to use the shipping "demo" HSQL database for Audit Services. Issue: webNetwork service will not finish starting.  The /stoneware/config/webNetworkTrace.log startup log file shows UW is getting stuck ...

      • Unified Workspace Specifications

        Latest Version 7.0.0.63 Browser Requirements Lenovo Unified Workspace requires a browser with JavasScript support.  Clients will need to meet the minimal requirements of a browser and Internet/network connections for full functionality. The list ...

      • Potential issues with HSQL database during upgrades

        With the release if 6.3.1.x and higher the HSQL database was updated.  This upgrade requires us to check each of your HSQL database files in \stoneware\hsql and upgrade the format to a newer storage method. It does this by reading the data from each ...

      • Unified Workspace 6.5 - Updated SAML Configuration Interface

        Improved SAML configuration capabilities Simplified configuration of your own applications More intuitive interface for configuring new and existing applications Fast import for application vendors that provide a metadata URL For more information on ...

      • Apply Unified Workspace license

        Issue: A customer has an updated license file and needs to apply it to their Unified Workspace (UW) servers. Solution: To apply the updated license file to each UW server: Login to the Customer Portal, download your Unified Workspace license ...