In this blog post, let’s learn about the error message “10004 Sort failed while generating intermediate runs with sort error value1 and system error value2.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
10004 Sort failed while generating intermediate runs with sort error value1 and system error value2.
Reason for the Error
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.
Solution
Do not attempt recovery. Contact your service provider
