HPE NonStop SQL/MX Error – 20127 Target option was specified as NEW but object-type exists. DUP operation failed.

In this blog post, let’s learn about the error message “20127 Target option was specified as NEW but object-type exists. DUP operation failed.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

20127 Target option was specified as NEW but object-type exists. DUP operation failed.

Reason for the Error

The target name you specified was not valid.

Solution

Specify TARGET PURGE for an existing target object and resubmit