-
Title
Error "Poster: failed to commit transaction session 4 in CommitFunc(): ORA-12034: materialized vi -
Description
The following errors are observed in target event log:
Error 2010-04-24 21:25:56.373074 32500 4119399328 s:4 Poster: failed to commit transaction session 4 in CommitFunc(): ORA-12034: materialized view log on "OWNER"."TABLE_NAME" younger than last refresh. Will exit Post.. (posting from NAME1, queue QUEUE_NAME, to NAME2) [module opo]
Error 2010-04-24 21:25:56.372466 32500 4119399328 s:4 Poster: 12070 - OCITransCommit failed with ORA-12034. (posting from NAME1, queue QUEUE_NAME, to NAME2) [module osp]
 -
Cause
Some of the common causes are:
Earlier refresh failed
Applied DDL on master table and the DDL changes don't go to the materialized view log (truncate, alter partitions, etc)
 -
Resolution
The problem occurs when materialized views exist on underlying replicating tables on target.
WORKAROUND 1:
Drop and recreate the materialized view in question. If the underlying tables are very large, this can take time. Once done, restart Post.WORKAROUND 2:
Ignore posting on the problem table(s). See Solution # SOL17610 for disabling posting on target tables for the time being. When posting is enabled on problem tables, deal with materialized views and fix their problems.Contact Support if the above do not help.
Â