HPE NonStop SQL/MX Error – 1193 Internal first key size is size bytes; it exceeds the maximum of limit bytes.

In this blog post, let’s learn about the error message “1193 Internal first key size is size bytes; it exceeds the maximum of limit bytes.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

1193 Internal first key size is size bytes; it exceeds the maximum of limit bytes.

Reason for the Error

The internal form of a first key specification for a partition is larger than the metadata can accommodate.

Solution

Reduce the size of the first key specification and then resubmit