Restore Audit Services HSQL database to shipping state

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 at starting the Audit Service.


Solution:

Restore the the Audit Services HSQL database to a clean shipping state.**

  1. Shutdown the webNetwork service on your server.

  2. Delete, or move elsewhere, the following 4 files:
    /stoneware/hsql/audit.backup
    /stoneware/hsql/audit.data
    /stoneware/hsql/audit.properties
    /stoneware/hsql/audit.script

  3. Copy the following 4 files from the /stoneware/hsql/orig/ folder:

    /stoneware/hsql/orig/audit.backup
    /stoneware/hsql/orig/audit.data
    /stoneware/hsql/orig/audit.properties
    /stoneware/hsql/orig/audit.script

    To the /stoneware/hsql/ folder:

    /stoneware/hsql/audit.backup
    /stoneware/hsql/audit.data
    /stoneware/hsql/audit.properties
    /stoneware/hsql/audit.script

  4. Start the webNetwork service up again.

**This puts a clean, out-of-the-box, audit database in place.  You will loose all information that was contained in the previous Audit database files.

It is best to then consider moving to an Enterprise level SQL server, such as mySQL or MS SQL, to prevent this from happening again in the future.

    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

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

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

      • Data Recorded in the Audit Database

        Issue Customer would like to build reports to view specific information logged by UW, that is not available from Analytics.  What additional information is logged in the Audit Database? Solution There is quite a bit more information recorded into the ...

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

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