Reader is running
event_log shows:
Notice 2011-02-28 06:00:28.549358 23350 4120098496 Reader: 11009 - GetKeyValues failed: ORA-01008: not all variables bound. (from st4prod1) [module ord]
Config file was set up with wildcard to replicate at schema level. Datapump was run at schema level, it created "TEMP tables that were automatically added to shareplex replication (because config file used wildcard). Later there was an update happening on this table. Since the table did not have any PK/UK, the reader had to query oracle to fetch keys. However the table was already dropped from the database after datapump job finished thus the fetch key gets error.
For now reader will just move on and there will be incomplete keyset and OOS on this table but it should not matter as this is a temporary table. It is OK to ignore this error as long as it on in these temp tables.
To avoid this issue in the future, edit the config file to exclude these datapump tables from replication.
To exclude tables:
================
An exclusion list may be included to further refine the set of tables. The exclusion list follows the table specification and is indicated by the keyword not.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center