In this blog post, let’s learn about the error message “2221 SQL compiler invocation failed with return code error code.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
2221 SQL compiler invocation failed with return code error code.
Reason for the Error
You invoked mxCompileUserModule on an application file to SQL compile its module definitions. This command invoked MXCMP, which returned error code, indicating an abnormal termination.
Solution
If the system is heavily loaded, retry the command later. If the problem persists under normal system load, report it as an internal error and contact your service provider
