Post reply

Transactional Replication Sync Error:Cannot use a CONTAINS or FREETEXT predicate

  • April 4, 2019 at 3:29 pm

    #2783952

    I'm very new to this stuff and have been tasked with doing something out of my skill set currently, but, guess I'm learning. Ok, I have 4 SQL 2017 Development edition servers setup and are named as follows: MC-SB01, MC-SB02, SDC-SB01 and SDC-SB02. SDC-SB01 is acting as a central subscriber in which data is being pushed to the DB "ProdReplica".

    I'm using the AdventureWorks2012 sample database for testing and including all tables, views, stored procs et. as articles. During the sync, the HumanResources.JobCadidate table is giving me an error message as noted below. What I'm not understanding here is, is this message referring to the publisher side or the subscriber side? I'm not sure if I need to rebuild the index on that table or not. I'm also not too sure how to rebuild a Full-Text index.

    "Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'HumanResources.JobCandidate' because it is not full-text indexed."

  • April 4, 2019 at 5:25 pm

    #2792602

    If full-text search is installed and enabled on the subscriber, I would check check the full-text setting for the publication.

    Right click on the publication, select properties, then go to Articles. Select the table or view HumanResources.JobCandidate and then click on Article Properties on the right. Go down to Copy Full text indexes and make sure that is set to true.

    I think you may need to generate a new snapshot after that change (if you had to set it to true).

    Sue

  • April 4, 2019 at 6:54 pm

    #2799406

    Thank you for your response. Your solution seemed to do the trick. I didn't even realize all that was there. I keep getting amazed how how many levels deep SSMS dialog boxes can be.

    • This reply was modified 5 years, 9 months ago by  SQLDude.

  • October 10, 2023 at 6:37 am

    #4304876

    I have a similar issue, but in my case the articles are configures with Copy full text indexes. Still i don't get neither the full text catalog nor the index on the subscriber, what can be wrong?

    Edit: Ignore, i was actually missing the index on the publisher on my testing environment.

    • This reply was modified 1 year, 2 months ago by  peto.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply