In this blog post, let’s learn about the error message “20185 More than one partition resides on volume volume name. The MODIFY utility does not know which partition to move or drop.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
20185 More than one partition resides on volume volume name. The MODIFY utility does not know which partition to move or drop.
Reason for the Error
You specified only the volume name in the LOCATION clause, but the object has more than one partition in the specified volume.
Solution
Correct the sections in the format file and resubmit