Feedback
Did this article resolve your question/issue?

   

Article

Advice on parsing the database lg file for errors

« Go Back

Information

 
TitleAdvice on parsing the database lg file for errors
URL Nameparse-database-lg-file-for-errors
Article Number000188807
EnvironmentProduct: Progress OpenEdge
Version: All supported versions
OS: All supported platforms
Question/Problem Description
Advice on parsing the database lg file for errors
Error codes to parse database lg files for events needing attention
A set of error codes or messages to search database logs for to indicate issues or unwanted situations that need further analysis
Steps to Reproduce
Clarifying Information
Error Message
Defect/Enhancement Number
Cause
Resolution
The subject of database lg files has more recently been taken up by our Product Management under the following IDEAS section:

Implement control on database logging (.lg) verbosity and type of events to include/exclude? 

https://community.progress.com/community_groups/products_enhancements/i/openedge_database_enhancements_-_tell_us_what_youd_like_to_see/implement_control_on_database_logging_lg_verbosity_and_type_of_events_to_includeexclude

Ideas Database lg file Enhancement Suggestions:
  • For Progress to supply a tool (a bit like prolog except for lg file 'issues), which ties in with also being able to include/exclude event message types.
  • For the database lg file to be able to be created in a defined directory (like ubroker log files)
Consider weighing-in on the discussion.

2. ProTop is a very useful tool, the paid version monitors log files and has many other useful features. (https://demo.wss.com/)

3. Progress does not publish a specific set of error codes or messages to parse database logs for 'areas of concern'. 

The database .lg file has a column to indicate the severity of the message after the Task ID column:
 
[yy/mm/dd@hh:mm:ss.uuushhmm] P-nnnnnn T-nnnnnn S name nnn: (nnnnn) Message
  • I - Information; which can be ignored in initial scans and may be needed later when further investigating logged events.
  • W - Warning; these messages are sometimes ignored at peril because some error messages are treated like warnings in certain contexts and errors in other contexts.
  • F - Fatal error; are the easiest first parse for bearing in mind that less-critical messages like "cannot disable ai it is not enabled .." are flagged "F" which may or may not be critical depending on the context of the investigation.
Typically customers start with the "Fatal" Severity and build their list and groups of error messages to parse for up over time. Caution should be exercised when using error numbers as these change between versions . The following case-insensitive key words catch most instances requiring attention as a starting point.
 
denied, failed, failure, unable, cannot, dbkey, recid, delete, error, complete, exceed, open, index, attempted, bk*, found, semAdd, ABNORMAL, dead, died, lk, socket 

Consider reviewing the data in DLC/prohelp/msgdata (essentially the warnings for messages) which provide a more easily parsable set of text files for finding common key words in promsgs to search for.
Workaround
Notes
Last Modified Date11/20/2020 7:13 AM
Attachment 
Files
Disclaimer The origins of the information on this site may be internal or external to Progress Software Corporation (“Progress”). Progress Software Corporation makes all reasonable efforts to verify this information. However, the information provided is for your information only. Progress Software Corporation makes no explicit or implied claims to the validity of this information.

Any sample code provided on this site is not supported under any Progress support program or service. The sample code is provided on an "AS IS" basis. Progress makes no warranties, express or implied, and disclaims all implied warranties including, without limitation, the implied warranties of merchantability or of fitness for a particular purpose. The entire risk arising out of the use or performance of the sample code is borne by the user. In no event shall Progress, its employees, or anyone else involved in the creation, production, or delivery of the code be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the sample code, even if Progress has been advised of the possibility of such damages.