Informix Error -9667: Cannot complete operation on updatable secondary when STOP_APPLY is nonzero.
Cause and resolution
Cannot complete operation on updatable secondary when STOP_APPLY is nonzero.
You cannot perform the desired operation on an updatable secondary if STOP_APPLY is set to a nonzero value. To allow the operation to work, STOP_APPLY needs to be set to zero on the secondary server which you are connecting to.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-9667 fires when an operation is attempted on an updatable secondary server while STOP_APPLY is set to a nonzero value.
- STOP_APPLY is nonzero on the secondary server being connected to, per the official guidance.
Solutions / Resolution
- Set STOP_APPLY to zero on that secondary server, then retry, per the official guidance.
Diagnostic Checks
- Check the STOP_APPLY setting on the secondary you are connected to.
Related Errors / Related Topics
No closely related error codes are cross-referenced for -9667 in this set yet.
STOP_APPLY is nonzero on the updatable secondary — set it to zero.