MultiTerm API fuzzy search error - Incorrect syntax near the keyword 'and'

Hi all,

after upgrading to GroupShare 2014, we are getting an error when we try to perform a fuzzy search through the MultiTerm API. The error message is this:

Incorrect syntax near the keyword 'and'

Normal (non fuzzy) search works fine with the same parameters.

These are the application versions we have:

Sdl.Multiterm.MatrixCacheSrvc.exe: 11.0.1062 ExecutionService.exe, ApplicationService.exe: 1.2.3634

Do you have an idea if this is a bug or maybe I'm using some wrong parameters?

(For me, this seems to be an MSSQL error message with an SQL query)

 

Thanks in advance,

Tamas Meszaros

Parents Reply Children
  • Thanks, in the meantime I have also create a minimum code to reproduce the issue:

    var app1 = new SDL.Multiterm11.Application();

               string user = Console.ReadLine();

               string password = Console.ReadLine();

               var repo = app1.ServerRepository;

               try

               {

                   repo.Location = "http://localhost";

                   repo.Connect(user, password);

                   var tb =

                       repo.Termbases.OfType<SDL.Multiterm11.ITermbase>().FirstOrDefault(t => t.Name.StartsWith("Test"));

                   if (tb == null)

                       Console.WriteLine("Termbase not found");

                   tb.Search.SearchExpression = "elev";

                   tb.Search.FuzzySearch = true;

                   tb.Search.SourceIndex = "Deutsch";

                   tb.Search.TargetIndex = "Deutsch";

                   tb.Search.MaximumHits = 25;

                   tb.Search.StartingEntryID = 0;

                   tb.Search.LastTerm = "";

                   tb.FilterDefinitions.OfType<IFilterDefinition>().First(f => f.Name == "Test_filter").Active = true;

                   foreach (HitTerm ht in tb.Search.Execute())

                   {

                       Console.WriteLine(ht.Text);

                   }

               }

               finally

               {

                   repo.Disconnect();

               }