HPE NonStop SQL/MX Error – 11217 Java execution: Data overflow occurred while retrieving data at parameter position parameter number. Value is truncated.

In this blog post, let’s learn about the error message “11217 Java execution: Data overflow occurred while retrieving data at parameter position parameter number. Value is truncated.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

11217 Java execution: Data overflow occurred while retrieving data at parameter position parameter number. Value is truncated.

Reason for the Error

During execution of a CALL statement, numeric or string overflow occurred while processing the stored procedure output value returned in parameter parameter number.

Solution

Increase the field size of the SQL data type for the specified parameter