Post is stopping with Error. Event_log shows
02/13/07 03:42 Notice: ORA-01403: no data found. [sp_opst(osp)/21782]
02/13/07 03:42 Error: Unexpected Oracle error: ORA-01403: no data found. in opo_access7.c:1444 [sp_opst(osp)/21782]
opo.log debug or qview (oread set dout) show that post is stopping on a DDL with odr_flag = 0x8
This error can occur when a source table is being replicated to a target synonym and a DDL changing next extent size is issued on the source table. This can happen regardless whether DDL replication is enabled or disabled.
When ddl issued on source changing next extent size on the source table, the shareplex post process issues a query on target to check whether this target table is in a dictionary tablespace or locally managed tablespace. Since this table does not exist on target (it's a synonym), post receives error ORA-01403. Even if you have disabled ddl replication on source, shareplex still sends ddl messages to target. However the ddl message will have a ODR_FLAG of 0x8 which tells post not to apply this ddl message. But post still prepares for the ddl statement and checks whether target table is dictionary tablespace or locally managed tablespace if ddl is extent management related.
1. To correct this problem, replicate from table to table not from table to synonym.
2. If this cannot be done, then the only option is to read release the ddl from post queue.
3. If this happens in replication from dictionary to locally managed, then the only work around is to read release the ddl from the post queue.
Note: If O7_DICTIONARY_ACCESSIBILITY is set to FALSE on target database, you may need to do the following if you are also getting error on table or view does not exist.
1. If this is 9i and above, grant select any dictionary to <shareplex user>;
2. If this is 8i, grant select_catalog_role to <shareplex user>;
This can also happen when replicating from dictionary to locally managed tablespaces
