Omron NX701-1620 - Page 181

7 Troubleshooting
7-31
NJ/NX-series Database Connection CPU Units User’s Manual (W527)
7
7-2 Troubleshooting
7-2-2 Error Descriptions
Event name
SQL Execution Error
Event code
5401300Bhex
Meaning
The executed SQL statement resulted in an error.
Source PLC Function Module Source details Instruction Detection
timing
At instruction
execution
Error attributes
Level
Observation
Recovery
---
Log category
System
Effects User program Continues. Operation The relevant instruction will end according to
specifications.
System-defined
variables
Variable
Data type
Name
None
---
---
Cause and
correction
Assumed cause
Correction
Prevention
There is no column with the
same name as a structure
member of the DB Map Variable.
Check whether the column names
match the structure member
names of the DB Map Variable.
Confirm that the column names
match the structure member
names of the DB Map Variable.
The table specified in the
DB_CreateMapping instruction
does not exist in the DB.
Check whether the table name
specified in the
DB_CreateMapping instruction is
correct.
Confirm that the table name
specified in the DB_CreateMapping
instruction is correct.
One or more structure member
values of the DB Map Variable
cannot be converted to the
corresponding column’s data
type.
Check whether the data types of
the structure members of the DB
Map Variable can be converted to
the corresponding column’s data
type.
Confirm that the data types of the
structure members of the DB Map
Variable can be converted to the
corresponding column’s data type.
One or more column values
cannot be converted to the
corresponding structure
member’s data type of the DB
Map Variable.
Check whether the data types of
the columns can be converted to
the corresponding structure
member’s data type of the DB Map
Variable. Or, confirm that the
values of the mapped columns are
not NULL.
Confirm that the data types of the
columns can be converted to the
corresponding structure member’s
data type of the DB Map Variable.
Or, define the structure members
so as not to map a column whose
value can be NULL.
One or more structure member
values of the DB Map Variable
exceed the valid range of the
corresponding column’s data
type.
Check the structure member
values of the DB Map Variable.
Write the user program so that the
structure member values of the DB
Map Variable are within the valid
range of the corresponding
column’s data type.
The column specified in the
extraction condition does not
exist in the DB’s records.
(DB_Select instruction,
DB_Update instruction,
DB_Delete instruction)
Check whether the column name
specified in the extraction
condition is correct. Or, check
whether the syntax of the
extraction condition is correct.
Confirm that the column name
specified in the extraction condition
is correct. Or, confirm that the
syntax of the extraction condition is
correct.
The extraction condition has a
syntax error.
(DB_Select instruction,
DB_Update instruction,
DB_Delete instruction)
The column specified in the sort
condition does not exist in the
DB’s records.
(DB_Select instruction)
Check whether the column name
specified in the sort condition is
correct. Or, check whether the
syntax of the sort condition is
correct.
Confirm that the column name
specified in the sort condition is
correct. Or, confirm that the syntax
of the sort condition is correct.
The sort condition has a syntax
error. (DB_Select instruction)
The user does not have the
access rights to the table.
Check the access rights to the
table.
Confirm the access rights to the
table.