Lenovo Software Help Center

How to setup Analytics in dedicated SQL

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:
  1. Go to webAdmin tool
  2. Expand Report Admin and click on webNetworkAuditDB
  3. Change Database type to MySQL (or relevant Microsoft SQL)
  4. Enter IP address/DNS name
  5. Enter database name wn_audit
  6. Click Save button
  7. Click Ping button
  8. Input credentials then click Test Connection
  9. Verify connection was successful


Configure Audit service:
  1. Go to Server Management Console (https://127.0.0.1:8090)
  2. Go to Services tab
  3. Right-click on Audit Services
  4. Select Properties
  5. Enter wnsql service account credentials
  6. Click Save button
  7. Right-click on Audit Services
  8. Click Restart
  9. Verify Audit Services restarts successfully
  10. Repeat steps 1-9 for every other Unified Workspace server


Fix Analytics reports:
  1. Go back to webAdmin tool
  2. Expand Utilities and select Migrate Audit/Logging
  3. Click Browser button
  4. Select OU=Stoneware and click OK
  5. Select webNetwok Audit Database connection
  6. Enter wnsql credentials
  7. Click Next Step button
  8. Choose database for catalog
  9. Click Next Step
  10. 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):

    • Related Articles

    • Move SQL Databases to a new SQL Server

      Issue Customer would like to move their UW SQL Databases from older hardware to new hardware. Solution The easiest method is to use the same SQL database type, as this only requires exporting/importing the existing database from the old server to the ...
    • Running Analytics Migration Wizard

      After applying a Service Pack, not all of the Analytics reports work.  Some show an error: Unable to Run Report The database that contains the information for this report is not currently available. Please try again later.  If you continue to have an ...
    • Analytics Link report not working after upgrading to 6.3.0.x

      Problem:  Analytics Link reports not loading after upgrading to 6.3.0.x Cause:  We discovered in about version 6.3.0.127 that the ActionID that define the events for the Audit database were changed thus causing the Link Report in the Analytics tile ...
    • MS SQL Transaction Logs full

      MS SQL defaults to only truncating the transaction logs once the database and transaction log have been properly backed up. At that point the server will clean truncate and compact the log files.  Obviously, this requires having a backup system in ...
    • Dedicated IP webapp with multiple ports

      Question:  How does a dedicated IP webapp with multiple ports work ? Answer: If multiple ports are configured and the app is configured for SSL, only port 443 will use SSL. All other ports will just be http.  If the app is configured so that the ...
    • Popular Articles

    • Can a Teacher see Students outside of school?

      This content has moved! Visit the new LanSchool Classic Help Desk It looks like you may be interested in LanSchool Classic General FAQ.
    • LanSchool Latest Release Notes

      This content has moved! Visit the new LanSchool Classic Help Desk It looks like you may be interested in LanSchool Classic Latest Release Notes.
    • How to uninstall LanSchool Student and WebHelper from Chromebook

      This content has moved! Visit the new LanSchool Classic Help Desk It looks like you may be interested in Mass Deploying LanSchool Student for Chromebook.
    • LanSchool 8.0.2.82 Release Notes

      LanSchool™ Release Notes Updated: December 16, 2019 Component Versions LanSchool 8.0.2.82, December 16, 2019 Chromebook App 8.0.2.13, December 16, 2019 Chrome Web Helper: 8.0.2.5, December 16, 2019iOS TA and Student 8.2.0, December 16, 2019 Android ...
    • Controlling multiple students at once

      Problem: Can I remote control multiple computers at once? Cause: N/A Prerequisite(s): LanSchool Teacher and Student Solution(s): If all of the computers in the lab are the same basic image or configuration (for example. all Windows XP machines with ...
    • Recent Articles

    • Lenovo Software Newsletter

      Question Is there a way I can be notified about product updates? Solution To receive updates from Lenovo Software about product updates, we encourage customers to subscribe to our Lenovo Software Newsletter.
    • Allow Help Desk to reset Image Challenge images

      Issue Customer would like to allow Help Desk users to only be able to reset user Image Challenge images when they have been forgotten by a user. Solution This can be done by assigning specific users in the system the User Group Admin role, as well as ...
    • Troubleshoot RDS

      This is a good article, from Microsoft, on how to troubleshoot RDS/RDP logon issues. https://social.technet.microsoft.com/wiki/contents/articles/37841.remote-desktop-services-rds-logon-connectivity-overview-and-troubleshooting.aspx
    • Building an Employee Phonebook system

      Building a Mini Application Post #20 Can it really be that simple to create a little application with Report and Form Builder?  This tutorial shows you that it is - and actually helps you make a useful application at the same time as learning how to ...
    • Working with Binary Data in Report Services

      Quick Start Guide - Binary Data This tutorial is designed as a quick "How Do I Work With Binary Data" tutorial.  It walks through the steps necessary to upload an image to a database.  Every webNetwork 6.0 installation ships with a database called ...