Omron NX701-1620 - Page 162

7 Troubleshooting
7-12
NJ/NX-series Database Connection CPU Units User’s Manual (W527)
Event code Event name Meaning Assumed cause
Level
Reference
Maj
Prt
Min
Obs
Info
5401300Bhex SQL
Execution
Error
The executed
SQL statement
resulted in an
error.
 There is no column with the
same name as a structure
member of the DB Map
Variable.
 The table specified in the
DB_CreateMapping instruction
does not exist in the DB.
 One or more structure member
values of the DB Map Variable
cannot 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.
 One or more structure member
values of the DB Map Variable
exceed 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)
 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)
 The sort condition has a syntax
error. (DB_Select instruction)
 The user does not have the
access rights to the table.
S
7-31
5401300Chex Spool
Capacity
Exceeded
The SQL
statement could
not be stored in
the Spool
memory
because its
maximum
capacity was
exceeded.
 The DB connection failure has
been continuing due to network
failure or other factors.
 The resend processing of the
SQL statements stored in the
Spool memory has not been
executed (when the Resend
spool data parameter is set to
Manual).
S
7-33
5401300Ehex Invalid
Extraction
Condition
The entered
extraction
condition is
invalid.
 A text string that consists of a
NULL (16#00) character only
was specified in the Where
input variable.
S
7-34