Running Analytics Migration Wizard

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 issue, please contact your administrator.

This is most likely occurring after running a UW update that contained updates to the Analytics report objects. The update will put the report objects back to using the stock database/database type/credentials.  Changing the credentials used to authenticate to the SQL server would also cause this error to occur.

The reports, therefore, need to be modified to use the correct database object / database type / credentials. 

Open webAdmin. 
Expand the Utilities folder. 
Select the "Migrate Audit/Logging" link. 

1. Choose to migrate the Audit Reports. 
2. Select the context where your report objects are saved. This is usually the Stoneware OU. 
3. Select the Database Connection that points to your MySQL or MSSQL database used by Analytics. 
4. Enter the Database Credentials. 
5. Click the "Next Step" button. 
6. If you are using MSSQL, you will have to verify the Catalog and Schema where the tables reside. 
7. Click the "Next Step" button. 

The results should show which reports were modified. 

*  If you have enabled Relay Logging then you will also want to do the following as well.  If you do not have Relay Logging enabled the section below is not necessary.

Click the "Run Wizard Again" button, so that you can adjust the Logging Reports. 

1. Choose to migrate the Logging Reports. 
2. Select the context where your report objects are saved. This is usually the Stoneware OU. 
3. Select the Database Connection that points to your MySQL or MSSQL database used by Analytics. 
4. Enter the Database Credentials. 
5. Click the "Next Step" button. 
6. If you are using MSSQL, you will have to verify the Catalog and Schema where the tables reside. 
7. Click the "Next Step" button. 

The results should show which reports were modified. 

Close the Migration Wizard. 
Test the Analytics Reports.

    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

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

      • Authentication error while trying to complete installation wizard

        During a new install, the customer completed wizard #1 and UW/webNetwork restarted and then started wizard #2.  It asked for a username and password and that was entered but it continued to prompt for the password. This can happen for a few reasons.  ...

      • New Analytics feature in webNetwork 6.1+

        In webNetwork 6.1 we added a new Analytics report that essentially replaces the old reports for querying the relay log information.  The old reports for many installs were called:  Authentication Report  Complete Report  Day of Month Report  Error ...

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

      • Configure Analytics features in webNetwork 6.1+

        Basic Steps: Create new database called "swaudit" Run the appropriate script file located in /stoneware/hsql/dbscripts directory Give access to the appropriate DB user accounts Create DB connection object OR reuse existing webNetworkAuditDB object ...