In this blog post, let’s learn about the error message “1150 Table table-name was not created because Partition Overlay Support could not generate volume names for the partitions to reside on.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1150 Table table-name was not created because Partition Overlay Support could not generate volume names for the partitions to reside on.
Reason for the Error
When the Partition Overlay Support feature is enabled without setting volume names (through CQD POS_LOCATIONS) for table partitions to reside on, location names are generated automatically. However, NonStop SQL/MX could not generate the location names automatically and, because the CQD POS_RAISE_ERROR is set, the table is not created.
Solution
To correct the error, choose a recovery method:
Verify that the disk volumes are available on the current node and retry the request.
Specify the volume names where the partitions need to be created for the given CREATE TABLE statement through CONTROL QUERY DEFAULT POS_LOCATIONS, and then retry the request.
Do not set the CQD POS_RAISE_ERROR, in which case, a simple table without partitions is created when the volume names cannot be generated
