A processing method of exception log table

Abstract

The embodiment of the present invention relates to a method for processing an exception log table. The method includes: acquiring first exception data and corresponding first application program data, first user data, and first time data; using a hash algorithm to calculate the first hash Column code data; according to the first application program data, the first user data and the first hash code data, query the first matching exception log record in the exception log table; when the first matching exception log record is empty, perform a new exception log record Added processing; when the first matching exception log record is not empty, merge the exception log records. The method also includes performing exception log record maintenance processing and exception log record statistical processing on the exception log table. Using the embodiment of the present invention can reduce the number of abnormal log records and reduce the difficulty of maintenance. At the same time, two statistical processing procedures are added to facilitate data analysis of the abnormal log table by maintenance personnel.

Description

technical field [0001] The invention relates to the technical field of data information processing, in particular to a method for processing an exception log table. Background technique [0002] When a software product or software system encounters an error during operation, it usually uses automatic or manual methods to add exception log records to the exception log table to retain information related to the error. The content of the added exception log record includes at least application information related to the running error, user information related to the user, time information related to the time when the running error occurred, and exception information for describing the running error in detail. The engineer in charge of maintenance will analyze and solve the operation errors that occur according to the contents of the exception log table. However, in practical applications, we found that the conventional exception log table processing method has the following de...

AI Technical Summary

Problems solved by technology

However, in practical applications, we found that the conventional exception log table processing method has the following defects: 1) Every time an operation error occurs, an exception log record is added to the exception log table, even if the same application information, the same user In the case of information and the same exception information, the same type of exception records cannot be merged. On the one hand, there are too many records in the exception log table and the maintenance workload is large. On the other hand, it is not convenient to count similar exceptions; 2) There is no information related to exception resolution in the conventional exception log table, such as the information of the solver and the resolution time information, etc. The engineer in charge of maintenance needs to create a corresponding form and form processing flow to count the information related to exception resolution; 3 ) The processing method of conventional exception log table does not include data analysis and statistical functions. When engineers responsible for maintenance or customers want to know the operation status of software products or software systems, they also need to establish corresponding forms and form processing procedures to control Statistics related to health status

Images