Potential issues with HSQL database during upgrades

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 hsql .data file and writing it to a new file then swapping the files upon completion.

The HSQL engine is not enterprise grade and was meant as a simple database to test a feature that needed a database without having to set up MYSQL or MS SQL.  Because of this sometimes the HSQL .data file can become corrupt or grow so large that the upgrade process can not upgrade the HSQL database and gets "stuck".

Before upgrading from a UW version below 6.3.1.x please check for these two things.

  • You have HSQL .data file in \stoneware\hsql that have updated timestamps, with the exception of appselector.data which is the webStore database and will have updated time stamps.
  • You have an HSQL .data file in \stoneware\hsql that is nearing 100 meg.  This seems to be a size that HSQL starts to have an issue with and the file could be corrupt.
If you have either of those two scenarios please contact Stoneware / Lenovo Software support to discuss your options for disabling/resetting those databases prior to running the upgrade.

    Can't find the KB

    Unable to find the KB to address your issue ?  

      • Recent Articles

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

        Will the shutdown of LUW servers and access to downloads affect my server licensing? No, the shutdown of the customer servers and access to the product and licensing downloads will not affect your server licensing. This license is downloaded and ...

      • 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 ...

      • LanSchool Documentation Guides

        LanSchool Classic Teacher Console The LanSchool Teacher Console is the interface teachers will use to manage their classroom and students. It contains all the tools necessary for a teacher to effectively interact with students and create a ...

      • Lenovo Unified Workspace 7.0.1.41 Released

        Highlights of Unified Workspace 7.0.1.41 Before you install: Please view the installation notes here. 7.0.1.41 requires a 7.0 license file. Below is a list of enhancements and fixes for Unified Workspace 7.0.1.41 Updated Log4j Updated Java Updated ...

      • Related Articles

      • 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 ...

      • 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 ...

      • Move database logging to SQL server.

        Changing / migrating the Logging Database from HSQL to MySQL , MSSQL. By default, the Stoneware Relay logs all transactions to a Java database called HyperSonic SQL. This database is installed as part of the portal installation and automatically ...

      • Remove SSO information for application in AppSelector database

        Problem:  The admin has created a webPass SSO tile that utilize Stoneware variables or hardcoded credentials.  This tile is showing the webPass key image indicating the user needs to set credentials, due to an existing webStore application that uses ...

      • Database Pooling

        Issue The way UW connects to a Database to run queries, it uses a single connection for each DB object created.  Thus if you have multiple queries that are run against that connection, they are processed in order, one at a time.  A very long query ...