Information processing system and information processing method

The system efficiently extracts specific log data from mixed-format log files by using format information and extraction conditions, addressing the challenge of mixed log formats and reducing analysis time and complexity.

JP7577443B2Active Publication Date: 2024-11-05CANON KK
View PDF 5 Cites 0 Cited by

Patent Information

Application Number
JP2019229476
Authority / Receiving Office
JP · JP
Patent Type
Patents
Current Assignee / Owner
Filing Date
2019-12-19
Publication Date
2024-11-05
Estimated Expiration
2039-12-19

AI Technical Summary

Technical Problem

Existing log analysis systems struggle to reliably extract specific log data from mixed-format log files containing data from multiple different applications, OSs, and production equipment controllers, as they cannot effectively discriminate between different formats.

Method used

An information processing system that processes multiple log data from devices with different formats by using format information and extraction conditions to identify and extract specific log data, arranging the data based on received formats and conditions.

Benefits of technology

Enables reliable extraction of necessary log data for trouble analysis even from mixed-format log files, reducing effort and time required for log analysis and making it accessible to users with little specialized knowledge.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure 0007577443000001
    Figure 0007577443000001
  • Figure 0007577443000002
    Figure 0007577443000002
  • Figure 0007577443000003
    Figure 0007577443000003
Patent Text Reader

Abstract

To provide an information processing system configured to reliably extract log data required for trouble analysis even when one log file includes log data of different recording formats.SOLUTION: An information processing system includes: a production apparatus 4 to be subjected to abnormality monitoring or production management; a log server 1, an analysis server 2, and a work PC 3, which are control apparatuses constituting an abnormality monitoring apparatus or a production management apparatus. A multiple-format information recording unit 203 includes multiple-format information 202 storing determination conditions for specifying a recording format of log data. A multiple-extraction condition recording unit 205 records multiple-extraction condition information 204 for extracting specific log data or a specific field constituting the specific log data. An extraction processing unit 211 extracts the specific log data or the specific field constituting the specific log data from a log file in which a plurality of formats exist, on the basis of the multiple-format information and the multiple-extraction condition information.SELECTED DRAWING: Figure 1
Need to check novelty before this filing date? Find Prior Art

Description

[Technical field]

[0001] The present invention relates to an information processing system and an information processing method for extracting specific log data or specific fields constituting the specific log data from a log file in which log data having different recording formats are mixed. [Background technology]

[0002] In the operation and maintenance of systems such as production equipment including robotic arms, maintenance personnel may analyze log data that constitutes logs for investigations according to requests from end users or for various purposes. In general, logs are records of text data related to the operating status of the OS kernel, services, applications, etc. running on the system, associated with time information, etc.

[0003] The purpose of analyzing this kind of log is, for example, to identify the cause of a problem occurring in a production device, and for that purpose, the log analysis may be used to investigate the OS operation history, operation history, operation history, error occurrence history, etc. As a conventional technology related to trouble analysis aimed at reducing the effort and time required for log analysis work including log capture and extraction, for example, the technology disclosed in Patent Document 1 has been proposed.

[0004] In the configuration of Patent Document 1, the type of log, such as an OS log or an application log, imported for analysis is determined from the log file name, etc. In the configuration of Patent Document 1, the log type is identified from the log file name, etc., the contents of each field of the log are recognized based on format information predefined for each log type, and only the necessary fields are extracted according to the extraction conditions set by the user. [Prior art documents] [Patent documents]

[0005] [Patent Document 1] JP 2016-14980 A Summary of the Invention [Problem to be solved by the invention]

[0006] The technology of the above-mentioned Patent Document 1 is designed to identify the log type from, for example, the log file name. However, there are cases where the log server records logs having multiple different formats generated by multiple different applications, OSs, production equipment controllers, etc., in a state where the logs are merged into, for example, one log file. In such a log file containing multiple formats, for example, format discrimination based on the log type cannot be applied.

[0007] Therefore, an object of the present invention is to enable a user to reliably extract log data required for troubleshooting, etc., even when, for example, a single log file contains log data in multiple different recording formats. [Means for solving the problem]

[0008] One aspect of the present invention is an information processing system that processes multiple log data, including first log data having a first format output from a first device and second log data having a second format different from the first format, as a log file, comprising: a format information recording unit that stores format information including a judgment condition that specifies the format of the log file; an extraction condition recording unit that stores extraction conditions for extracting specific log data from the log file; and an extraction processing unit that extracts the specific log data from the log file based on the format information stored in the format information recording unit and the extraction conditions stored in the extraction condition recording unit. The plurality of log data are arranged in the order in which the information processing system received the plurality of log data. The information processing system is characterized in that: One aspect of the present invention is an information processing system that processes multiple log data, including first log data having a first format output from a first device and second log data output from a second device and having a second format different from the first format, as a single log file, and is characterized in having: a format information recording unit in which format information including a judgment condition that specifies the format of the single log file is stored; an extraction condition recording unit in which extraction conditions for extracting specific log data from the single log file are stored; and an extraction processing unit that extracts the specific log data from the single log file based on the format information stored in the format information recording unit and the extraction conditions stored in the extraction condition recording unit. One aspect of the present invention is an information processing system that processes a plurality of log data, including first log data having a first format output from a first device and second log data having a second format different from the first format, as a log file, the information processing system having a format information recording unit in which format information including a judgment condition that specifies a format of the log file is stored, an extraction condition recording unit in which extraction conditions for extracting specific log data from the log file are stored, and an extraction processing unit that extracts the specific log data from the log file based on the format information stored in the format information recording unit and the extraction conditions stored in the extraction condition recording unit, at least one of the plurality of log data has a plurality of field information, and the judgment condition specifies a format of one of the plurality of log data using at least one of the plurality of field information. The plurality of log data are arranged in the order in which the information processing system received the plurality of log data. The information processing system is characterized in that: One aspect of the present invention is an information processing system that processes multiple log data, including first log data having a first format output from a first device and second log data having a second format different from the first format, as a single log file, the information processing system having a format information recording unit in which format information including a determination condition that identifies the format of the single log file is stored, an extraction condition recording unit in which extraction conditions for extracting specific log data from the single log file are stored, and an extraction processing unit that extracts the specific log data from the single log file based on the format information stored in the format information recording unit and the extraction conditions stored in the extraction condition recording unit, wherein at least one of the multiple log data has multiple field information, and the determination condition identifies the format of one of the multiple log data using at least one of the multiple field information. One aspect of the present invention includes a receiving step in which an analytical server receives a log file including a plurality of log data including first log data having a first format output from a first device and second log data having a second format different from the first format output from a second device; a specifying step in which the analytical server specifies a format of the received log file using format information including a determination condition for specifying whether the format is the first format or the second format; and an extraction step in which the analytical server extracts log data having the specified format from the received log file using an extraction condition for extracting the specific log data from the log file. In the log file, the order in which the plurality of log data are arranged is the order in which the plurality of log data are received by a log recording unit that transmits the log file to an analysis server. The information processing method is characterized in that: Effect of the Invention

