In this blog post, let’s learn about the error message “11222 The operation failed because the Java Virtual Machine ran out of memory.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
11222 The operation failed because the Java Virtual Machine ran out of memory.
Reason for the Error
The Java Virtual Machine, hosted by an SQL/MX UDR Server, did not have enough memory to execute a Java method. This error condition will be accompanied by another condition that shows when the Java Virtual Machine encountered the error.
Solution
Stop and restart the session and retry the SQL/MX statement