Hi Tamàs,

Does this error persist after updating to GroupShare 2014 SP1 and MultiTerm 2014 SP1?

Also did the same query work on GS 2011? (I assume yes but just to look at options here as we did not change anything in this area from what I can see so this is a bit odd).

Thanks

Daniel

Hi Daniel,

sorry for the late answer, so this client does not have SP1, but now, the same error appears at another client, where GS 2014 SP1 is installed. Do you have an idea how to discover the reason? For me, this seems to be an SQL command error.

thanks,

Tamas

Hi Daniel,

sorry for the late answer, so this client does not have SP1, but now, the same error appears at another client, where GS 2014 SP1 is installed. Do you have an idea how to discover the reason? For me, this seems to be an SQL command error.

thanks,

Tamas

In the meantime, I have let SQL server log the problematic queries, this is what I have found (after a fuzzy search with a filter):

select origterm, termid, conceptid from [I_Deutsch] where termid IN (534885,534910,534837,527937,504250,504229 and ( (conceptid in (select entryid from mtFieldsValues where [index] = N'Deutsch' and [level] = 1 and [path] = N'dG[d/@type=''Fachgebiet'']/d' and [complete_value] like N'%Client%' escape '\' ))))

It is clear that a closing bracket is missing before the bold and.

The query after the problematic "and" seems to be related to entry filters. I tried the same search without an entry filter as well, and this time it worked. So the problem arises only with fuzzy search and entry filter at the same time.

Can you please look after this?

Thanks,

Tamas

Hi Tamas,

Thank you for the additional information on this. We will look at this and get back to you.

Cheers,

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();

           }