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
