SQL/MX 2.x Messages Manual (H06.10+, J06.03+)

UPDATE STATISTICS and Executor Sort Messages
(9200 through 10049)
HP NonStop SQL/MX Messages Manual—544518-011
11 - 7
Executor Sort Messages
Effect. The operation fails.
Recovery. None. This is an internal error. Contact your service provider.
SQL 10004
Cause. This error occurs when a scratch file operation fails, causing the generation of
intermediate runs to fail during the merge phase of a sort. The sort error would indicate
any low-level sort error and the system error, if any, would indicate the low-level
system error. If the cause is only a sort error, the system error may be 0.
Effect. The operation fails.
Recovery. Check the low-level sort error and see the Guardian Procedure Calls
Reference Manual to diagnose the problem, or call your service provider.
SQL 10005
Cause. An unknown sort error occurred.
Effect. The operation fails.
Recovery. None. This is an internal error. Contact your service provider.
SQL 10006
Cause. A previous I/O failed during a nowaited scratch file I/O operation.
Effect. The operation fails.
Recovery. None. Retry the operation or contact your service provider.
SQL 10007
Cause. An I/O error occurred during a scratch file I/O operation.
Effect. The operation fails.
Recovery. See the Guardian Procedure Calls Reference Manual to diagnose and
correct the problem, or contact your service provider.
10004 Sort failed while generating intermediate runs with
sort error value1 and system error value2.
10005 Sort encountered an unexpected error.
10006 A previous IO to a scratch file failed.
10007 Sort failed while writing to a scratch file with error
system error.