In this blog post, let’s learn about the error message “1085 The calculated key length is greater than maximum-key-length.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1085 The calculated key length is greater than maximum-key-length.
Reason for the Error
The length of the primary key, which is calculated by the number of primary key columns and their data types, exceeds the maximum length.
Solution
Ensure that the key length is less than the maximum bytes allowed and resubmit. If a trigger is created on a table that has a primary key with a length greater than the maximum key length, error 1085 and error 1041 are returned
