-
Title
reader error message -
Description
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]
-
Cause
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.
-
Resolution
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.
-
Additional Information
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.For example:
expand scott.prod% not (%temp%) hal.% sysa@o.sidbwill cause SharePlex to activate all tables owned by “SCOTT”, where the table_name is like “PROD%” and the table_name is not like “%TEMP%”. All the tables that match this description will be replicated to the same table_name on the target, owned by “HAL”.