In this blog post, let’s learn about the error message “20294 The partition cannot be reused because the partition contains data and the table has an enabled DELETE trigger.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
20294 The partition cannot be reused because the partition contains data and the table has an enabled DELETE trigger.
Reason for the Error
The partition that you specified in the partition management request contains data, and the specified base table has an enabled DELETE trigger. The REUSE operation is not allowed on such a partition.
Solution
Disable all triggers on the table and retry the REUSE operation