In this blog post, let’s learn about the error message “1154 Cannot create object object-name as the table size is too big to fit on the system.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1154 Cannot create object object-name as the table size is too big to fit on the system.
Reason for the Error
NonStop SQL/MX could not create the object because the requested table size is bigger than the total amount of disk space available on the cluster.
Solution
Check that the table size requested fits the cluster, and then retry the statement