HPE NonStop SQL/MX Error – 1651 External username external-user-name is already associated with another user.

In this blog post, let’s learn about the error message “1651 External username external-user-name is already associated with another user.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

1651 External username external-user-name is already associated with another user.

Reason for the Error

You specified an external username in the CREATE USER command that is already associated with another Guardian user in the metadata.

Solution

Specify a different external username in the CREATE USER command and retry the command