Problem: Need to move Analytics database to a dedicated SQL server. It is highly recommended you move this database to a separate dedicated SQL server on any production installations.
Cause: The included Hypersonic SQL (HSQL) is not designed for production environments
Prerequisite(s):
- Unified Workspace 6.3.0.232 or later
- Supported SQL database already setup and configured
- Relevant SQL script already run against database (found in the stoneware\hsql\dbscripts folder)
- SQL JDBC driver already in place
Solution(s): Reconfigure webNetworkAuditDB connection object, Audit service and fix Analytics reports.
Configure webNetworkAuditDB:
- Go to webAdmin tool
- Expand Report Admin and click on webNetworkAuditDB
- Change Database type to MySQL (or relevant Microsoft SQL)
- Enter IP address/DNS name
- Enter database name wn_audit
- Click Save button
- Click Ping button
- Input credentials then click Test Connection
- Verify connection was successful
Configure Audit service:
- Go to Server Management Console (https://127.0.0.1:8090)
- Go to Services tab
- Right-click on Audit Services
- Select Properties
- Enter wnsql service account credentials
- Click Save button
- Right-click on Audit Services
- Click Restart
- Verify Audit Services restarts successfully
- Repeat steps 1-9 for every other Unified Workspace server
Fix Analytics reports:
- Go back to webAdmin tool
- Expand Utilities and select Migrate Audit/Logging
- Click Browser button
- Select OU=Stoneware and click OK
- Select webNetwok Audit Database connection
- Enter wnsql credentials
- Click Next Step button
- Choose database for catalog
- Click Next Step
- Verify completed
**It is recommended to setup your database to purge old records according to your organization's retention policy to keep your database from growing too large, as UW does not purge old records.
Reference(s):