End Code 63

Error in virtual table query processing
An error occurred with the virtual table query processing. %s

1:

The virtual table database could not be opened. (file name = %s, cause = %s)

Description:

An error occurred when a virtual table was created.

Action to take:

Review the message to identify the cause of the issue, and then address the issue accordingly.

2:

The transaction processing for virtual tables failed. (cause = %s)

Description:

An error occurred when a virtual table was created. (Transaction issue)

Action to take:

Review the message to identify the cause of the issue, and then address the issue accordingly.

3:

Virtual tables could not be created. (cause = %s)

Description:

An error occurred when a virtual table was created. (Table creation)

Action to take:

Review the message to identify the cause of the issue, and then address the issue accordingly.

4:

Virtual table data could not be inserted. (cause = %s)

Description:

An error occurred when a virtual table was created. (Data insert)

Action to take:

Review the message to identify the cause of the issue, and then address the issue accordingly.

6:

The date field of the input data specified in the virtual table is not a date string.

(input data = %s)

Description:

An invalid date value was input in a field specified as a date type.

Action to take:

Make sure that the value in the virtual table file is a valid date value.

Alternatively, check the field type settings.

7:

Virtual table data could not be inserted. (cause = %s)

Description:

An error occurred when a virtual table was created.

Action to take:

Review the message to identify the cause of the issue, and then address the issue accordingly.

8:

The initialization processing for inserting virtual table data failed. (cause = %s)

Description:

An error occurred when a virtual table was created.

Action to take:

Review the message to identify the cause of the issue, and then address the issue accordingly.

9:

The termination processing for inserting virtual table data failed. (cause = %s)

Description:

An error occurred when a virtual table was created.

Action to take:

Review the message to identify the cause of the issue, and then address the issue accordingly.

10:

Indexes for virtual tables could not be created. (cause = %s)

Description:

An error occurred when a virtual table was created. (Index creation)

Action to take:

Review the message to identify the cause of the issue, and then address the issue accordingly.

11:

The virtual table database could not be opened. (cause = %s)

Description:

An error occurred in processing to open a virtual table.

Action to take:

Review the message to identify the cause of the issue, and then address the issue accordingly.

12:

Preparation for SQL execution failed. (setting = %s, cause = %s)

Description:

An error occurred when an SQL statement to be issued to a virtual table was generated.

Action to take:

Review the message to identify the cause of the issue, and then address the issue accordingly.

13:

The preprocessing for collecting virtual table data failed. (setting = %s, cause = %s)

Description:

When data was obtained from a virtual table, an error occurred in the preprocessing.

Action to take:

Review the message to identify the cause of the issue, and then address the issue accordingly.

14:

No record in the virtual table matched the condition. The current configuration is that an error occurs if no record can be obtained.

Description:

The SQL statement set in "Query value" from the virtual table could not obtain a value.

Action to take:

Check the virtual table data or the "Query value" settings.

15

Virtual table data could not be obtained. (file name = %s, cause = %s)

Description:

When the SQL statement set in "Query value" from the virtual table tried to acquire a value, an error occurred.

Action to take:

Review the message to identify the cause of the issue, and then address the issue accordingly.

16:

The input field data specified by the $VDATE function of the query value is not a date string. (Input data = %s)

Description:

An invalid date value was input in the field specified in the $VDATE function.

Action to take:

Make sure that the field data of the input side specified in the $VDATE function is a valid date value.

17:

The dynamic character string (%02d) assigned to the query setting is not specified in the argument.

Description:

The dynamic string set in "Query value category" was not specified.

Action to take:

Specify the dynamic string as an argument.

18:

A null character is specified in the dynamic character string (%02d). Specify an SQL statement.

Description:

The null character was specified for the dynamic string set in "Query value category".

Action to take:

Specify an SQL statement for the dynamic string.

21:

An invalid character (0x%02X) exists in the numeric formula. (offset = %d)

Description:

A code was specified that cannot be set for a numeric operation formula.

Action to take:

The numeric operation formula specified in "Query value" might be specified incorrectly.

Check the settings.

22:

An invalid character (0x%02X) occurred in the SQL statement. (offset = %d)

Description:

In a query value, a field reference other than $RCOUNT, $DNUM, $MINUM, $INUM, $INAME, $VAR, or $DSTR is specified.

Action to take:

Check the settings of the query value.

23:

"%s" is invalid in the SQL statement.

"$VAR()" is specified incorrectly.

Description:

Not specified in the format $VAR(variable name) for $VAR specified in the query value.

Action to take:

In the query value specified in the output information of the mapping information, $VAR might be specified incorrectly.Check the settings.

24:

"%s" is invalid in the SQL statement.

"$VAR()" is specified incorrectly.

Description:

Not specified in the format $VAR(variable name) for $VAR specified in the query value.

Action to take:

In the query value specified in the output information of the mapping information, $VAR might be specified incorrectly. Check the settings.

25:

"%s" is invalid in the SQL statement.

"$INAME()" is specified incorrectly.

Description:

Not specified in the format $INAME(input field name) or $INAME (input field name, No. of occurrences) for $INAME specified in the query value.

