Analytics Link report not working after upgrading to 6.3.0.x

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 to not function.  The data for ActionID 107 and higher were incremented by 1, thus causing the reports to search for invalid data.


Prerequisite(s):
  • webNetwork upgraded to 6.3.0.197 or higher
  • Analytics setup in MySQL or MS SQL server
  • Know your Analytics database/schema name
  • Access to native SQL server tools

Solution(s):  You'll need to manually adjust the logs for the data range that they were effected.  The following example will show you how to fix for MySQL.  Make sure to replace swaudit for your own database/schema name if different.  For MS SQL, replace swaudit.auditdata for dbo.auditdata.
  1. Verify webNetwork servers are 6.3.0.197 or higher
  2. Make a backup of your Audit database using native SQL tools
  3. Connect to SQL server using native tools
  4. Run commmand - SELECT * FROM swaudit.auditdata where actionid=107 and data3 is not null;
  5. Look for the first entry in the results and record the datetime field to get the start date (ex: 2015-07-01 00:01:55)
  6. Look for the last entry in the results and note the datetime filed to get the end date (ex: 2015-10-02 23:53:09)
  7. Run command - update swaudit.auditdata set actionid=106 where (actionid=107 and (datetime>="2015-07-01 00:01:55" and datetime <="2015-10-02 23:53:09" ));
  8. Run command again, but increment actionid - update swaudit.auditdata set actionid=107 where (actionid=108 and (datetime>="2015-07-01 00:01:55" and datetime <="2015-10-02 23:53:09" ));
  9. Repeat until step 8 until actionid=120 where (actionid=121 and (datetime>="2015-07-01 00:01:55" and datetime <="2015-10-02 23:53:09" ));
  10. Test Analytics Link report and reports should load normally again

    • Related Articles

    • 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 ...
    • 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 ...
    • 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 ...
    • 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 ...
    • Slingshot will not install after upgrading to 6.4.0.x

      Symptoms: Slingshot applications are unable to install the Slingshot application for kicking off slingshot applications.  Error is received "Unable to contact server." Issue: TLSv1 is disabled by default in the stoneware/config/excludeProtocols file. ...
    • Popular Articles

    • Old Browser Versions

      Question: I am using an older browser version and am having problems. What can be done ? We are not able to upgrade the browser at this time.   This is a challenge for any company that makes software that utilizes a browser. Since Stoneware does not ...
    • LCS Redirection

      Problem: How to redirect the LCS in an environment with multiple LCSs and students connecting to them. Solution(s): Create an allow.cfg on all LCS(s) (including the Master) in the network, however, even if no allow.cfg is present on an LCS, machines ...
    • Time windows allows for Service Shutdown

      Issue: Can the time windows gives a service to shut down before it kills the service be increased? Solution: Yes, the following information comes from the Microsoft URL : http://support.microsoft.com/kb/146092 To specify the wait time, do the ...
    • How to disable password saving - Internet Explorer

      Having multiple methods for saving a password in the browser can cause confusion for the user.   To disable password saving in Internet Explorer, launch Internet Explorer and perform the following steps. Click the blue Settings menu icon in the upper ...
    • How to disable password saving - Chrome

      Having multiple methods for saving a password in the browser can cause confusion for the user.  To disable password saving in Chrome, launch Chrome and perform the following steps. Click the Chrome menu button in the upper right corner of the Chrome ...
    • Recent Articles

    • Lenovo Unified Workspace 7.0.0.63 Released

      Highlights of Unified Workspace 7.0.0.63 If you need assistance with your update, please e-mail support at support@lenovosoftware.com or visit https://unifiedworkspace.com/support/ for more information. Below is a list of enhancements and fixes for ...
    • How to fix customized login and profile after upgrading to v7.0

      With the release of 7.0 the default login page has been modified to simplify the customization process.  If you are having an issue with the login page not displaying, after upgrading to v7.0, you will need to delete the custom CSS code and start ...
    • SAML SP - Sync Directory Password

      Login script to prompt for directory password Since the user does not login into Unified Workspace with a password, we cannot capture the password to use in the @@password@@ variable.  If you would like to use the Active Directory password for other ...
    • MySQL 8 SSL

      Issue Admin is making a database connection to a MySQL 8 database.  When clicking the Ping button on the DB Connection object, the following error is presented: WARN: Establishing SSL connection without server's identity verification is not ...
    • 7.0 excludeProtocols - includeProtocols - allowCiphers - denyCiphers config file

      excludeProtocols - includeProtocols - allowCiphers - denyCiphers config file The following configuration is recommended for systems running 7.0.0.63, and higher. (For older 6.5 releases of UW, please see this article.) ...