HPE NonStop SQL/MX Error – 11212 Specified signature is invalid. Reason: Java signature size is more than supported.

In this blog post, let’s learn about the error message “11212 Specified signature is invalid. Reason: Java signature size is more than supported.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

11212 Specified signature is invalid. Reason: Java signature size is more than supported.

Reason for the Error

In a CREATE PROCEDURE statement, the Java signature size exceeded the maximum supported size. The currently supported maximum Java signature size is 8,192 characters. Possible causes include an incorrect signature specified in the EXTERNAL NAME clause or a large number of parameters in the Java method.

Solution

Verify that your Java method signature size is less than the supported maximum, and resubmit