HPE NonStop SQL/MX Error – 20685 Existing location location matches multiple patterns.

In this blog post, let’s learn about the error message “20685 Existing location location matches multiple patterns.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

20685 Existing location location matches multiple patterns.

Reason for the Error

Multiple Guardian File Name patterns are specified and an existing location matches more than one of these patterns.

Solution

Modify the patterns and ensure that each pattern matches a unique set of source locations, and retry rename operation using MODIFY command