HPE NonStop SQL/MX Error – 1147 System-generated column column-name of base table table-name cannot appear in a unique or primary key constraint.

Data 5 Views 1 Min Read

In this blog post, let’s learn about the error message “1147 System-generated column column-name of base table table-name cannot appear in a unique or primary key constraint.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

1147 System-generated column column-name of base table table-name cannot appear in a unique or primary key constraint.

Reason for the Error

You tried to create a unique or primary key constraint on the SYSKEY column.

Solution

Do not use the SYSKEY as part of the unique or primary key

Tags: