What does webNetwork send to the SQL server to purge logging data each night?

What does webNetwork send to the SQL server to purge logging data each night?

Each night at midnight the loader sends a SQL command to the SQL server to purge old log information.  That command is as follows :

DELETE FROM LogTable WHERE LogTime < 'some date';

'some date' is formatted like this: yyyy-MM-dd HH:mm:ss

If your database is very large then this command may not be able to finish each night because your database typically has transnational roll back configured.  This makes a copy of the data prior to purging which may fail if you do not have enough space. Each DB system sets this up slightly different so please refer to your DB vendor for how to disable transaction logging for the webNetwork logging database. Transaction logging is a great feature for many types of data, but not needed for the relay log data.

Another way to purge the DB by hand is to add the LIMIT command to limit the number of records being purged.  This is easier than trying to come up with a SQL statement that gives a smaller subset of data.

DELETE FROM LogTable WHERE LogTime < 'some date' LIMIT 10000;

This would limit the delete to 10,000 entries.  If you ran it multiple times it would delete a batch of 10,000 records each time thus getting around the problem with the transaction roll back settings.

As of 6.2.0.51 and higher, we have limited the amount of data that gets logged in the relay request logging.  We filter out things like .gif, .jpg, .png, .css, .js.  This helps to keep the database smaller.


The webNetwork Audit DB does not have an auto purge, thus you will want to periodically purge the data using a command such as : delete FROM auditdata where datetime < '2015-01-01 00:00:00' LIMIT 100000;  This would purge data older than 2015-01-01 and do it in a batch of 100,000 records at a time.

    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 database logging to SQL server.

        Changing / migrating the Logging Database from HSQL to MySQL , MSSQL. By default, the Stoneware Relay logs all transactions to a Java database called HyperSonic SQL. This database is installed as part of the portal installation and automatically ...
      • Move webNetwork to different server

        *** If you are moving to a different OS, please see : https://helpdesk.lenovosoftware.com/portal/kb/articles/migrate-webnetwork-to-windows-linux-22-8-2017 *** Keeping the same OS / version / IP As long as you are keeping the same OS/ version/IP then ...
      • 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 ...
      • 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 ...
      • Server stops periodically

        Every few days the webNetwork server (aka loader) stops. Start it back up and it will run for a few more days. Suggestions 1) anti-virus server like Symantec 10 which has issues (with windows) and causes box to run out of ram and then windows kills ...