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

Model	NX701-1620
Type	CPU Unit
Power Supply	24 VDC
Programming Software	Sysmac Studio
Operating Temperature	0 to 55°C
Storage Temperature	-25 to 70°C
Series	NX Series
Digital Inputs	Dependent on I/O modules
Digital Outputs	Dependent on I/O modules
Communication Ports	Ethernet
Humidity	10% to 90% (non-condensing)
Shock Resistance	147 m/s², 3 times each in X, Y, and Z directions
Vibration Resistance	10 to 57 Hz, 0.075 mm amplitude; 57 to 150 Hz, 9.8 m/s² acceleration

Summary

Introduction

Intended Audience

Specifies the target audience for this manual, requiring knowledge of electrical systems and FA.

Applicable Products

Lists the specific CPU Unit models and Sysmac Studio versions covered by this manual.

Relevant Manuals

Manual Structure

Page Structure

Details the components of a typical page, including headings, procedures, and icons.

Special Information

Precautions for Safe Use

Outlines precautions to ensure the safe usage of the product.

Precautions for Correct Use

Provides precautions for ensuring proper operation and performance of the product.

Additional Information

Offers extra details to enhance understanding or make operations easier.

Version Information

Details differences in specifications and functionality based on unit and Sysmac Studio versions.

Precaution on Terminology

Defines key terms like "download" and "synchronize" as used in the manual.

Sections in this Manual

Terms and Conditions Agreement

Warranty, Limitations of Liability

Details Omron's warranty terms, limitations, and buyer remedies for product defects.

Limitation on Liability; Etc

Limits Omron's liability for damages related to product use or consequential losses.

Application Considerations

Discusses suitability of use, programmable products, and critical safety considerations for applications.

Disclaimers

Covers performance data, specification changes, and errors/omissions.

Programmable Products

Clarifies Omron's non-responsibility for user programming of programmable products.

Performance Data

Explains that presented performance data is a guide and not a warranty.

Change in Specifications

States that product specifications may change without notice.

Errors and Omissions

Disclaims responsibility for clerical, typographical, or proofreading errors or omissions in the manual.

Safety Precautions

Precautions for Safe Use

Refers to hardware manuals for safety precautions and provides contact information for specific models.

Precautions for Correct Use

Regulations and Standards

Conformance to EU Directives

Details how NJ/NX-series Controllers comply with EU Directives and installation requirements.

Conformance to KC Standards

Provides precautions for using NX-series Units in Korea, noting Class A device registration.

Conformance to Shipbuilding Standards

Explains compliance with shipbuilding standards, including usage conditions for NK and LR standards.

Software Licenses and Copyrights

Informs about third-party software licenses and copyright information availability.

Versions

Unit Versions

Defines unit versions for hardware/software of Units and EtherCAT slaves.

Version Types

Describes the two types of versions: unit version and DB Connection Service version.

Checking Versions

Details methods for checking unit versions using ID information labels and Sysmac Studio.

Unit Versions of CPU Units and Sysmac Studio Versions

Relates supported functions to CPU Unit and Sysmac Studio versions, referring to B-4.

Related Manuals

Terminology

Revision History

Introduction to the DB Connection Service

1-1 Overview and Features

Introduces the DB Connection Service, its overview, and key features.

1-2 DB Connection Service Specifications and System

Details the specifications and system architecture of the DB Connection Service.

1-3 Operation Flow of the DB Connection Service

Outlines the basic operational flow for using the DB Connection Service.