HPE NonStop SQL/MX Error – 20686 Duplicate source location location was specified.

In this blog post, let’s learn about the error message “20686 Duplicate source location location was specified.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

20686 Duplicate source location location was specified.

Reason for the Error

Duplicate source location is specified.

Solution

Specify unique source location, and retry rename operation using MODIFY command