In this blog post, let’s learn about the error message “20183 The key value definition contains an invalid character string (value column-value).” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
20183 The key value definition contains an invalid character string (value column-value).
Reason for the Error
The data type of the specified partitioning key value column-value was incompatible with the character type of the corresponding partitioning key column.
Solution
Correct the partitioning key value and resubmit