In this blog post, let’s learn about the error message “10101 operator failed to create a scratch file. FILE_CREATE_ returned error number.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
10101 operator failed to create a scratch file. FILE_CREATE_ returned error number.
Reason for the Error
The query operator was unable to create a scratch file.
Solution
Contact your service provider to diagnose the cause of the FILE_CREATE_ returned error and correct the problem