In this blog post, let’s learn about the error message “21074 IDENTITY column on target table has IDENTITY specifications that are incompatible with corresponding IDENTITY column on source table.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
21074 IDENTITY column on target table has IDENTITY specifications that are incompatible with corresponding IDENTITY column on source table.
Reason for the Error
The sequence generator specifications of source and target tables do not match.
Solution
This error is returned when the following conditions are not met. Ensure that these conditions are met, and retry FASTCOPY operation.
If the IDENTITY column of target table is defined as GENERATED ALWAYS, the source table IDENTITY column must be defined as GENERATED ALWAYS.
If the IDENTITY columns of source and target tables are defined as GENERATED ALWAYS, their sequence generator attributes must be identical.
If the IDENTITY columns of source and target tables are defined as GENERATED ALWAYS, their IDENTITY column positions must match
