In this blog post, let’s learn about the error message “30026 NOT ATOMIC rowset INSERT is not supported on a table that has dependent indexes that are not offline. Dependent index index-name exists for table table-name.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
30026 NOT ATOMIC rowset INSERT is not supported on a table that has dependent indexes that are not offline. Dependent index index-name exists for table table-name.
Reason for the Error
You attempted to use NOT ATOMIC inserts on a table that has at least one dependent index. Dependent indexes might have been created by the system to enforce a uniqueness or primary key constraint.
Solution
Do not attempt recovery. Contact your service provider