Mitsubishi Electric MELSEC iQ-R Series Programming Manual page 990

Error Error content
code
1000H The Unicode text file specified for importing does not exist.
1002H There is no identification number that can be allocated.
1003H The identification number of a database which is not open is specified.
1004H The identification number specified by the instruction is out of range.
1007H The number of fields to be specified by the instruction is not specified.
1008H • The number of fields specified by the instruction is out of range.
• The field name specified by the instruction is out of range.
1009H The number of records to be specified by the instruction is not
specified.
100AH The number of records specified by the instruction is out of range.
100CH The Unicode text table or set-value delimitation does not follow the
format.
100DH An error occurred in the database.
100EH The condition number specified by the instruction is out of range.
100FH When two conditions are specified by the instruction, the logical
operator setting value is 0.
1010H The maximum number of databases that can be transacted is
exceeded.
1011H The commit or rollback instruction is executed without starting a
transaction.
1012H The value of the size per record used for adding or update is not
appropriate.
1013H A data type which is not supported is specified.
1014H • Another database is opened during execution of the transaction.
• The DBEXPORT(P) instruction is executed during transaction.
1015H A transaction is executed for the multiple databases that were already
open.
101BH The first condition is not set in the relevant argument of each
instruction.
101CH The data size of a field is not included in multiple condition settings.
101DH A field name is not included in multiple condition settings.
101EH The value of the inter-condition operator is out of range.
101FH The value of the inter-condition operator in the second condition setting
is out of range.
1020H The setting value is not within the range specified for the data type.
1021H An attempt was made to open a database which was already open.
1022H The DBIMPORT(P) instruction was executed while the database was
already open.
1023H A table number outside the range is specified.
102EH The field size specified in the conditions is out of range.
1030H The output size exceeds the setting value.
1031H The number of outputs exceeds the setting value.
1032H Since the SD memory card was removed while opening the database
with the DBOPEN(P) instruction or executing a database access
instruction, the database access instruction cannot be executed or the
CPU module database access (from external device) function cannot
be executed from an external device.
1040H The total size of records to be added exceeds the limit.
7 APPLICATION INSTRUCTIONS
988
7.21 Database Access Instructions
Action
Check whether the file indicated by the folder path is a Unicode text file.
If not, specify a correct folder path.
A maximum of four databases can be opened. Adjust the number of
databases that will be opened to 4.
Use the DBOPEN(P) instruction to open the database in advance and
obtain an identification number.
Specify the identification number obtained by the DBOPEN(P)
instruction.
Set 1 or greater for the number of fields in the argument.
• Set 128 or less for the number of fields in the argument.
• Specify a field name within the available range (up to 128th field) in
the argument.
Set 1 or greater for the number of records in the argument.
Set the number of records within the range in the argument.
Check that the delimiters in the table or set-value delimitations follow
the format.
Turn power off and turn it on again or reset the system and check
whether the same symptom recurs.
Check that the condition number range is correct.
Check that the logical operator setting value in the argument is 1 or 2.
Check that a transaction is not executed for two or more databases or
that another transaction is not executed while one transaction is
already running.
Check that the commit or rollback instruction is not executed while no
transaction is running.
Check that the data size of each field matches the size of the data to be
added or updated.
Check the data type of the Unicode text.
• Do not open a database newly during execution of the transaction.
• Execute the DBEXPORT(P) instruction after the transaction is
completed.
Close the databases that are not targeted for a transaction.
Check that the field size set as the first condition in the argument is
other than 0 or whether the field name is null.
Check that the data size of the field specified by the condition is 0.
Check that the field name specified by the condition is not null.
Check that the value of the inter-condition operator is correct.
Check that a value other than 0 is not set in the logical operator setting
value of the second condition.
Check that the setting value is within the range.
Check that the path corresponding to (s) of the DBOPEN(P) instruction
is not specified more than once.
Close the database that is already open, and execute the
DBIMPORT(P) instruction.
Check that the table number is within the range.
Check that the field size in the conditions is within the range.
Adjust the output size.
Adjust the number of outputs.
Power off and on the CPU module or reset it.
Adjust the total size of records to be added.
*1