In this blog post, let’s learn about the error message “1670 External usernames are not configured.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1670 External usernames are not configured.
Reason for the Error
A CREATE USER command was attempted and the EXTERNAL_NAME_CASESENSITIVE CQD is not present in the SYSTEM_DEFAULTS table. An external username can be created only when that CQD is present in the SYSTEM_DEFAULTS table with the value ON or OFF.
Solution
Insert a row for EXTERNAL_NAME_CASESENSITIVE with ON or OFF value. Insert this value manually or use the InstallSqlmx –e command and then retry the command