I have a design master with two replicas that use direct sync. It has
worked
for years with no problems other than the occasional corruption which I
have
fixed. Recently replication stopped working and I get the error "The
search
key was not found in any record." As far as I can tell there is no
corruption. I can im****t all of the data into a database and everything
compacts and repairs fine. I've tried completely rebuilding the
replication
with a new design master and new replicas. When I do this it may last a
day
or it may last a week but eventually the same error returns. It seems
like I
will get the error with one replica then it will spread to the other.
I've
read a lot of posts where people had this problem but have not seen any
clear
cut answers.
- I don't think there is corruption.
- No memo fields are indexed.
- All 3 replicated databases are using the same system.mdw file. (same
copy
in 3 locations)
