6 How to Use Operation Logs
6-20
NJ/NX-series Database Connection CPU Units User’s Manual (W527)
Result 6 bytes (Fixed) Displays a 4-digit hexadecimal code that shows the execution result.
(e.g., 0x1234)
0x0000: Succeeded
Other than 0x0000: Failed (Same code as ErrorID of DB Connection
16 bytes max. (Variable) Displays a DB Connection name (single-byte alphanumeric
Serial ID 10 bytes max. (Variable) ID code given at each execution of DB_Insert, DB_Update,
DB_Select, or DB_Delete instruction. (The same ID as Serial ID
displayed in the SQL or SQL Resend record of Execution Log is
Details Variable Displays the details of the SQL Execution Failure Log. The contents
differ according to the category.
In the Details parameter, information items are separated from each
other by a tab.
Category: SQL Execution Failed
[Table name]<tab>[DB Map Variable name]<tab>[DB error
code]<tab>[Error message]<tab>[SQL statement]
DB Map Variable name: The POU instance name is not 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: Spooled
[Table name]<tab>[DB Map Variable name]<tab>[SQL statement]
DB Map Variable name: The POU instance name is not displayed.
Category: Status Error
[Table name]<tab>[DB Map Variable name]<tab>[SQL statement]
DB Map Variable name: The POU instance name is not displayed.
*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
Characters displayed in the log
Operation Log recording timing
SQL
Execution
Failed
When execution of an SQL statement issued from DB Connection
Service to DB failed due to a DB-caused factor.
When an SQL statement is stored in the Spool memory because
a failure occurred in information exchange between DB
Connection Service and DB.
To Next Page
Loading...
Need help?
General