Action to take:

In the query value specified in the output information of the mapping information, $INAME might be specified incorrectly. Check the settings.

26:

"%s" is invalid in the SQL statement.

Specify a numeric value for "$INUM()".

Description:

A non-numeric value is specified in the field number of $INUM(field name) for $INUM specified in the query value.

Action to take:

In the query value specified in the output information of the mapping information, $INUM might be specified incorrectly. Check the settings.

27:

"%s" is invalid in the SQL statement.

You cannot use $INUM if the input format is XML.

Description:

If the input type is XML, the field cannot be referenced by specifying $INUM.

Action to take:

Check the settings in the query value that is set in the output information of the mapping information.

28:

"%s" is invalid in the SQL statement.

$MINUM is specified incorrectly.

Description:

The arguments of $MINUM(MATCHNO, ITEMNO) specified in the query value are set incorrectly.

Action to take:

In the query value specified in the output information of the mapping information, $MINUM might be specified incorrectly. Check the settings.

29:

"%s" is invalid in the SQL statement.

Specify a numeric value for "$MINUM(MATCHNO, ITEMNO)".

Description:

A non-numeric value is specified for MATCHNO or ITEMNO of $MINUM(MATCHNO, ITEMNO) that is specified in the query value. You must use numeric values to specify the matching number for MATCHNO and the field number for ITEMNO.

Action to take:

In the query value specified in the output information of the mapping information, $MINUM might be specified incorrectly. Check the settings.

30:

The matching number (%d) specified by $MINUM(MATCHNO,ITEMNO) is incorrect. Check the setting.

Description:

An invalid numeric value is specified for the MATCHNO in $MINUM(MATCHNO, ITEMNO) that is specified in the query value.

Action to take:

In the date operation formula specified in the output information of the Set Mapping Information screen, $MINUM might be specified incorrectly. A matching number that has already been set must be specified for MATCHNO.

31:

"%s" is invalid in the SQL statement.

$MINUM is specified incorrectly.

Description:

The arguments of $MINUM(MATCHNO, ITEMNO) specified in the query value are set incorrectly.

Action to take:

In the query value specified in the output information of the Set Mapping Information screen, $MINUM might be specified incorrectly. Check the settings.

32:

"%s" is invalid in the SQL statement.

Specify a numeric value for "$MINUM(MATCHNO, ITEMNO)".

Description:

A non-numeric value is specified for MATCHNO or ITEMNO of $MINUM(MATCHNO, ITEMNO) that is specified in the query value. You must use numeric values to specify the matching number for MATCHNO and the field number for ITEMNO.

Action to take:

In the query value specified in the output information of the mapping information, $MINUM might be specified incorrectly. Check the settings.

33:

"%s" is specified incorrectly in the SQL statement.

Specify a value from $DSTR01 to $DSTR20.

Description:

The value for $DSTR specified in the query value is invalid.

Action to take:

Specify a valid number.

34:

"%s" is specified incorrectly in the SQL statement.

Specify a value from $DNUM01 to $DNUM20.

Description:

The value for $DNUM specified in the query value is invalid.

Action to take:

Specify a valid number.

35:

The field number specified by "%s" in the SQL statement does not exist in the input format.

Description:

In the input data, a field that corresponds to the field number specified in $INUM or $MINUM in the query value specification does not exist.

Action to take:

Check whether an input field that corresponds to the specified value exists.

36:

The field name and no. of occurrences specified by "%s" in the SQL statement do not exist in the input format.

Description:

In the input data, a field name that corresponds to the field name specified in $INAME in the query value specification does not exist.

Action to take:

Check whether an input field that corresponds to the specified value exists.

37:

Conversion from the virtual table code type (%s) to ASCII failed.

The specified code type might differ from the code type of the actual data.

Description:

During data insert processing for a virtual table, an error occurred in conversion of the specified encoding to ASCII.

Action to take:

Check the data or the encoding of the virtual table file.

38:

The data in the virtual table field (%s) of numeric type is not a numeric value.

(number of records = %d, content = %s)

Description:

Data other than numeric values was found in the field specified as a numeric type in the virtual table.

Action to take:

Check the data of the virtual table file, or revise the settings of the virtual table.

39:

The data in the virtual table field (%s) of numeric type is not a numeric value.

(number of records = %d, content = %s)

Description:

Data other than numeric values was found in the field specified as a numeric type in the virtual table.

Action to take:

Check the data of the virtual table file, or revise the settings of the virtual table.

40:

An error occurred in "%s" in the SQL statement.

The specified variable (%s) is not defined.

Description:

In the query value specification, a variable name specified in $VAR(variable name) is undefined.

Action to take:

In the query value specification, the variable name set in $VAR might be incorrect.

Check the settings.

41:

"%s" is invalid in the SQL statement.

"$INUM()" is specified incorrectly.

Description:

The arguments of $INUM(ITEMNO) specified in the query value are set incorrectly.

Action to take:

In the query value specified in the output information of the Set Mapping Information screen, $INUM() might be specified incorrectly. Check the settings.