Dynamics CRM 2016: Generic SQL Error searching for contacts

Problem

In CRM when searching for a contact via quick find or on a lookup control, a Generic SQL error pop’s up.

Story

A column was recently added to the quick find view to enable users to search on that field when searching for contacts. This introduced the Generic SQL error behavior which required tracing to find the real issue.

Tracing Log

Exception when executing query: WITH __QuickFind__ as (select top 10001 [ContactId] from (

SELECT “contact0”.[Key] AS [ContactId] FROM ContainsTable([ContactBase], ( EMailAddress2, MobilePhone, LastName, FullName, FirstName, EMailAddress1), ‘(((“test*” OR FORMSOF(FREETEXT, “test”))) OR (“*test”))’) AS “contact0”) as [__QuickFindInternal__])

Exception: System.Data.SqlClient.SqlException (0x80131904): Full-text table or indexed view has more than one LCID among its full-text indexed columns.

The Fix

Log on the SQL server, open the Dynamics CRM database and follow this steps:

  • Navigate to the Contact table
  • Left click on the table
  • Navigate to Full-text index
  • Click on properties
  • Select Columns
    •  Make sure the Language for Word Breaker is the same.

sql1 sql2

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Workflow Elements by Aiden Kaskela

Business Solutions (CRM) MVP, Contractor, Evangelist

MSDYNAMICSBLOG BY DEEPESH

Real Experiences from Analyzing, Architecting, developing and working with Dynamics CRM, Dynamics 365 and sometimes .net

Mark Margolis's Blog

It's about Software, CRM, Product Development and sometimes Food.

GT // CRM

Gareth Tucker on Microsoft Dynamics CRM

Donna Edwards

Sharing my Journey with Dynamics 365

The WordPress.com Blog

The latest news on WordPress.com and the WordPress community.

%d bloggers like this: