Hitachi

Hitachi Advanced Database Messages


KFAA50221-E

The number of columns in the input data does not match the number of stored columns. (input file = aa....aa, row = bb....bb) (M)

The number of columns of input data in the bb....bbth line does not match the column count at the storage destination.

aa....aa:

The serial number or file name of the input file

bb....bb:

Row number

S:

Terminates processing.

Action:

A logical error has occurred in input data. Other possible explanations are as follows, in addition to the possibility that the input data column count does not match the storage destination column count.

  • Data in the input file includes 0x00.

  • The final line does not end in a linefeed.

  • An EOF control character is stated at the end of the file.

For details about the corrective action to take for logical errors in input data, see How to handle logical errors in input data in the manual HADB Command Reference.

Also, for details about the process up to executing the adbimport command, see Handling abnormal termination of the adbimport command in the manual HADB Command Reference.

<When the table to be imported has an array-type column defined>

Check whether the array type field data is surrounded by enclosing characters. If the array type field data is not surrounded by enclosing characters, it is possible that an array element in the array type field data tried to be imported into a non-array type column, resulting in a logical error in the input data.

In this case, use the following procedure:

  1. Surround array type field data with enclosing characters

  2. Re-execute the adbimport command.

  3. If a logical error occurs in the input data, follow the instructions in the output error message and fix the error.