The following messages are observed in event_log that suggest some issues with the hints file:
Warning 2018-02-01 16:48:38.914380 29382 3826603872 Poster: 15054 - Table "OWNER"."TABLE_NAME" found in hints file. This table not currently being replicated. (posting from SID1, queue QUEUE_NAME, to SID2) [module opo]
Notice 2018-02-01 16:48:38.914807 29382 3826603872 Poster: 15057 - No hints loaded. (posting from SID1, queue QUEUE_NAME, to SID2) [module opo]
.
.
When you see the message “Poster: 15057 - No hints loaded.”, it signifies that some or all of the hints in the hints file result in a non-actionable hint. Some of the common reasons for this could be:
1. Tables are no longer in replication even though they are listed in the config file (for example, they may have been dropped and recreated on source whereby due to a change in the object id, they are now rendered out of replication)
2. The index specified in the hints file does not exist or is too stale (due to statistics not collected in a very long time)
There can be many other reasons.
As for the specific reasons above, the following steps can be tried to correct the problem:
1. Make a copy of the currently active config file and activate the copy. This will ensure that those tables listed in the active config file which are not replicating anymore for whatever reasons will now be brought into replication.
2. Analyze the indexes used in the hints.SID file
As mentioned above, there can be other reasons causing the warning and may require different resolution.
