HPE NonStop SQL/MX Error – 20185 More than one partition resides on volume volume name. The MODIFY utility does not know which partition to move or drop.

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