In this blog post, let’s learn about the error message “1246 The supplied partition key value (key-value) is inconsistent with the data type of column column-name of object object-name.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1246 The supplied partition key value (key-value) is inconsistent with the data type of column column-name of object object-name.
Reason for the Error
A utility command specified a key value that is inconsistent with the data type of the column that corresponds to the key value.
Solution
Specify valid key values and resubmit