Omron NX701-1620 User Manual

6 How to Use Operation Logs
6-7
NJ/NX-series Database Connection CPU Units User’s Manual (W527)
6
6-2 Execution Log
6-2-5 Execution Log File Specifications
Parameter
Size
Description
Details Variable Displays the details of the Execution Log. The contents differ according to
the category.
In the Details parameter, information items are separated from each other
by a tab.
Category: DB Connection Service
None
Category: DB Connection
[SQL status]<tab>[DB error code]<tab>[Error message]
SQL status: The SQLSTATE value defined in the SQL Standards
(ISO/IEC 9075) is displayed.
DB error code: Error code that is specific to DB vendor of the device to
connect. When a network error has occurred, 0 is displayed for DB error
code in some cases. When 0 is displayed, check its SQL status.
Error message: The error message is displayed from the first character
within the record size (i.e., 256 bytes).
Category: SQL
[Table name]<tab>[DB Map Variable name]<tab>[DB response
time]<tab>[DB error code]
Table name and DB Map Variable name: A maximum of 60 bytes from
the beginning are displayed.
DB Map Variable name: Variable name specified in the MapVar input
variable (The POU instance name is not displayed. Nothing is displayed
for DELETE.)
DB response time: An integer value in milliseconds is displayed.
DB error code: Error code that is specific to DB vendor of the device to
connect. When a network error has occurred, 0 is displayed for DB error
code in some cases. When 0 is displayed, check the Result parameter.
Category: SQL Resend
[DB response time]<tab>[DB error code]
DB response time: An integer value in milliseconds is displayed.
DB error code: Error code that is specific to DB vendor of the device to
connect. When a network error has occurred, 0 is displayed for DB error
code in some cases. When 0 is displayed, check the Result parameter.
Category: User-specified Log
“[Log message]”
Displays the text string specified in the LogMsg input variable of the
DB_PutLog instruction. (128 bytes max.)
Tab
separation
10 bytes in total
CR+LF
2 bytes
*1 The date and time information follows the time zone set when the power supply to the
Controller is turned ON. After you change the time zone, cycle the power supply.
*2 Category
Category
Characters displayed in the log
DB Connection Service
DB_SERVICE
DB Connection
DB_CONNECTION
SQL
SQL
SQL Resend
SQL_RESEND
User-specified Log
USER

Omron NX701-1620 Specifications

General

Brand	Omron
Model	NX701-1620
Category	Controller
Language	English