HP NonStop SQL/MX, Messages Manual

Page: 253 / 752

Executor Messages (8000 through 8999)
HP NonStop SQL/MX Messages Manual — 640324-001
10- 5
Recovery. Turn the explain default on for this query.
SQL 8018
Where
name1
is the name of the partition.
Where
name2
is the name of the table.
Where
number
is the file system error returned.
Cause. Attempt to open partition
name1
of the table
name2
failed, returning the file
system error code number.
Effect. None
Recovery. See the Guardian Procedure Errors and Messages Manual to diagnose
and correct the problem.
SQL 8019
Cause. A NULL or truncated value is received instead of a numeric value.
Effect. The operation fails.
Recovery. None. Contact your service provider.
SQL 8022
Cause. The row count maintained by the disk process for one or more partitions of the
table name is invalid because of the following reasons:
•
The table is created by an SQL release before R3.0.
•
The table is created by an SQL DUP operation.
•
The table is reorganized.
Effect. The operation fails.
Recovery. In the SQL/MX R3.0, the only way to reset the row count is to delete all the
rows from the table. Alternatively, the INSERT…SELECT statements can be used to
move the data from the table with the invalid row count to another table. The target
8018 Partition name1 of table name2 could not be accessed due
to file system error number. It is skipped because the
default SKIP_UNAVAILABLE_PARTITION was set.
8019 Explain plan data retrieval error, numeric field NULL or
truncated.
8022 Stored row count is invalid for table name.