HPE NonStop SQL/MX Error – 20150 Since the source and target have the same catalog and schema, the source and the target names in index map and constraint map must be unique. DUP cannot be performed.

In this blog post, let’s learn about the error message “20150 Since the source and target have the same catalog and schema, the source and the target names in index map and constraint map must be unique. DUP cannot be performed.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

20150 Since the source and target have the same catalog and schema, the source and the target names in index map and constraint map must be unique. DUP cannot be performed.

Reason for the Error

The source and target names in the index-map or the constraint-map are the same.

Solution

Fix the index-map or constraint-map clause and resubmit