[0009] According to the above configuration, even if log data in a plurality of different recording formats is mixed in one log file, the log data required by the user for troubleshooting or the like can be reliably extracted. [Brief description of the drawings]

[0010] [Figure 1] 1 is a block diagram showing a system configuration according to a first embodiment of the present invention. [Diagram 2] FIG. 2 is a flowchart showing a main process of an analysis operation according to the first embodiment of the present invention. [Diagram 3] FIG. 4 is a flowchart showing a format information input process according to the first embodiment of the present invention. [Figure 4] FIG. 4 is a flowchart showing an extraction condition input process according to the first embodiment of the present invention. [Diagram 5] FIG. 4 is a flowchart illustrating a process of selecting a log to be analyzed according to the first embodiment of the present invention. [Figure 6] FIG. 4 is a flowchart illustrating a log analysis process according to the first embodiment of the present invention. [Figure 7] FIG. 4 is an explanatory diagram showing multiple format information according to the first embodiment of the present invention. [Figure 8] FIG. 4 is an explanatory diagram showing multiple extraction condition information according to the first embodiment of the present invention. [Figure 9] FIG. 4 is an explanatory diagram showing a record of a log used in the analysis process according to the first embodiment of the present invention. [Figure 10] FIG. 2 is an explanatory diagram illustrating an example of a hardware configuration and an analysis result display screen according to the first embodiment of the present invention. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS

[0011] Hereinafter, an embodiment of the present invention will be described with reference to the accompanying drawings. Note that the configurations shown below are merely examples, and those skilled in the art can appropriately change the detailed configurations, for example, without departing from the spirit of the present invention. Also, the numerical values ​​used in the present embodiment are merely examples of reference numerical values.

[0012] In this embodiment, an information processing system that performs log analysis in an abnormality monitoring system or production management system for a production line using a robot will be described. Fig. 1 shows a functional block configuration of an apparatus and a system to which the present invention can be applied.

[0013] The system of this embodiment includes a production device 4 that is the target of abnormality monitoring or production management, and three control devices constituting the abnormality monitoring device or production management device: a log server 1, an analysis server 2, and a work PC 3. The log server 1, analysis server 2, and work PC 3 (work terminal) can be configured from a control terminal in the form of a PC (personal computer), for example, with a CPU (described later) as the control device. Note that, although a configuration in which the control devices constituting the abnormality monitoring device or production management device are divided into three devices, the log server 1, the analysis server 2, and the work PC 3, any two or three of these may be configured from an integrated control terminal.

[0014] Fig. 10 shows the configuration of the control system of the work PC 3 equipped with a display 1001. However, the configuration of the control system centered on the CPU 601 at the bottom of Fig. 10 is common to the log server 1 and the analysis server 2. The control system as shown in Fig. 10 can be realized, for example, by a so-called PC form implementation.

[0015] The control system of FIG. 10 can be configured by a CPU 601 as a main control means, a ROM 602 as a storage device, and PC hardware including a RAM 603. The ROM 602 can store a control program and constant information for the CPU 601 for implementing the processing procedures of log analysis and extraction of this embodiment. The RAM 603 is used as a work area for the CPU 601 when executing the control procedures. An external storage device (not shown) is also connected to the control system of FIG. 10. This external storage device can be configured by an HDD, SSD, or an external storage device of another system mounted on a network.

[0016] The control program of the CPU 601 for implementing the processing procedure of log analysis and extraction of this embodiment is stored in a storage unit such as the external storage device or the EEPROM area of ​​the ROM 602. In this case, the control program of the CPU 601 for implementing the control procedure of this embodiment can be supplied to each of the above storage units via the network interface 608 and updated to a new (different) program. Alternatively, the control program of the CPU 601 for implementing the control procedure described below can be supplied to each of the above storage units via various storage means such as magnetic disks, optical disks, and flash memories and drive devices therefor and can update the contents. Various storage means, storage units, and storage devices in a state in which the control program of the CPU 601 for implementing the control procedure of this embodiment is stored constitute a computer-readable recording medium storing the control procedure of the present invention.

[0017] The network interface 608 can be configured using a communication standard for wired communication such as IEEE 802.3, or wireless communication such as IEEE 802.11 and 802.15. Through the network interface 608 and a network 609, the CPU 601 can communicate with another device 1104. If the device in FIG. 10 is a work PC 3, the other device 1104 corresponds to, for example, a log server 1 and an analysis server 2, and these three control devices can communicate with each other through the network 609.

[0018] 10 includes a user interface device 1002 (UI device). The user interface device 1002 is configured as a GUI device including, for example, an LCD display, a keyboard, a pointing device (mouse, joystick, etc.), etc. Through this user interface device 1002, input settings for multiple format information 202 and multiple extraction condition information 204, which will be described later, can be performed.

[0019] 1 again, the log server 1 has a log 101. In this example, three logs 101 are shown using a symbol like an HDD. The three log files constituting the log 101 record log data related to the operating status of the three production devices 41, 42, and 43 constituting the production device 4, respectively.

[0020] The production devices 41 to 43 are each composed of, for example, a robot 401 and a controller 402 that controls the robot 401. Furthermore, the robot 401 is composed of a robot arm and a hand that handles a workpiece, and the controller 402 controls the robot arm and hand, respectively, to operate the workpiece. In the following, the control unit that constitutes the controller 402 may be referred to separately as a control means for the robot arm and hand.

[0021] The analysis server 2 comprises a log recording unit 201, a multiple format information recording unit 203, a multiple extraction condition recording unit 205, and an extraction result recording unit 206. The analysis server 2 also comprises a log import unit 207, a multiple format information setting unit 208, a format determination unit 209, a multiple extraction condition setting unit 210, and an extraction processing unit 211. Of these, each processing unit is realized by, for example, the CPU 601 executing a control program in which a control procedure described below is written. Also, each recording unit is constituted by, for example, storage means such as the ROM 602 or RAM 603 described below.

[0022] The multiple format information recording unit 203 is configured, for example, by a storage area arranged in a memory (for example, ROM 602 or RAM 603 described below). The multiple format information recording unit 203 stores multiple format information 202. The multiple format information 202 is used to control the extraction (or search) of log data. The multiple extraction condition recording unit 205 is configured, for example, by a storage area arranged in a memory (for example, RAM 603). The multiple extraction condition recording unit 205 stores multiple extraction condition information 204. This multiple extraction condition information 204 is also used to control the extraction (or search) of log data.

[0023] The work PC 3 comprises a multiple format information input unit 301, a multiple extraction condition input unit 302, an analysis target log selection unit 303, an analysis process execution instruction unit 304, an input / output display unit 305, etc. These input units, selection units, instruction units, and display units are composed of a user interface using hardware such as a display, keyboard, and pointing device (see FIG. 10 described later).

[0024] [Log Server] The log server 1 records logs 101 (1011 to 1013) output by the controller 402 that controls the robots 401 operating in the production devices 41 to 43, respectively, for the purpose of identifying the cause of trouble occurring in the production devices 4. Log data recorded in the log 101 includes a robot operation log and an error occurrence history log of the production devices 4. The robot operation log includes information such as the type of arm operation, command pulse values ​​to the motors of each axis of the robot arm and feedback pulse values ​​obtained from the encoder, three-dimensional coordinate information of the robot hand position, force sensor values, and the opening and closing amount of the fingers of the robot hand.

[0025] A robot 401 is operating in each of the production devices 41 to 43, and the log server 1 records separate logs 1011 to 1013 for each production device 4. In this embodiment, in these log files, there is a possibility that a plurality of different types of robots 401 exist in one production device 4. Therefore, the log data recorded in the logs 1011 to 1013 has a mixture of different formats. Furthermore, the arms and hands that constitute the robot are also manufactured by different manufacturers and vendors, and the formats of the log data they generate may be different.

[0026] In this embodiment, it is assumed that there are multiple robots 401, and each robot or its arm or hand outputs log data in a different format. The log server 1 outputs the log data, which has a mixture of formats, in one log file for each of the production devices 41 to 43 and in the order of the time of receipt. In the analysis of a problem with the production device 4 that controls the robot 401, the order of operations and the contents of operations of the robot 401 are important. For this reason, the controller 402 that controls the robot 401 records time stamps generated as log data. Even if there is a slight discrepancy, the server records the log data in the order in which it was received, so that logging (log data recording) is performed in the above format.

[0027] For example, a syslog protocol / server can be used for the above-mentioned log recording (logging). For example, a syslog server is operated in the log server 1. This syslog server adds log data received from the production devices 41-43 via the network 609 (FIG. 10) or the like via the syslog protocol to logs 1011-1013 in the order in which it was received.

[0028] [Analysis Server] The analytical server 2 comprises a log recording unit 201, a multiple format information recording unit 203, a multiple extraction condition recording unit 205, and an extraction result recording unit 206. The analytical server 2 also comprises a log import unit 207, a multiple format information setting unit 208, a format determination unit 209, a multiple extraction condition setting unit 210, and an extraction processing unit 211.

[0029] The log recording unit 201 imports and records, for example, a log file including the log 101 to be analyzed from among the log files (logs 1011 to 1013) recorded in the log server 1. In addition to the syslog protocol, the log file can be transferred from the log server 1 to the analysis server 2 using ftp, sftp, http, https, or other protocols.

[0030] In this embodiment, the analysis server 2 and the log server 1 are configured as separate entities, but the analysis server 2 and the log server 1 may be an integrated control terminal. In that case, the analysis server 2 receives log data from each of the production devices 4, for example, by a syslog protocol or the like. The log recording unit 201 is configured by a HDD or the like for recording log files (logs 1011 to 1013).

[0031] The multiple format information recording unit 203 records multiple log formats for each log file type and multiple format information 202 that is a condition for determining the format. The multiple extraction condition recording unit 205 records multiple extraction condition information 204 at the time of extraction processing for each of the multiple log formats included in the log file to be analyzed. The extraction result recording unit 206 records the result of the extraction processing unit 211 extracting data necessary for analysis. The log import unit 207 imports the log file to be analyzed from the log recording unit 201 and expands it on the memory. The multiple format information setting unit 208 reads out and sets the multiple format information 202 corresponding to the type of the log file to be analyzed from the multiple format information recording unit 203.

[0032] The format determination unit 209 performs a process of determining which format, out of the multiple formats set in the multiple format information setting unit 208, each log included in the log file taken in by the log taking unit 207 corresponds to.

[0033] The multiple extraction condition setting unit 210 reads and sets multiple extraction condition information 204 corresponding to the type of the log file to be analyzed from the multiple extraction condition recording unit 205. Then, from the read multiple extraction condition information 204, it identifies extraction conditions that correspond to the log format determined by the format determination unit 209, and determines the data fields to be extracted from each log to be analyzed.

[0034] The extraction processing unit 211 performs log extraction processing based on the extraction conditions set in the multiple extraction condition setting unit 210. The extracted results are stored in the extraction result recording unit 206. The extraction results recorded in the extraction result recording unit 206 can be output by a display 1001 (FIG. 10) or a printer. The user can use the extraction results that have been output in accordance with the specified extraction conditions to monitor the operating state of the production equipment 4 or to perform production management tasks.

[0035] [Work PC] The work PC 3 is composed of a multiple format information input unit 301, a multiple extraction condition input unit 302, an analysis target log selection unit 303, an analysis process execution instruction unit 304, and an input / output display unit 305. Although the work PC 3 is shown in Fig. 1 as being separate from the analysis server 2, the work PC 3 may be, for example, a control terminal integrated with the analysis server 2. Alternatively, the function of the work PC 3 may be implemented in the log server 1.

