HPE NonStop SQL/MX Error – 20683 The target map target-map has mapped source location source-location to target-location which already exists.

In this blog post, let’s learn about the error message “20683 The target map target-map has mapped source location source-location to target-location which already exists.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

20683 The target map target-map has mapped source location source-location to target-location which already exists.

Reason for the Error

Specified target map generates an existing target location.

Solution

Modify target map to generate non-existing target locations, and retry rename operation using MODIFY command