Workround :
1) Debug post, to identify subque # and queue sequence # to discard -- See Solution SOL25
sp_ctrl> set param SP_OPO_DEBU_FLAG 0x01f000ff
2) start post
sp_ctrl> start post
3) monitor for post to stop by status command
sp_ctrl> status
4) When post stops, check post *opo* log for error "ORA-25402"
Example:
08-07-21 02:41:19.113049 3811 -152954656 OCI_ExecN: -1:ORA-25402: transaction must roll back
5) Find the subque# and queue # number for record that errored in poster *opo* log
Example:
Sque 2, seq 222284160637, mid 698473539, sqmid 484491547, mflags 0
6) Discard record --- See Solution SOL24445
Example:
discard 2 222284160637
Note: Message discard will cause out of sync. The table needs to be resynced.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy