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.