986
7 APPLICATION INSTRUCTIONS
7.21 Database Access Instructions
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
code
Error content
Action
0103H
CPU internal error
Turn power off and turn it on again or reset the system and check
whether the instruction can be executed.
0104H
Another database access instruction is being executed.
Check that another database access instruction is not executed before
one database access instruction is completed.
0105H
• The specified path is not a database folder.
• The database is broken.
Check whether the folder specified by the path contains a database file.
If not, correct the path properly.
0106H
• A file in the database cannot be opened.
• A database built with a different firmware version is specified.
Create a new database using the DBIMPORT(P) instruction.
0107H
An invalid drive number is specified by the database access instruction.
Check whether the specified drive number is 2. If not, specify drive
number 2 correctly.
0108H
Deletion of the database failed.
Check that another function is not accessing the database and create a
new database using the DBIMPORT(P) instruction.
07D1H
The specified table is not found in the database.
Check that the database contains the specified table.
0940H
An invalid character is included in the table name.
Begin the table name with a non-numeric character and do not include
an invalid character.
0941H
The table name is duplicated.
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.
0942H
The specified table is not found in the database.
Check that the database contains the specified table.
0945H
The specified database is in use by another function.
After the database operation by another function has been completed,
execute the instruction again.
0946H
The specified table is in use by another function.
After the table operation by another function has been completed,
execute the instruction again.
094AH
The database name is not specified.
Specify a correct database name.
094BH
No database is stored in the specified folder.
Check that the folder name is correct and that the folder contains a
database-related file.
094CH
The field name contains an invalid character.
Do not include any invalid character in the field name.
094DH
The specified field name is duplicated.
Check for duplicated field names in Unicode text files or instruction
arguments. If any, correct it to prevent duplication.
094EH
A non-existent field is specified.
Check that the specified field exists in the table.
0950H
An invalid character is included in the index.
Do not include any invalid character 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.
Confirm the table structure. Check whether the field permits NULL. If
not, set significant data.
0952H
An attempt was made to add the same value to the field that has a
primary key constraint.
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.
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.
Change the table definition where the error is detected and re-build the
database.
0954H
The setting value cannot be automatically converted to the format
appropriate for the data type.
Check that the format of the setting value meets the specifications.
0959H
The data type that is checked during importing differs from the data
type defined in the table.
Check the Unicode text to verify that the setting value to be imported is
appropriate for the data type of the field.
095CH
The data types of compared values are incorrect such as comparing
the sizes of character strings.
Correct the values to be compared.
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.
Check that the setting value meets the data type specifications.
095EH
An attempt was made to assign more than one index to one field.
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.
095FH
The index name is duplicated.
Check that each index name is not 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.
Check the setting values of the reference.
Содержание MELSEC iQ-R Series
Страница 1: ...MELSEC iQ R Programming Manual Instructions Standard Functions Function Blocks ...
Страница 2: ......
Страница 24: ...22 INDEX 2092 INSTRUCTION INDEX 2093 REVISIONS 2104 WARRANTY 2105 TRADEMARKS 2106 ...
Страница 34: ...32 MEMO ...
Страница 35: ...33 PART 1 PART 1 OVERVIEW This part consists of the following chapter 1 OVERVIEW ...
Страница 68: ...66 1 OVERVIEW 1 5 Precautions on Programming MEMO ...
Страница 204: ...202 5 SEQUENCE INSTRUCTIONS 5 3 Output Instructions Operation error There is no operation error ...
Страница 470: ...468 6 BASIC INSTRUCTIONS 6 6 Data Conversion Instructions Operation error There is no operation error ...
Страница 472: ...470 6 BASIC INSTRUCTIONS 6 6 Data Conversion Instructions Operation error There is no operation error ...
Страница 479: ...6 BASIC INSTRUCTIONS 6 6 Data Conversion Instructions 477 6 Operation error There is no operation error ...
Страница 504: ...502 6 BASIC INSTRUCTIONS 6 7 Data Transfer Instructions Operation error There is no operation error ...
Страница 518: ...516 6 BASIC INSTRUCTIONS 6 7 Data Transfer Instructions Operation error There is no operation error ...
Страница 520: ...518 6 BASIC INSTRUCTIONS 6 7 Data Transfer Instructions Operation error There is no operation error ...
Страница 754: ...752 7 APPLICATION INSTRUCTIONS 7 9 Real Number Instructions Operation error There is no operation error ...
Страница 756: ...754 7 APPLICATION INSTRUCTIONS 7 9 Real Number Instructions Operation error There is no operation error ...
Страница 758: ...756 7 APPLICATION INSTRUCTIONS 7 9 Real Number Instructions Operation error There is no operation error ...
Страница 760: ...758 7 APPLICATION INSTRUCTIONS 7 9 Real Number Instructions Operation error There is no operation error ...
Страница 895: ...7 APPLICATION INSTRUCTIONS 7 16 Ramp Signal Instruction 893 7 Operation error There is no operation error ...
Страница 917: ...7 APPLICATION INSTRUCTIONS 7 20 Data Processing Instructions 915 7 Operation error There is no operation error ...
Страница 919: ...7 APPLICATION INSTRUCTIONS 7 20 Data Processing Instructions 917 7 Operation error There is no operation error ...
Страница 1415: ...13 SFC PROGRAM INSTRUCTIONS 13 1 SFC Control Instructions 1413 13 Operation error There is no operation error ...
Страница 1448: ...1446 14 REDUNDANT SYSTEM INSTRUCTIONS 14 2 Disabling Enabling System Switching MEMO ...
Страница 1795: ...25 TYPE CONVERSION FUNCTIONS 25 1 Converting BOOL to WORD 1793 25 Operation error There is no operation error ...
Страница 1805: ...25 TYPE CONVERSION FUNCTIONS 25 10 Converting WORD to DINT 1803 25 Operation error There is no operation error ...
Страница 1819: ...25 TYPE CONVERSION FUNCTIONS 25 21 Converting INT to DWORD 1817 25 Operation error There is no operation error ...
Страница 1950: ...1948 32 STRING FUNCTIONS 32 2 Extracting String Data From the Left Right Operation error There is no operation error ...
Страница 1972: ...1970 33 TIME DATA TYPE FUNCTIONS 33 4 Division MEMO ...
Страница 2067: ...APPX Appendix 5 PID Control Program Examples 2065 A 252 Set PID control data for loop 2 ...
Страница 2082: ...2080 APPX Appendix 6 Process Control Program Examples 129 Set the default value of the loop tag ...
Страница 2093: ...APPX Appendix 7 List of Loop Tag Memory Areas Used by Process Control Instructions 2091 A MEMO ...
Страница 2109: ......