0 Replies Latest reply on Feb 20, 2019 1:18 PM by Pratik kp

    FTS search issue in CaseHR

    Pratik kp
      Share This:

      Hello Everyone,


      Greetings to all!


      This time I have query for FTS in case HR application.


      All the searches related to FTS are working fine but CASE-HR is not returning one of Solution article record in search results e.g if Solution article title is

      "Employee Payroll Process" then it does not returns that solution article when I do a search with a word either Employee or process or payroll as a search keyword.

      However,this search with earlier mentioned words does returns other Solution articles which have words like Employee or process or payroll but not the problematic article.


      I have tried following workaround but none of it have fixed this issue ->

      1. Re-indexing that record
      2. Increasing FTS threshold till 60K
      3. In API+SQL logs I could see that a temporary table is getting created and also a corresponding SQL query which is triggered by FTS search is also correct.


      Can someone please help me understand how I can investigate this issue?


      AR version is 9.1.x and there are two AR servers in a group one is indexer and the other is a searcher.


      Thank you.