Hitachi

Hitachi Advanced Database Messages


KFAA34009-E

The text index must be rebuilt to access the table. (index ID = "aa....aa") (M+J+O)

Data retrieval by using the text index aa....aa is not available. Alternatively, the text index aa....aa cannot be updated. <SQLSTATE: 53051>

aa....aa:

Index ID

S:

Ignores this SQL statement. If this message is issued during execution of the command, processing terminates.

Action:

Execute the adbidxrebuild command to rebuild the text index aa....aa. Identify the table name and index name that must be specified for executing the adbidxrebuild command from the index ID displayed by aa....aa. For details about how to identify the table name and index name from the index ID, see When identifying the name of a table for which an index is defined from an index ID and When identifying the index name from an index ID in Searching a dictionary table in the HADB Setup and Operation Guide.

Note

If you upgrade the HADB server to version 04-00 or later, text indexes defined in version 03-06 (text indexes with text-index-word-context search specification) cannot be used for a search. Note also that those text indexes cannot be updated. To allow the text indexes to be searched and updated, you need to rebuild them.