[0036] In the multiple format information input unit 301, for example, an analysis operator (user) inputs multiple format information 202 for each log file to be analyzed to the multiple format information recording unit 203 of the analysis server 2. However, the multiple format information 202 does not necessarily have to be input manually by the user. For example, the multiple format information 202 may be input by reading file information such as a database file (file data itself, or a pointer to the database file: file name, etc.).

[0037] In the multiple extraction condition input section 302 , the analysis operator inputs the multiple extraction condition information 204 for each log file to be analyzed and for each format to the multiple extraction condition recording section 205 of the analysis server 2 .

[0038] An analysis operator selects a log file to be analyzed using the analysis target log selection unit 303. The operator can use the analysis target log selection unit 303 to specify the name of the log file to be analyzed.

[0039] The analysis process execution instruction unit 304 instructs the analysis server 2 to execute a process to extract information required for analysis from the log, based on the information input and selected by the user in the multiple format information input unit 301, the multiple extraction condition input unit 302, and the analysis target log selection unit 303.

[0040] The input / output display section 305 displays a screen for the analyst to input information in the multiple format information input section 301, the multiple extraction condition input section 302, and the analysis target log selection section 303, as well as a screen for displaying the analysis results.

[0041] The process steps of the log extraction or analysis system of this embodiment, particularly the analysis server, will be described in detail below with reference to FIGS.

[0042] [Main processing] 2 shows the flow of the main process for the trouble analysis support of this embodiment. In step S101, an operator who performs log analysis accesses the analysis server 2 from the work PC 3, and causes the input / output display unit 305 of the work PC 3 to display a main screen for inputting information for the analysis work.

[0043] In step S102, the worker selects an item corresponding to a process to be performed in log analysis from, for example, a work menu displayed on the main screen of the work PC 3. The work menu includes, for example, menu items such as (a) input format, (b) input extraction conditions, (c) select log to be analyzed, (d) execute analysis, and (e) end analysis as items corresponding to selectable processes. When any of the menu items (a), (b), (c), (d), or (e) is selected, the analysis server 2 executes the process corresponding to the selected item.

[0044] When the item (a) format input is selected from the menu of the main screen, a format setting screen is displayed in step S103 of Fig. 2. This format setting screen is displayed, for example, on the display 1001 of the work PC 3 on which the user is working. Here, the multiple format information input unit 301 of the work PC 3 transfers the information input to the format setting screen of the work PC 3 to the analysis server 2. The analysis server 2 performs a process of recording the received format information in the multiple format information recording unit 203 as log format definition information (202). The format information input process will be described later with reference to Fig. 3.

[0045] The input of the format in step S103 may be performed at least once prior to the log extraction (search) process, or may be performed immediately before the analysis process.

[0046] Furthermore, when the item (b) Extraction Condition Input is selected from the menu of the main screen, an extraction condition setting screen is displayed in step S104 of FIG. 2. This extraction condition setting screen is displayed, for example, on the display 1001 of the work PC 3 on which the user is working. The multiple extraction conditions input unit 302 of the work PC 3 transfers the information entered on the extraction condition setting screen to the analysis server 2. The analysis server 2 executes a process (FIG. 4 described later) of recording the extraction conditions (204) in the multiple extraction conditions recording unit 205. It is sufficient to input the extraction conditions at least once prior to the log extraction (search) process. Alternatively, the extraction conditions may be input immediately before the analysis work is performed.

[0047] Furthermore, when the item (c) "Select Log to be Analyzed" is selected from the menu of the main screen, an analysis target log selection screen is displayed in step S105 of FIG. 2. This analysis target log selection screen is displayed, for example, on the display 1001 of the work PC 3 on which the user is working. When a target log file is specified on this analysis target log selection screen, the analysis target log selection unit 303 of the work PC 3 transmits identification information of the log file to the analysis server 2. In response to this, the analysis server 2 executes a process (FIG. 5 described later) of downloading the log files (1011-1013) to be analyzed from the log server 1 and recording them in the log recording unit 201. The downloaded log files (1011-1013) are recorded in the log recording unit 201, for example, in the order in which they were downloaded.

[0048] Furthermore, when the item (d) "Execute Analysis" is selected from the menu of the main screen, in step S106 of FIG. 2, the work PC 3 instructs the analysis server 2 to execute analysis. When the instruction to execute analysis is given, the analysis server 2 performs a log data extraction process (see FIG. 6 onwards, described later) based on the format information and extraction condition information stored in the multiple format information recording unit 203 and the multiple extraction condition recording unit 205. The desired log data extracted from the log data is recorded in the extraction result recording unit 206. The target of this extraction process is a group of log data downloaded from the log server 1 and recorded in the log recording unit 201 in a state where multiple different formats are mixed.

[0049] Furthermore, in step S107 in FIG. 2, the extraction results are read out from the extraction result recording unit 206 of the analytical server 2 and displayed on the main screen or sub-screen of the display 1001 of the work PC 3.

[0050] In step S108 of FIG. 2, it is determined whether the user ends the analysis work on the work PC 3. If the analysis is to be continued, the process returns to step S102 and the above process is repeated. If the analysis is to be ended, the user selects, for example, item (e) End Analysis from the menu on the main screen in step S109. This causes the analysis server 2 and the work PC 3 to end communication, and the analysis work ends. Any communication protocol can be used for the communication required for the collaboration between the analysis server 2 and the work PC 3. As an example, a communication form in which a WEB page describing a user interface including the menu of the main screen is provided by the HTTP or HTTPS server of the analysis server 2, and the work PC 3 accesses this WEB page, can be considered.

[0051] [Format Input] Fig. 3 shows the flow of processing in the multiple format information input section 301. The processing in Fig. 3 is executed when the "format input" item is selected from the main screen. This processing prepares multiple format information 202, that is, inputs the multiple format information 202 input on the format input screen to the multiple format information recording section 203 of the analysis server 2. This input of format information may be performed at least once prior to the log extraction (search) processing. Also, the work procedure may involve inputting the information immediately before performing the analysis work.

[0052] In step S201 of FIG. 3, when registering format information contained in a log file that is a candidate for an analysis target, the name of the log file to be analyzed, whose format is to be registered, is input.

[0053] The format used for this log file name may be, for example, the full path name (file name) of the log file on the log server 1. Alternatively, the log file name may use a format that describes a network resource, such as a URL / URI format. The URL / URI format has the potential to express not only the name of the log file, but also its type and format.

