The following warning messages are observed in event log for a table that is not currently being replicated:
05/03/10 16:13 Warning: 15054 - Table " OWNER "." NAME " found in hints file. This table not currently being replicated. [sp_opst (for o.SID1-o.SID2 queue QUEUE_NAME)/17924264]
The table has been taken out of replication but its entry still exists in the hints file
The messages in themselves will not cause any errors except for the extra logging that occurs because the table has been taken out of replication but its entry still exists in the hints.SID file (located in $SP_SYS_VARDIR/data directory). Since the messages can inundate the event_log and consequently obscure any other errors, the entry for the table should be removed from the hints.SID file as follows:
1. Stop the Post process before editing the hints file:
sp_ctrl>stop post
sp_ctrl>exit
2. Comment out or remove the entry for the table
3. Start Post:
The messages will not show up anymore.
sp_ctrl>start post
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy