How to resolve the error „No syslog records found (code 8 )”?

Some people stumbled upon a problem when installing LogAnalyzer v3.0.0. They got the following error message:

No syslog records found (code 8 ) – Error Details:
Unknown or unhandeled error occured.

Additionally, when "MiscShowDebugMsg" is enabled they would see the following:

LogStreamPDO|PrintDebugError: Invalid SQL: SELECT id, devicereportedtime, fromhost, infounitid, facility, priority, syslogtag, eventid, eventlogtype, eventsource, eventcategory, eventuser, systemid, checksum, message FROM systemevents WHERE id <= 45 ORDER BY id DESC LIMIT 100

Errorcode: 42703
Detail error: 42703;7;ERROR: column "checksum" does not exist
Error Code: 42703

These error messages result from a missing column in the database. More specifically, this is resulting in the need of LogAnalyzer’s report module for the checksum column in the database (usually this is the table SystemEvents), which is already present when creating the database with some of the MonitorWare Products, but which will not be created when using LogAnalyzer 3.0.0 to set up the tables for storing Events. This is indeed a bug. Usually, the checksum column is not part of the regular MonitorWare database scheme, because it is not needed. Currently only LogAnalyzer and MonitorWare Console need it.

There are two possibilities to resolve this issue. The first is to insert the column manually into the database. You can use the following SQL script to do this. Please note, that you might need to alter the tablename if you don’t use the default name SystemEvents.

ALTER TABLE `systemevents` ADD `Checksum` int(11) NOT NULL DEFAULT ‘0’ AFTER `SystemID`;

The second option is to update to LogAnalyzer 3.0.1. You can download it here: http://loganalyzer.adiscon.com/downloads/loganalyzer-3-0-1-v3-beta

When updating to the newest version, the database can be upgraded automatically for MySQL and PostgreSQL databases. If you use a different database, you have to insert the column manually into the SystemEvents table.

Tags: ,

11 Responses to “How to resolve the error „No syslog records found (code 8 )”?”

  1. this is my loganalyzer database
    mysql> use syslog;
    Reading table information for completion of table and column names
    You can turn off this feature to get a quicker startup with -A

    Database changed

    mysql> show tables;
    +——————+
    | Tables_in_syslog |
    +——————+
    | charts |
    | config |
    | dbmappings |
    | fields |
    | groupmembers |
    | groups |
    | logs |
    | savedreports |
    | searches |
    | sources |
    | users |
    | views |
    +——————+
    12 rows in set (0.00 sec)

    wherever i go for search (filter) : syslog error and syslog warning and error, the result come like this:-
    No syslog records found – Error Details:
    Database Field mapping for at least one field could not be found.

    what might be the error and how can i solve this.
    i have another query also
    whenever i click on show events i want to see lastest logs currently it is showing log of starting date, can anyone help plz?

    thankx in advance

Leave a Reply