[0054] In step S202, the name of the format is registered when registering the log format. In this embodiment, multiple formats can be defined for one log file. For this reason, the name of the format is registered in order to identify one specific format. In step S203, log field information is registered for the format with the name registered in step S202. This field information refers to the name of the data when separated by log delimiters (space, TAB, comma, etc.).

[0055] Fig. 7 shows multiple format information 202 to be stored in multiple format information recording unit 203. In Fig. 7, the full path name (file name) of a log file in log server 1 is used as log file name 2021 of multiple format information 202, for example. Here, a directory (folder) such as / var / log in log file name 2021 is a log storage location that is generally used in the syslog method.

[0056] 7, the items of field information 2023 that can be written include definition information for "delimiter", "data 1", "data 2", ... "data N". In the example of field information in the table of FIG. 7, data for each field is stored in the log data separated by a predetermined delimiter (space, TAB, comma, etc.). Also, in FIG. 7, the format name 2022 of the multiple format information stores the log format name using a mnemonic such as "C1...", "C2...", "C3..." ....

[0057] 7, the definition that "Data 1" of field information 2023 is time stamp information such as "date" and "Data 2" is time is stored. Generally, the time stamp in the log data is generated by the device or controller that generated the log data. Alternatively, the log server 1 may add a time stamp to the log data to record the date and time when the log data was received by a communication protocol such as syslog.

[0058] In this case, for example, a sort control is possible in which the timestamp at which the log server 1 receives the log data is used as a sort key, and the extracted log data is sorted in the order in which the log server 1 receives the log data. Such a sort control has the effect of improving the browsing of the log data when a plurality of log files are downloaded to the log recording unit 201. Of course, a sort control can also be performed in which the timestamp in the log data ("DATA 1" and "DATA 2" in FIG. 7) is used as a sort key and the extracted log data is sorted. Note that not only the timestamp but also all fields shown in the multiple format information 202 can be specified as the sort key. For example, it is conceivable to make it possible to specify identification information such as a controller name or a format name as a sort key. Of course, the sort key is not limited to a single one, and a configuration in which multiple types of sort keys can be specified with priority order of action may be used.

[0059] In step S204, the format determination conditions 2024 (FIG. 7) are set with respect to the format information input in the above steps S201, S202, and S203. The format determination conditions will be described.

[0060] In this embodiment, it is assumed that log data is extracted when multiple formats of logs are mixed in one log file. Therefore, it is necessary to determine which format the log included in the log file corresponds to among the multiple formats registered in steps S201, S202, and S203. Therefore, a format determination condition is set for each format name (2022) as a condition for format determination.

[0061] For example, a possible setting example of the format determination condition 2024 is to use the field information set in step S203. When the log to be subjected to format determination is divided by commas, the format determination condition 2024 is registered such that if the first data is a character string "A", then format A is selected, if the first data is a character string "B", then format B is selected, and so on.

[0062] In the example of FIG. 7, the format determination condition 2024 for the format name “C1 arm log” of the multiple format information 202 is when data 3 is “C1” and (AND) and data 4 is “6-axis robot” when the log is divided by commas.

[0063] In step S205, it is determined whether or not the user has other format information to register. If there is other format information to register, the process returns to step S201, and the above operation is repeated to register other format information. If there is no other format information to register, the process proceeds to step S206. In step S206, a process is executed to record the multiple format information 202 as shown in FIG. 7 set in steps S201 to 205 in the multiple format information recording unit 203 of the analysis server 2.

[0064] [Enter extraction conditions] Fig. 4 shows the flow of the input process of extraction conditions by the multiple extraction condition input unit 302 of the work PC 3. The process of Fig. 4 is executed when the item (b) "Extraction condition input" is selected from the main screen. In this process, the information of the extraction conditions is transferred to the multiple extraction condition recording unit 205 of the analysis server 2, and registered as multiple extraction condition information 204. This input process of the extraction conditions needs to be performed at least once prior to the log extraction (search) process. It may also be a work procedure in which the extraction conditions are input immediately before the analysis work is performed.

[0065] In step S301, the operator selects and inputs a log file name. The dialog for inputting the log file name is configured to select from among the log file names defined in the multiple format information 202 input to the multiple format information recording unit 203 by, for example, the input process of the format definition information in Fig. 3. Alternatively, a text box may be used to allow the user to freely input the log file name by inputting a character string.

[0066] 7, the multiple format information 202 includes the log file names "st1_daily_robot_log" and "st2_daily_robot_log." In this case, the user is prompted to select one of these log file names as the log file name to be extracted.

[0067] In step S302, the operator is prompted to select a format name from among the format names (2022) defined in the multiple format information 202 input to the multiple format information recording unit 203 by the processing of the format input unit in FIG.

[0068] Here, as an example, an explanation will be given using the multiple format information 202 in the table of Fig. 7. In Fig. 7, four format names, "C1 arm log", "C2 hand log", "C3 arm log", and "C4 hand log", are defined for a log file name (2021) called "st1_daily_robot_log". If the log file name "st1_daily_robot_log" has been selected in the previous step S301, one of these four format names is to be selected.

[0069] Next, in step S303, extraction field information is selected. This extraction field information is selected from the field information of the log data specified from the log file name (2021) and format name (2022) information selected in steps S301 and S302. For example, in the multiple format information 202 in Fig. 7, a case will be described where the log file name is selected as "st1_daily_robot_log" in step S301 and the format name is selected as "C1 arm log" in step S302.

[0070] From the table in FIG. 7, any of the field information whose log file name (2021) is “st1_daily_robot_log” and whose format name (2022) is “C1 arm log” is uniquely identified. In the case of “C1 arm log”, the field information (2023) has “date”, “time”, “controller number”, “robot type”, “command type”, etc., separated by commas. Furthermore, in the case of “C1 arm log”, the field information (2023) consists of a total of 11 data items, including “X coordinate”, “Y coordinate”, “Z coordinate”, “X direction angle”, “Y coordinate angle”, and “Z direction angle”. The user is prompted to select the items to be extracted from these 11 field data when analyzing the log. If only the eight data items of “date”, “time”, “controller number”, “robot type”, “command type”, “X coordinate”, “Y coordinate”, and “Z coordinate” are to be extracted, these eight item names are selected. In order to specify the "date" and "time" timestamps, it is preferable to provide a user interface that allows the user to specify the time interval to be analyzed, as in the example of FIG.

