Error Codes Related To Database Access Instructions - Mitsubishi Electric MELSEC iQ-R Series Programming Manual

Error codes related to database access instructions

The following table lists the error codes that could be stored in the completion status of database access instructions.
Error Error content
code
0103H CPU internal error
0104H Another database access instruction is being executed.
0105H • The specified path is not a database folder.
• The database is broken.
0106H • A file in the database cannot be opened.
• A database built with a different firmware version is specified.
0107H An invalid drive number is specified by the database access instruction.
0108H Deletion of the database failed.
07D1H The specified table is not found in the database.
0940H An invalid character is included in the table name.
0941H The table name is duplicated.
0942H The specified table is not found in the database.
0945H The specified database is in use by another function.
0946H The specified table is in use by another function.
094AH The database name is not specified.
094BH No database is stored in the specified folder.
094CH The field name contains an invalid character.
094DH The specified field name is duplicated.
094EH A non-existent field is specified.
0950H An invalid character is included in the index.
0951H An attempt was made to set empty data (NULL value) in the main key
or in the field that has a NOT NULL constraint.
0952H An attempt was made to add the same value to the field that has a
primary key constraint.
0953H If overlapped data are set to the field where an index is set repeatedly,
the data for the index become large and the memory of the CPU
module cannot secure enough free space.
0954H The setting value cannot be automatically converted to the format
appropriate for the data type.
0959H The data type that is checked during importing differs from the data
type defined in the table.
095CH The data types of compared values are incorrect such as comparing
the sizes of character strings.
095DH Converting the data type of the setting value specified in an argument
of the database access instruction failed and therefore the setting value
cannot be stored in the field.
095EH An attempt was made to assign more than one index to one field.
095FH The index name is duplicated.
096CH The setting value to be added to the field where the external key is
specified as a key constraint is not included in the setting values of the
reference.
7 APPLICATION INSTRUCTIONS
986
7.21 Database Access Instructions
Action
Turn power off and turn it on again or reset the system and check
whether the instruction can be executed.
Check that another database access instruction is not executed before
one database access instruction is completed.
Check whether the folder specified by the path contains a database file.
If not, correct the path properly.
Create a new database using the DBIMPORT(P) instruction.
Check whether the specified drive number is 2. If not, specify drive
number 2 correctly.
Check that another function is not accessing the database and create a
new database using the DBIMPORT(P) instruction.
Check that the database contains the specified table.
Begin the table name with a non-numeric character and do not include
an invalid character.
Database table names are not case-sensitive. Check whether same
characters are used to set Unicode text file table names by
differentiating them with uppercase and lowercase characters.
Check that the database contains the specified table.
After the database operation by another function has been completed,
execute the instruction again.
After the table operation by another function has been completed,
execute the instruction again.
Specify a correct database name.
Check that the folder name is correct and that the folder contains a
database-related file.
Do not include any invalid character in the field name.
Check for duplicated field names in Unicode text files or instruction
arguments. If any, correct it to prevent duplication.
Check that the specified field exists in the table.
Do not include any invalid character in the index.
Confirm the table structure. Check whether the field permits NULL. If
not, set significant data.
Check that the setting value of the record attempted to add to the field
that has a primary key constraint is not the same as the record already
registered.
Change the table definition where the error is detected and re-build the
database.
Check that the format of the setting value meets the specifications.
Check the Unicode text to verify that the setting value to be imported is
appropriate for the data type of the field.
Correct the values to be compared.
Check that the setting value meets the data type specifications.
Check that an attempt has not been made to add an index to the field
where the primary key or external key is set. Check also that an
attempt has not been made to assign more than one index to one field.
Check that each index name is not duplicated.
Check the setting values of the reference.