HPE NonStop SQL/MX Error – 1185 The location name is either invalid or missing.

In this blog post, let’s learn about the error message “1185 The location name is either invalid or missing.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

1185 The location name is either invalid or missing.

Reason for the Error

A partition location is either invalid or missing.

Solution

Specify the correct location for all partitions involved in the affected command