[0071] As a result of this selection, the multiple extraction condition information 204 recorded in the multiple extraction condition recording unit 205 of the analysis server 2 has the configuration shown in Fig. 8. In the multiple extraction condition information 204 in Fig. 8, a "log file name" (2041), an "analysis target section" (2042), a "format name" (2043), and an "extraction item" (2044) are saved.

[0072] In step S304, the analysis target section is specified. This analysis target section is the range of dates and times when the log file is analyzed. In the example of the multiple extraction condition information 204 in FIG. 8, the "analysis target section" (2042) is specified in a format such as "date, time" of the log. In this example, it is shown that the log data corresponding to the 10-minute section from 2017 / 01 / 1, 12:00:00 to 2017 / 01 / 1, 12:10:00 is to be extracted. Note that if the log data contains a timestamp of the log data acquisition time on the log server, the extraction target related to the log data acquisition time can be specified in a similar format.

[0073] In step S305 of FIG. 4, the user is prompted to determine whether there are other extraction conditions to be input. If there are other extraction conditions to be input, the process returns to step S301, and the user is prompted to input extraction conditions again by the above process. If there are no other extraction conditions to be input, the process proceeds to step S306, which will be described later. In step S306, the multiple extraction condition information 204 as shown in FIG. 8, which was input in steps S301 to S305, is transferred to the analyzing server 2. The analyzing server 2 records the received extraction condition information in the multiple extraction condition recording unit 205.

[0074] [Select logs to analyze] 5 shows the flow of the selection process by the analysis target log selection unit 303 of the work PC 3. This process is executed when the "analysis target log selection" item is selected from the main screen, and here, the worker (user) selects the log file to be analyzed and inputs the selected log file to the log recording unit 201 of the analysis server 2.

[0075] In step S401, the operator selects the log file name to be analyzed. This log file name is selected from among the log file names defined in the multiple format information 202 input to the multiple format information recording unit 203 by the processing of the format input unit. In the example of Fig. 7, the log file names "st1_daily_robot_log" and "st2_daily_robot_log" are defined in the multiple format information 202, so the operator is to select from among these log file names.

[0076] In step S402, the name of the log file to be analyzed selected by the user in step S401 is transferred to the analysis server 2. In response to this, the analysis server 2 downloads the log file having the received log file name from the log server 1, and records it in the log recording unit 201.

[0077] [Run Analysis] In this process, when item (d) "Analysis" is selected from the main screen, analysis process execution instructing unit 304 of work PC 3 executes analysis process. When the "Analysis" item is selected in this manner, work PC 3 instructs analysis server 2 to execute log analysis. Having received the instruction to execute analysis, analysis server 2 executes log analysis process as follows.

[0078] [Log analysis process] 6 shows the flow of an analysis process for extracting mixed-format log data recorded in the log recording unit 201 according to information in the multiple format information recording unit 203 (format information recording unit) and the multiple extraction condition recording unit 205 (extraction condition recording unit) on the analysis server 2. At this stage, the multiple format information recording unit 203 (format information recording unit) stores information related to the recording format of the log data, and the multiple extraction condition recording unit 205 (extraction condition recording unit) stores the extraction conditions specified by the user. The log extracted according to these two pieces of information is written to the extraction result recording unit 206.

[0079] 6, log data is read from the log recording unit 201 on the analysis server 2 into the log import unit 207. In step S502, multiple format information 202 corresponding to the log file name to be analyzed is read from the multiple format information recording unit 203 and set in the multiple format information setting unit 208.

[0080] For example, in the example of multiple format information 202 in FIG. 7, when the log file name to be analyzed is “st1_daily_robot_log”, the format information corresponding to that file name is read and set in the multiple format information setting unit 208 .

[0081] In step S503, multiple extraction conditions corresponding to the log file name to be analyzed and each format included in the log file are read from the multiple extraction condition recording unit 205 and set in the multiple extraction condition setting unit 210. For example, in the example of the multiple extraction condition information 204 in Fig. 8, the log file name to be analyzed is assumed to be "st1_daily_robot_log". In this case, the extraction condition corresponding to that file name is read from the multiple extraction condition information 204 in the table in Fig. 8 and set in the multiple extraction condition setting unit 210.

[0082] In step S504, one record is extracted in sequence from the top of the log data read into the log import unit 207 in step S501. In this embodiment, the log data included in the log file to be analyzed is written with a new line for each record.

[0083] In step S505, the format determination unit 209 performs format determination processing on one record of the log extracted in step S504, based on the information set in the multiple format information setting unit 208 in step S502.

[0084] For example, in the multiple format information 202 in Fig. 7, it is assumed that the log file to be analyzed is "st1_daily_robot_log" and the record extracted in step S504 is record 901 in Fig. 9. In this case, it is determined which format of the multiple format information 202 in Fig. 7 the extracted record 901 corresponds to.

[0085] In the multiple format information 202 in FIG. 7, four formats, "C1 arm log" to "C4 hand log", are defined. Here, the determination is made in order starting from "C1 arm log". At this time, if the delimiter for "C1 arm log" is defined to be a comma, for example, one record of the extracted log data in FIG. 9 is divided into fields separated by a comma. After this field division, the format determination condition for "C1 arm log" is referenced. In this case, the determination condition for "C1 arm log" is Data 3="C1" AND Data 4="6-axis arm". The third field obtained by dividing the record by a comma corresponds to Data 4, and the fourth field corresponds to Data 4, respectively, so the values ​​of Data 3 and Data 4 are confirmed.

[0086] For example, in the case of record 901 shown in Fig. 9, data 3 is "C1" and data 4="6-axis arm", which satisfies the judgment condition of "C1 arm log" in Fig. 7. Therefore, record 901 of this log data is judged to be "C1 arm log".

[0087] Next, in step S506, the extraction conditions for the log corresponding to the format determined in step S505 are identified. As the extraction conditions, the extraction conditions set in the multiple extraction condition setting unit 210 in step S503 are used. Here, in the example of the multiple extraction condition information 204 in FIG. 8, it is assumed that the format determined in step S505 is "C1 arm log."

[0088] Referring to the row corresponding to "C1 arm log" from the multiple extraction condition information 204 in Fig. 8, the extraction condition includes eight extraction items: "date", "time", "controller number", "robot type", "command type", "X coordinate", "Y coordinate", and "Z coordinate". Furthermore, the multiple extraction condition information 204 in Fig. 8 describes analysis section information in the log file to be analyzed. Therefore, the above eight extraction items and analysis section information become the extraction conditions for "C1 arm log".

[0089] In step S507, a log extraction process is performed using the format information determined in step S505 and the extraction conditions specified in step S506. In the example of the multiple format information 202 in FIG. 7 and the multiple extraction condition information 204 in FIG. 8, one record extracted in step S504 is record 901 in FIG. 9, and the format is "C1 arm log". The format information and extraction conditions of record 901 have already been specified in steps S505 and S506. Therefore, here, record 901 is divided into fields separated by commas according to the format information of "C1 arm log", and the divided information is stored as data 1 to data 10. At this stage, the type of information of the data in each field has been specified by the determined format information, such as data 1 = date, data 2 = time, etc.

[0090] Next, only the necessary items are extracted based on the extraction conditions for "C1 arm log." As shown above, in the extraction conditions of Figure 8, the extraction conditions for "C1 arm log" are "date," "time," "controller number," "robot type," "command type," "X coordinate," "Y coordinate," and "Z coordinate." Here, since data 1 of record 901 = date, data 1 corresponds to the extraction items, and this field is extracted. Also, since data 2 = time, data 2 is also determined to be a field to be extracted. Similarly, the fields to be extracted are identified for data 3 to data 10.

[0091] As a result, in this example, eight pieces of data, ie, data 1, 2, 3, 4, 5, 6, 7, and 8, can be identified as extraction items, and these eight pieces of data are extracted from record 901.

[0092] In step S508, the extraction result of step S507 is recorded in the extraction result recording unit 206 of the analytical server 2. In step S509, it is determined whether there are any other records to be analyzed. This determination is made, for example, by determining whether there are any unprocessed rows of log data remaining in the log import unit 207.

[0093] In step S504, one record is extracted from the top of the log data read into log import unit 207 in step S501 above, and analysis is performed. If the next record still exists in step S509, the process returns to step S504 and analyzes the next record. If it is confirmed whether or not there is a next record, and there is no unprocessed log data record, it is determined that processing of all records has been completed, and the process proceeds to step S510, which will be described later.

[0094] In step S510, the extraction results recorded in the extraction result recording unit 206 of the analysis server 2 in step S507 by the processing of steps S501 to S509 are output to the display 1001 of the work PC 3. FIG. 10 shows a display screen of the extraction results output to the display 1001 of the work PC 3. The analysis process is executed, and the results of extracting only the items necessary for the analysis are displayed on the main screen of the work PC 3 from the analysis server 2, and the analysis result display screen is displayed on the display 1001 as shown in FIG. 10. The worker can refer to the analysis result display screen displayed on the display 1001 and identify, for example, the cause of a problem. Although the log before extraction contains a lot of information that is not necessary for the problem analysis, according to the extraction process of this embodiment, the worker can select any item that he or she wants to refer to and extract only the necessary items. The information output to the analysis result display screen may be output to a file in CSV format or the like so that it can be saved.

[0095] As described above, according to this embodiment, the format of the log can be determined by the format determination unit 209 using the multiple format information 202 and multiple extraction condition information 204 recorded in the analysis server 2. Therefore, even if a log file contains a mixture of multiple different recording formats, desired log data can be extracted by specifying items required for analysis for each different format.

[0096] The extracted results can be displayed on a display 1001, for example, as shown in FIG. 10. The operator (user) can view log data relating to a desired device or its components in a desired section, extracted from a log file according to specified extraction conditions. This allows for efficient troubleshooting of production equipment in a short time. Only the items necessary for troubleshooting a robot production equipment are extracted on the display 1001, so the user (operator) performing the troubleshooting does not need to manually extract or edit logs.

[0097] According to this embodiment, it is possible to reduce the time and effort required for analyzing production equipment troubles, particularly log analysis including log import and extraction, etc. Furthermore, specialized knowledge that was previously required of users for log analysis including the above log extraction is no longer necessary, and efficient log analysis can be realized that is easy to handle even for users with little specialized knowledge or experience.

[0098] In addition, in a configuration in which a sort control unit that sorts (rearranges) the extracted log data using a desired sort key is provided, the user (operator) can view the log data in a form sorted in a preferred order. This significantly improves the readability of the log data. In this case, if the data is arranged in the log data, data in any field can be specified as a sort key. For example, if a field of the time acquired by the log server 1 is included in the log data, the log server 1 can sort the extracted log data using the time order (transfer order) as a sort key. By sorting the log data by the server acquisition time, the log data can be rearranged in an easy-to-handle order, particularly from a state in which multiple log files (1011 to 1013: FIG. 1) are merged, and the viewability and readability of the log data can be significantly improved.

[0099] In the above, the extracted log data is output to a display and the user analyzes the contents. However, it is also possible to go further and have a control means such as a CPU monitor the extracted log data for abnormalities. In that case, for example, the analysis server 2 can extract real-time log data every time a log is acquired by the log server 1, and the control means can monitor the numerical values ​​of a predetermined field of the extracted log data. If an abnormality is detected in the numerical values ​​of a predetermined field of the extracted log data, it is possible to control the display or audio output means to generate an alarm or to send an emergency stop signal to the controller of the production device. In addition, a display is exemplified as an output unit for the extracted log data, but any output unit such as a printing means or audio output means (printer, speaker, etc.) may be used as the output unit for the log data.

[0100] The present invention can be realized by supplying a program that realizes one or more functions of the above-mentioned embodiments to a system or device via a network or a storage medium, and having one or more processors in the computer of the system or device read and execute the program. It can also be realized by a circuit (e.g., ASIC) that realizes one or more functions. [Explanation of symbols]

[0101] 1: log server, 2: analysis server, 3: work PC, 4: production equipment, 101: log, 201: log recording unit, 202: multiple format information, 203: multiple format information recording unit, 204: multiple extraction condition information, 205: multiple extraction condition recording unit, 206: extraction result recording unit, 207: log import unit, 208: multiple format information setting unit, 209: format determination unit, 210: multiple extraction condition setting unit, 211: extraction processing unit, 301: multiple format information input unit, 302: multiple extraction condition input unit, 303: analysis target log selection unit, 304: analysis process execution instruction unit, 305: input / output display unit, 401: robot, 402: controller, 901: record, 1001: display.

