Post is stopped due to error with following messages appearing in event_log:
Error 2017-04-28 22:55:25.625014 3815 1246333248 s:2 Poster: failed to commit transaction session 2 in CommitFunc(): ORA-02091: transaction rolled back.ORA-02292: integrity constraint (OWNER.CONSTRAINT_NAME) violated - child record found. Will exit Post.. (posting from SID1, queue queue_name, to SID2) [module opo]
Error 2017-04-28 22:55:25.561402 3815 1246333248 s:2 Poster: 12070 - OCITransCommit failed with ORA-2091. (posting from SID1, queue queue_name, to SID2) [module osp]
Carry out the following workaround:
1. Disable referential integrity constraint on the target.
2. Start Post
3. Once the queue drains out, run repair on the parent and child tables during period of lean activity and re-enable the constraint.
If acceptable, at a convenient time in future you can try to redefine the constraint as immediate on target side. But to get around the problem, the constraint will need to be disabled for the queue to drain.
