Omron NX701-1620 User Manual

6 How to Use Operation Logs
6-19
NJ/NX-series Database Connection CPU Units User’s Manual (W527)
6
6-4 SQL Execution Failure Log
6-4-4 Checking the SQL Execution Failure Log
Refer to 6-6 Checking the Operation Logs for how to check the SQL Execution Failure Log.
6-4-5 SQL Execution Failure Log File Specifications
This section describes the specifications of SQL Execution Failure Log files.
 Each SQL Execution Failure Log file is composed of multiple records.
 Each record is expressed in one line.
 The maximum size of each SQL Execution Failure Log file is set on Sysmac Studio.
 The size of each record is 58 KB max.
 The following table shows the file name and type.
File name
File type
DB_SQLFailedLog.log Latest log file of the log
DB_SQLFailedLog_[year_month_date_hours_minutes_seconds_milliseconds].log*
Example:
DB_SQLFailedLog_20120724220915040.log
Previous log files
DB_SQLFailedLog.fjc
Log control file
* The system time of the CPU Unit is used for the time information included in the file name.
 The files are stored in the following directory (of the SD Memory Card).
- Log files:
/packages/DB_Connection/SQLFailedLog/
- Log control file:
/packages/DB_Connection/System/
 The following is the format of records.
Each record is expressed in one line and composed of multiple parameters. The parameters are
separated from each other by a tab.
[Serial number]<tab>[Date]<tab>[Time]<tab>[Millisecond]<tab>[Category]<tab>[Log code]<tab>[Log
name]<tab>[Result]<tab>[DB Connection name]<tab>[Serial ID]<tab>[Details]<CR><LF>
Parameter
Size
Description
Serial number 1 to 5 bytes 0 to 65535
When exceeding 65535, this value returns to 0.
The serial number is given across multiple files. (Even if a new file is
created, the serial number is not reset to 0.)
Date 10 bytes (Fixed) Displays year, month, and date when the log was recorded.
*1
YYYY-MM-DD
Example: 2012-07-23
Time 8 bytes (Fixed) Displays hours, minutes, and seconds when the log was recorded.
*1
hh:mm:ss
Example: 15:33:45
Millisecond 3 bytes (Fixed) Displays 3-digit decimal integer (000 to 999) that shows millisecond
of the time when the log was recorded.
*1
Example: 10 ms: 010
623 ms: 623
Category
16 bytes max. (Variable)
Displays the category.
*2
Log code 4 bytes (Fixed) Displays a 4-digit decimal code that is a unique identification code in
the category.
*3
Log name
32 bytes max. (Variable)
Displays a name that shows the contents of the log.
*4
6-4-4 Checking the SQL Execution Failure Log

Omron NX701-1620 Specifications

General

Brand	Omron
Model	NX701-1620
Category	Controller
Language	English