Claims

1. An information processing system that processes a plurality of log data, including first log data having a first format output from a first device, and second log data having a second format output from a second device, different from the first format, together as a log file, comprising: a format information recording section in which format information including a determination condition for specifying a format of the log file is stored; an extraction condition recording section in which extraction conditions for extracting specific log data from the log file are stored; an extraction processing unit that extracts the specific log data from the log file based on the format information stored in the format information recording unit and the extraction conditions stored in the extraction condition recording unit; having An information processing system, comprising: an information processing system arranged in order of receiving the plurality of log data.

2. At least one of the plurality of log data has a plurality of field information, 2. The information processing system according to claim 1, wherein the judgment condition includes a condition for identifying a format of one of the plurality of log data using at least one of the plurality of fields contained in the plurality of log data having the plurality of field information.

3. An information processing system for processing a plurality of log data, including first log data having a first format output from a first device and second log data having a second format different from the first format output from a second device, as a single log file, comprising: a format information recording section in which format information including a determination condition for specifying a format of the one log file is stored; an extraction condition recording section in which extraction conditions for extracting specific log data from the one log file are stored; an extraction processing unit that extracts the specific log data from the one log file based on the format information stored in the format information recording unit and the extraction conditions stored in the extraction condition recording unit; An information processing system comprising:

4. The information processing system according to claim 3 , wherein the plurality of log data are arranged in an order in which the information processing system receives the plurality of log data.

5. An information processing system that processes a plurality of log data, including first log data having a first format output from a first device, and second log data having a second format output from a second device, different from the first format, together as a log file, comprising: a format information recording section in which format information including a determination condition for specifying a format of the log file is stored; an extraction condition recording section in which extraction conditions for extracting specific log data from the log file are stored; an extraction processing unit that extracts the specific log data from the log file based on the format information stored in the format information recording unit and the extraction conditions stored in the extraction condition recording unit, At least one of the plurality of log data has a plurality of field information, The determination condition identifies one format of the plurality of log data by using at least one of the plurality of field information; An information processing system, comprising: an information processing system arranged in order of receiving the plurality of log data.

6. An information processing system for processing a plurality of log data, including first log data having a first format output from a first device and second log data having a second format different from the first format output from a second device, as a single log file, comprising: a format information recording section in which format information including a determination condition for specifying a format of the one log file is stored; an extraction condition recording section in which extraction conditions for extracting specific log data from the one log file are stored; an extraction processing unit that extracts the specific log data from the one log file based on the format information stored in the format information recording unit and the extraction conditions stored in the extraction condition recording unit, At least one of the plurality of log data has a plurality of field information, the determination condition specifies one format of the plurality of log data by using at least one of the plurality of field information; An information processing system comprising:

7. the information processing system includes an extraction result recording unit that records the specific log data extracted by the extraction processing unit, 7. The information processing system according to claim 1, wherein the extraction result recording unit records the extracted specific plurality of log data in order of time when the data was received by the information processing system.

8. 8. The information processing system according to claim 7, wherein the extraction result recording unit records the extracted specific plurality of log data in order for each format.

9. the information processing system includes an extraction result recording unit that records the specific log data extracted by the extraction processing unit, 7. The information processing system according to claim 1, wherein the extraction result recording unit records the extracted specific plurality of log data in order for each format.

10. The information processing system according to any one of claims 7 to 9, characterized in that the extraction result recording unit outputs the recorded specific plurality of log data to be displayed on a display means in order of the time at which the data was received by the information processing system.

11. 11. The information processing system according to claim 7, wherein the extraction result recording unit outputs a plurality of log data having different formats so as to be simultaneously displayed on a display unit.

12. a log server includes a log recording unit that compiles the plurality of log data into the log file; 12. The information processing system according to claim 1, wherein the format information recording section, the extraction condition recording section, and the extraction processing section are included in an analysis server.

13. 13. The information processing system according to claim 1, wherein a manufacturer of the first device is different from a manufacturer of the second device, or a vendor of the first device is different from a vendor of the second device.

14. a receiving step in which an analysis server receives a log file including a plurality of log data including first log data having a first format output from a first device and second log data having a second format output from a second device different from the first format; a step of identifying a format of the received log file by an analysis server using format information including a determination condition for determining whether the format is the first format or the second format; an extraction step in which the analysis server extracts log data having the specified format from the received log file using extraction conditions for extracting specific log data from the log file; having An information processing method characterized in that the order in which the multiple log data are arranged in the log file is the order in which the multiple log data were received by a log recording unit that transmits the log file to an analysis server.

15. The information processing method according to claim 14, further comprising an output step of, before the receiving step, a log recording unit receiving a plurality of log data including the first log data and the second log data, and outputting the plurality of log data together into a single log file.

16. At least one of the plurality of log data has a plurality of field information, The information processing method according to claim 14 or 15, characterized in that the judgment condition includes a condition for identifying a format of one of the plurality of fields using at least one of the plurality of fields contained in the plurality of log data having the plurality of field information.

17. 17. The information processing method according to claim 16, characterized in that, in the extraction step, the analysis server extracts a plurality of the specific log data from the one log file, and extracts a plurality of the field information from each of the plurality of the specific log data.

18. 18. The information processing method according to claim 14, further comprising, after said extracting step, a display output step of outputting said extracted log data so as to display it on a display means.

19. 20. The information processing method according to claim 18, wherein in the display output step, a plurality of log data in different formats are output so as to be simultaneously displayed on a display means.

20. 20. The information processing method according to claim 14, wherein a manufacturer of the first device is different from a manufacturer of the second device, or a vendor of the first device is different from a vendor of the second device.

Citation Information

Patent Citations

  • Log integrated management system and log integrated management method

    JP2007233661A

  • Log retrieval system

    JP2010224705A

  • Log acquisition extraction system

    JP2016014980A

  • Event information visualization device, program and method

    JP2018106492A

  • Information processing device, data management system, data management method, and non-temporary computer-readable medium in which data management program is stored

    WO2019187208A1