Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Product Lookup throws ...
Microsoft Dynamics CRM (Archived)

Product Lookup throws generic SQL Error

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi guys,

I have upgraded an On-Prem CRM from 2011 to 2016. Earlier it was accessible only from company network now it is available on the internet(no adfs)using SSL

Problem is that whenever you try to add a Line item by typing a name and clicking on the search icon in the lookup control, it throws a generic SQL Server error.

If you simply scroll without typing anything it works fine. Same thing happened when I tried to add product to the Orders.

This is not happening for any other entity.
The same problem occurs on the upgraded organization as well as the trial organization created during Install

8637.Opportunity.png

6180.Order.png

Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=8.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: Generic SQL error.Detail: 
<OrganizationServiceFault xmlns:i="www.w3.org/.../XMLSchema-instance" xmlns="schemas.microsoft.com/.../Contracts">
  <ErrorCode>-2147204784</ErrorCode>
  <ErrorDetails xmlns:d2p1="schemas.datacontract.org/.../System.Collections.Generic" />
  <Message>Generic SQL error.</Message>
  <Timestamp>2016-09-30T11:59:21.4443823Z</Timestamp>
  <InnerFault i:nil="true" />
  <TraceText i:nil="true" />
</OrganizationServiceFault>


Has somebody else faced a similar issue, any help will be  welcomed

*This post is locked for comments

  • Dennis G Profile Picture
    Dennis G 25 on at
    RE: Product Lookup throws generic SQL Error

    I'm not the deep-dive technical guy... but:

    If you can do without the full text search for 48 hours, it won't hurt to try. Sounds like a message something a corrupt index might cause..

  • Joe Woltering Profile Picture
    Joe Woltering 12,161 on at
    RE: Product Lookup throws generic SQL Error

    This is interesting. Do you think this would work in the case where I am receiving 'Invalid column name' in my trace, even though I have checked and verified the existence of said columns?

  • Suggested answer
    Dennis G Profile Picture
    Dennis G 25 on at
    RE: Product Lookup throws generic SQL Error

    In my specific case, rebuilding the full text index seemed to have solved so problem (by disabling full text indexing via the system settings, waiting 24 hours, re-enabling indexing, waiting 24 hours again).

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Product Lookup throws generic SQL Error

    Hello,
    I have the same problem, have you solved it?
    If you can share with me, thank you.

  • Dennis G Profile Picture
    Dennis G 25 on at
    RE: Product Lookup throws generic SQL Error

    Hi Sudeep,

    did figure out what the cause of this was?

    I seem to have a similar problem... the affected entity is Activities (any type) in my case, though.

    Thanks,

    Dennis

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Product Lookup throws generic SQL Error

    Thanks for pointing me to the trace logs of CRM.
    This is what I got , please any help will be much appreciated

    # CRM Tracing Version 2.0
# LocalTime: 2016-10-03 10:58:42.737
# Categories: 
# CallStackOn: No
# ComputerName: ISDBCRMAPP01
# CRMVersion: 8.0.0000.1088
# DeploymentType: OnPremise
# ScaleGroup: 
# ServerRole: AppServer, AsyncService, DiscoveryService, ApiServer, HelpServer, DeploymentService, SandboxServer, DeploymentManagementTools, VssWriter, EmailConnector

[2016-10-03 10:58:42.737] Process: w3wp |Organization:6226d5a1-6a38-48ee-9208-97b2c8c99799 |Thread: 1800 |Category: Platform.Sql |User: e8b81f7b-870b-441a-b525-9e5b9d2b414a |Level: Error |ReqId: aebfc655-80f9-4761-85ca-e617c9b2824a | BusinessProcessObject.ExecuteQuery  ilOffset = 0x4A
>Exception when executing query: WITH __QuickFind__ as (select top 10001 [ProductPriceLevelId] from (
SELECT "productpricelevel0".[ProductPriceLevelId] AS [ProductPriceLevelId] FROM [ProductPriceLevel] AS "productpricelevel0" WITH (NOLOCK)
 where ("productpricelevel0".ProductId in (select "BDL".ObjectID from BusinessDataLocalizedLabelBase BDL where 
 contains("BDL".Label, '((("fortint*" OR FORMSOF(FREETEXT, "fortint"))) OR ("fortint"))') and "BDL".LanguageId in (1033) and "BDL".ObjectColumnNumber = 6 and "BDL".ObjectIdTypeCode = 1024))
UNION 
SELECT "productpricelevel0".[ProductPriceLevelId] AS [ProductPriceLevelId] FROM [ProductPriceLevel] AS "productpricelevel0" WITH (NOLOCK)
 where ("productpricelevel0".ProductNumber like 'fortint%')) as [__QuickFindInternal__])select 
top 12 "productpricelevel0".PriceLevelId as "pricelevelid"
, "productpricelevel0".Amount as "amount"
, "productpricelevel0".UoMId as "uomid"
, "productpricelevel0".ProductId as "productid"
, "productpricelevel0".ProductNumber as "productnumber"
, "productpricelevel0".Percentage as "percentage"
, "productpricelevel0".ProductPriceLevelId as "productpricelevelid"
, "productpricelevel0".ProcessId as "processid"
, convert(bigint, "productpricelevel0".VersionNumber) as "versionnumber"
, "productpricelevel0".TransactionCurrencyId as "transactioncurrencyid"
, coalesce("LL0".Label,"productpricelevel0".ProductIdName ) as "productidname"
, "productpricelevel0".PriceLevelIdName as "pricelevelidname"
, "productpricelevel0".UoMIdName as "uomidname"
, "productpricelevel0".TransactionCurrencyIdName as "transactioncurrencyidname"
, case when (select COUNT(*) from [__QuickFind__]) = 10001 then 1 else 0 end as [__QuickFindLimitValue__]
, convert(bigint, "processidworkflowworkflowid".VersionNumber) as "processidworkflowworkflowid.versionnumber" 
from
 ProductPriceLevel as "productpricelevel0" WITH (NOLOCK) 
 left outer join BusinessDataLocalizedLabel as "LL0" on ("LL0".ObjectId = "productpricelevel0".ProductId and "LL0".LanguageId = 1033 and "LL0".ObjectColumnNumber = 6 )
 left outer join BusinessDataLocalizedLabel as "LL1" on ("LL1".ObjectId = "productpricelevel0".ProductId and "LL1".LanguageId = 1033 and "LL1".ObjectColumnNumber = 6 ) join Product as "product1" WITH (NOLOCK)  on ("productpricelevel0".ProductId  =  "product1".ProductId and (("product1".StateCode = 0 or "product1".StateCode = 3))) left outer join Workflow as "processidworkflowworkflowid" WITH (NOLOCK)  on ("productpricelevel0".ProcessId  =  "processidworkflowworkflowid".WorkflowId) 
where
 [productpricelevel0].[ProductPriceLevelId] in (select [ProductPriceLevelId] from [__QuickFind__]) and (("productpricelevel0".PriceLevelId = 'ad512cf1-5114-dd11-8f80-001e0bbd8d00')) order by
 "productpricelevel0".PriceLevelIdName asc
, "productpricelevel0".ProductPriceLevelId asc Exception: System.Data.SqlClient.SqlException (0x80131904): SQL Server encountered error 0x8007042d while communicating with full-text filter daemon host (FDHost) process. Make sure that the FDHost process is running. To re-start the FDHost process, run the sp_fulltext_service 'restart_all_fdhosts' command or restart the SQL Server instance.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at Microsoft.Crm.CrmDbConnection.InternalExecuteWithRetry[TResult](Func`1 ExecuteMethod, IDbCommand command)
   at Microsoft.Crm.CrmDbConnection.InternalExecuteReader(IDbCommand command, Boolean capturePerfTrace)
   at Microsoft.Crm.BusinessEntities.BusinessProcessObject.ExecuteQuery(CrmDbConnection dbConnection, IDbCommand command, ISqlExecutionContext context, Nullable`1 commandTimeout)
ClientConnectionId:644af856-e7d9-4c6b-8d5b-bddd232c7f42
Error Number:30046,State:1,Class:16
[2016-10-03 10:58:43.112] Process: w3wp |Organization:6226d5a1-6a38-48ee-9208-97b2c8c99799 |Thread: 1800 |Category: Platform.Sql |User: e8b81f7b-870b-441a-b525-9e5b9d2b414a |Level: Error |ReqId: aebfc655-80f9-4761-85ca-e617c9b2824a | BusinessProcessObject.DoRetrieveMultiple  ilOffset = 0x26
>Exception when executing query: WITH __QuickFind__ as (select top 10001 [ProductPriceLevelId] from (
SELECT "productpricelevel0".[ProductPriceLevelId] AS [ProductPriceLevelId] FROM [ProductPriceLevel] AS "productpricelevel0" WITH (NOLOCK)
 where ("productpricelevel0".ProductId in (select "BDL".ObjectID from BusinessDataLocalizedLabelBase BDL where 
 contains("BDL".Label, '((("fortint*" OR FORMSOF(FREETEXT, "fortint"))) OR ("fortint"))') and "BDL".LanguageId in (1033) and "BDL".ObjectColumnNumber = 6 and "BDL".ObjectIdTypeCode = 1024))
UNION 
SELECT "productpricelevel0".[ProductPriceLevelId] AS [ProductPriceLevelId] FROM [ProductPriceLevel] AS "productpricelevel0" WITH (NOLOCK)
 where ("productpricelevel0".ProductNumber like 'fortint%')) as [__QuickFindInternal__])select 
top 12 "productpricelevel0".PriceLevelId as "pricelevelid"
, "productpricelevel0".Amount as "amount"
, "productpricelevel0".UoMId as "uomid"
, "productpricelevel0".ProductId as "productid"
, "productpricelevel0".ProductNumber as "productnumber"
, "productpricelevel0".Percentage as "percentage"
, "productpricelevel0".ProductPriceLevelId as "productpricelevelid"
, "productpricelevel0".ProcessId as "processid"
, convert(bigint, "productpricelevel0".VersionNumber) as "versionnumber"
, "productpricelevel0".TransactionCurrencyId as "transactioncurrencyid"
, coalesce("LL0".Label,"productpricelevel0".ProductIdName ) as "productidname"
, "productpricelevel0".PriceLevelIdName as "pricelevelidname"
, "productpricelevel0".UoMIdName as "uomidname"
, "productpricelevel0".TransactionCurrencyIdName as "transactioncurrencyidname"
, case when (select COUNT(*) from [__QuickFind__]) = 10001 then 1 else 0 end as [__QuickFindLimitValue__]
, convert(bigint, "processidworkflowworkflowid".VersionNumber) as "processidworkflowworkflowid.versionnumber" 
from
 ProductPriceLevel as "productpricelevel0" WITH (NOLOCK) 
 left outer join BusinessDataLocalizedLabel as "LL0" on ("LL0".ObjectId = "productpricelevel0".ProductId and "LL0".LanguageId = 1033 and "LL0".ObjectColumnNumber = 6 )
 left outer join BusinessDataLocalizedLabel as "LL1" on ("LL1".ObjectId = "productpricelevel0".ProductId and "LL1".LanguageId = 1033 and "LL1".ObjectColumnNumber = 6 ) join Product as "product1" WITH (NOLOCK)  on ("productpricelevel0".ProductId  =  "product1".ProductId and (("product1".StateCode = 0 or "product1".StateCode = 3))) left outer join Workflow as "processidworkflowworkflowid" WITH (NOLOCK)  on ("productpricelevel0".ProcessId  =  "processidworkflowworkflowid".WorkflowId) 
where
 [productpricelevel0].[ProductPriceLevelId] in (select [ProductPriceLevelId] from [__QuickFind__]) and (("productpricelevel0".PriceLevelId = 'ad512cf1-5114-dd11-8f80-001e0bbd8d00')) order by
 "productpricelevel0".PriceLevelIdName asc
, "productpricelevel0".ProductPriceLevelId asc Exception: System.Data.SqlClient.SqlException (0x80131904): SQL Server encountered error 0x8007042d while communicating with full-text filter daemon host (FDHost) process. Make sure that the FDHost process is running. To re-start the FDHost process, run the sp_fulltext_service 'restart_all_fdhosts' command or restart the SQL Server instance.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at Microsoft.Crm.CrmDbConnection.InternalExecuteWithRetry[TResult](Func`1 ExecuteMethod, IDbCommand command)
   at Microsoft.Crm.CrmDbConnection.InternalExecuteReader(IDbCommand command, Boolean capturePerfTrace)
   at Microsoft.Crm.BusinessEntities.BusinessProcessObject.ExecuteQuery(CrmDbConnection dbConnection, IDbCommand command, ISqlExecutionContext context, Nullable`1 commandTimeout)
   at Microsoft.Crm.BusinessEntities.BusinessProcessObject.QueryAndFillEntityCollection(CrmDbConnection dbConnection, IDbCommand dbCommand, BusinessEntityCollection entities, EntityExpression entityExp, PagingHelper pagingHelper, Boolean useEntityExpression, String aggregateLimitExceededName, ExecutionContext context)
   at Microsoft.Crm.BusinessEntities.BusinessProcessObject.DoRetrieveMultiple(BusinessEntityCollection entities, EntityExpression entityExp, DatabaseQueryTarget queryTarget, PagingHelper pagingHelper, ExecutionContext context, Boolean needToSetRowVersion, Boolean isVersionNumberRequestedInRetrieve)
ClientConnectionId:644af856-e7d9-4c6b-8d5b-bddd232c7f42
Error Number:30046,State:1,Class:16
[2016-10-03 10:58:43.112] Process: w3wp |Organization:6226d5a1-6a38-48ee-9208-97b2c8c99799 |Thread: 1800 |Category: Exception |User: e8b81f7b-870b-441a-b525-9e5b9d2b414a |Level: Error |ReqId: aebfc655-80f9-4761-85ca-e617c9b2824a | SoapExtensionExceptionHandlerBase.PrivateGetCrmExceptionNoDependencies  ilOffset = 0x106
	at SoapExtensionExceptionHandlerBase.PrivateGetCrmExceptionNoDependencies(Exception exception)  ilOffset = 0x106
	at SoapExtensionExceptionHandlerBase.GetCrmExceptionWithoutTrace(Exception exception)  ilOffset = 0x7
	at SoapExtensionExceptionHandlerBase.GetCrmException(Exception exception)  ilOffset = 0x0
	at PluginExceptionConvertor.ConvertPluginException(Exception originalException, Boolean isAsync, Boolean unwrapTargetInvocationException)  ilOffset = 0x2A
	at PluginExceptionConvertor.ConvertPluginException(Exception originalException, String pluginTrace, String assemblyName, String pluginType, String stepIdOrWorkflowGroup, String stepDescription, Boolean isAsync, Boolean addPluginTrace, Boolean unwrapTargetInvocationException)  ilOffset = 0x29
	at PluginExceptionConvertor.ConvertPluginException(Exception originalException, String pluginTrace, String assemblyName, String pluginType, String stepIdOrWorkflowGroup, String stepDescription, Boolean isAsync, Boolean addPluginTrace)  ilOffset = 0x0
	at VersionedPluginProxyStepBase.Execute(PipelineExecutionContext context)  ilOffset = 0x65
	at Pipeline.Execute(PipelineExecutionContext context)  ilOffset = 0xDD
	at MessageProcessor.Execute(PipelineExecutionContext context)  ilOffset = 0x1E6
	at InternalMessageDispatcher.Execute(PipelineExecutionContext context)  ilOffset = 0xE4
	at ExternalMessageDispatcher.ExecuteInternal(IInProcessOrganizationServiceFactory serviceFactory, IPlatformMessageDispatcherFactory dispatcherFactory, String messageName, String requestName, Int32 primaryObjectTypeCode, Int32 secondaryObjectTypeCode, ParameterCollection fields, CorrelationToken correlationToken, CallerOriginToken originToken, UserAuth userAuth, Guid callerId, Guid callerRegardingObjectId, UserType userType, Guid transactionContextId, Int32 invocationSource, Nullable`1 requestId, Version endpointVersion)  ilOffset = 0x1F2
	at ExternalMessageDispatcher.Execute(IInProcessOrganizationServiceFactory serviceFactory, IPlatformMessageDispatcherFactory dispatcherFactory, String messageName, String requestName, Int32 primaryObjectTypeCode, Int32 secondaryObjectTypeCode, ParameterCollection fields, CorrelationToken correlationToken, CallerOriginToken originToken, UserAuth userAuth, Guid callerId, Guid callerRegardingObjectId, UserType userType, Guid transactionContextId, Int32 invocationSource, Nullable`1 requestId)  ilOffset = 0x0
	at OrganizationSdkServiceInternal.ExecuteRequestRequestWithInstrumentation(OrganizationRequest request, CorrelationToken correlationToken, CallerOriginToken callerOriginToken, WebServiceType serviceType, UserAuth userAuth, Guid targetUserId, OrganizationContext context, Boolean returnResponse, Boolean checkAdminMode, Object operation, UserType targetUserType)  ilOffset = 0x0
	at OrganizationSdkServiceInternal.ExecuteRequest(OrganizationRequest request, CorrelationToken correlationToken, CallerOriginToken callerOriginToken, WebServiceType serviceType, Boolean checkAdminMode, ExecutionContext executionContext)  ilOffset = 0x4B
	at OrganizationSdkServiceInternal.Execute(OrganizationRequest request, CorrelationToken correlationToken, CallerOriginToken callerOriginToken, WebServiceType serviceType, Boolean checkAdminMode, ExecutionContext executionContext)  ilOffset = 0x0
	at InprocessServiceProxy.ExecuteCore(OrganizationRequest request)  ilOffset = 0x34
	at PlatformCommand.XrmExecuteInternal()  ilOffset = 0xBC
	at RetrieveMultipleCommand.Execute()  ilOffset = 0x0
	at RetrieveMultipleCommand.RetrieveData()  ilOffset = 0x0
	at ApplicationQuery.ExecuteQuery()  ilOffset = 0x0
	at GridDataProviderQueryBuilder.GetData(QueryBuilder queryBuilder)  ilOffset = 0x14
	at GridDataProviderQueryBuilder.LoadQueryData()  ilOffset = 0x132
	at GridDataProviderQueryBuilder.LoadData()  ilOffset = 0x0
	at LookupService.ResolveLookupItem(Int32[] typesArray, String bindingColumns, String additionalParameters, String value, Int32 position, Boolean resolveEmailAddress, String savedQueryTypeParameter, View defaultView, String[] values, Boolean sortResults)  ilOffset = 0x12E
	at LookupService.RetrieveItem(Int32[] typesArray, String bindingColumns, String additionalParameters, String[] values, Int32[] positions, Boolean resolveEmailAddress, String savedQueryTypeParameter, String defaultViewId, Nullable`1 defaultViewType, String defaultViewFetchXml, String defaultViewLayoutXml, String[] guidValues, Boolean sortResults)  ilOffset = 0x175
	at LookupService.RetrieveInlineSearchResults(Int32[] typesArray, String bindingColumns, String additionalParameters, String[] lookupValues, Int32[] positions, Boolean resolveEmailAddress, String savedQueryTypeParameter, String defaultViewId, Nullable`1 defaultViewType, String defaultViewFetchXml, String defaultViewLayoutXml, String[] guidValues, Boolean sortResults)  ilOffset = 0x12
	at RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)  ilOffset = 0xFFFFFFFF
	at RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)  ilOffset = 0x16
	at RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)  ilOffset = 0x7F
	at LogicalMethodInfo.Invoke(Object target, Object[] values)  ilOffset = 0x3F
	at WebServiceHandler.Invoke()  ilOffset = 0xAE
	at WebServiceHandler.CoreProcessRequest()  ilOffset = 0x134
	at SyncSessionlessHandler.ProcessRequest(HttpContext context)  ilOffset = 0x3F
	at CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()  ilOffset = 0x187
	at HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)  ilOffset = 0x15
	at PipelineStepManager.ResumeSteps(Exception error)  ilOffset = 0x27A
	at HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb)  ilOffset = 0x31
	at HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context)  ilOffset = 0xB0
	at PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)  ilOffset = 0x131
	at PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)  ilOffset = 0x0
	at UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus& notificationStatus)  ilOffset = 0xFFFFFFFF
	at UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus& notificationStatus)  ilOffset = 0xFFFFFFFF
	at PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)  ilOffset = 0x1E7
	at PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)  ilOffset = 0x0
>Crm Exception: Message: Generic SQL error., ErrorCode: -2147204784, InnerException: System.Data.SqlClient.SqlException (0x80131904): SQL Server encountered error 0x8007042d while communicating with full-text filter daemon host (FDHost) process. Make sure that the FDHost process is running. To re-start the FDHost process, run the sp_fulltext_service 'restart_all_fdhosts' command or restart the SQL Server instance.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at Microsoft.Crm.CrmDbConnection.InternalExecuteWithRetry[TResult](Func`1 ExecuteMethod, IDbCommand command)
   at Microsoft.Crm.CrmDbConnection.InternalExecuteReader(IDbCommand command, Boolean capturePerfTrace)
   at Microsoft.Crm.BusinessEntities.BusinessProcessObject.ExecuteQuery(CrmDbConnection dbConnection, IDbCommand command, ISqlExecutionContext context, Nullable`1 commandTimeout)
   at Microsoft.Crm.BusinessEntities.BusinessProcessObject.QueryAndFillEntityCollection(CrmDbConnection dbConnection, IDbCommand dbCommand, BusinessEntityCollection entities, EntityExpression entityExp, PagingHelper pagingHelper, Boolean useEntityExpression, String aggregateLimitExceededName, ExecutionContext context)
   at Microsoft.Crm.BusinessEntities.BusinessProcessObject.DoRetrieveMultiple(BusinessEntityCollection entities, EntityExpression entityExp, DatabaseQueryTarget queryTarget, PagingHelper pagingHelper, ExecutionContext context, Boolean needToSetRowVersion, Boolean isVersionNumberRequestedInRetrieve)
   at Microsoft.Crm.BusinessEntities.BusinessProcessObject.DoRetrieveMultiple(BusinessEntityCollection entities, EntityExpression entityExp, DatabaseQueryTarget queryTarget, ExecutionContext context, Boolean needToSetRowVersion, Boolean isVersionNumberRequestedInRetrieve)
   at Microsoft.Crm.BusinessEntities.BusinessProcessObject.RetrieveMultiple(EntityExpression entityExpression, DatabaseQueryTarget queryTarget, ExecutionContext context)
   at Microsoft.Crm.BusinessEntities.BusinessProcessObject.RetrieveMultiple(EntityExpression entityExpression, ExecutionContext context)
ClientConnectionId:644af856-e7d9-4c6b-8d5b-bddd232c7f42
Error Number:30046,State:1,Class:16
[2016-10-03 10:58:43.159] Process: w3wp |Organization:6226d5a1-6a38-48ee-9208-97b2c8c99799 |Thread: 1800 |Category: Platform.Sdk |User: e8b81f7b-870b-441a-b525-9e5b9d2b414a |Level: Error |ReqId: aebfc655-80f9-4761-85ca-e617c9b2824a | VersionedPluginProxyStepBase.Execute  ilOffset = 0x65
>Web Service Plug-in failed in SdkMessageProcessingStepId: {50CCBB1B-EA3E-DB11-86A7-000A3A5473E8}; EntityName: productpricelevel; Stage: 30; MessageName: RetrieveMultiple; AssemblyName: Microsoft.Crm.Extensibility.InternalOperationPlugin, Microsoft.Crm.ObjectModel, Version=8.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35; ClassName: Microsoft.Crm.Extensibility.InternalOperationPlugin; Exception: Unhandled Exception: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation.
   at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
   at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
   at System.Web.Services.Protocols.LogicalMethodInfo.Invoke(Object target, Object[] values)
   at Microsoft.Crm.Extensibility.InternalOperationPlugin.Execute(IServiceProvider serviceProvider)
   at Microsoft.Crm.Extensibility.V5PluginProxyStep.ExecuteInternal(PipelineExecutionContext context)
   at Microsoft.Crm.Extensibility.VersionedPluginProxyStepBase.Execute(PipelineExecutionContext context)
Inner Exception: System.Data.SqlClient.SqlException: SQL Server encountered error 0x8007042d while communicating with full-text filter daemon host (FDHost) process. Make sure that the FDHost process is running. To re-start the FDHost process, run the sp_fulltext_service 'restart_all_fdhosts' command or restart the SQL Server instance.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at Microsoft.Crm.CrmDbConnection.InternalExecuteWithRetry[TResult](Func`1 ExecuteMethod, IDbCommand command)
   at Microsoft.Crm.CrmDbConnection.InternalExecuteReader(IDbCommand command, Boolean capturePerfTrace)
   at Microsoft.Crm.BusinessEntities.BusinessProcessObject.ExecuteQuery(CrmDbConnection dbConnection, IDbCommand command, ISqlExecutionContext context, Nullable`1 commandTimeout)
   at Microsoft.Crm.BusinessEntities.BusinessProcessObject.QueryAndFillEntityCollection(CrmDbConnection dbConnection, IDbCommand dbCommand, BusinessEntityCollection entities, EntityExpression entityExp, PagingHelper pagingHelper, Boolean useEntityExpression, String aggregateLimitExceededName, ExecutionContext context)
   at Microsoft.Crm.BusinessEntities.BusinessProcessObject.DoRetrieveMultiple(BusinessEntityCollection entities, EntityExpression entityExp, DatabaseQueryTarget queryTarget, PagingHelper pagingHelper, ExecutionContext context, Boolean needToSetRowVersion, Boolean isVersionNumberRequestedInRetrieve)
   at Microsoft.Crm.BusinessEntities.BusinessProcessObject.DoRetrieveMultiple(BusinessEntityCollection entities, EntityExpression entityExp, DatabaseQueryTarget queryTarget, ExecutionContext context, Boolean needToSetRowVersion, Boolean isVersionNumberRequestedInRetrieve)
   at Microsoft.Crm.BusinessEntities.BusinessProcessObject.RetrieveMultiple(EntityExpression entityExpression, DatabaseQueryTarget queryTarget, ExecutionContext context)
   at Microsoft.Crm.BusinessEntities.BusinessProcessObject.RetrieveMultiple(EntityExpression entityExpression, ExecutionContext context)
.
[2016-10-03 10:58:43.159] Process: w3wp |Organization:6226d5a1-6a38-48ee-9208-97b2c8c99799 |Thread: 1800 |Category: Exception |User: e8b81f7b-870b-441a-b525-9e5b9d2b414a |Level: Error |ReqId: aebfc655-80f9-4761-85ca-e617c9b2824a | SoapExtensionExceptionHandlerBase.PrivateGetCrmExceptionNoDependencies  ilOffset = 0x106
	at SoapExtensionExceptionHandlerBase.PrivateGetCrmExceptionNoDependencies(Exception exception)  ilOffset = 0x106
	at SoapExtensionExceptionHandlerBase.GetCrmExceptionWithoutTrace(Exception exception)  ilOffset = 0x7
	at SoapExtensionExceptionHandlerBase.GetCrmException(Exception exception)  ilOffset = 0x0
	at VersionedPluginProxyStepBase.Execute(PipelineExecutionContext context)  ilOffset = 0x65
	at Pipeline.Execute(PipelineExecutionContext context)  ilOffset = 0xDD
	at MessageProcessor.Execute(PipelineExecutionContext context)  ilOffset = 0x1E6
	at InternalMessageDispatcher.Execute(PipelineExecutionContext context)  ilOffset = 0xE4
	at ExternalMessageDispatcher.ExecuteInternal(IInProcessOrganizationServiceFactory serviceFactory, IPlatformMessageDispatcherFactory dispatcherFactory, String messageName, String requestName, Int32 primaryObjectTypeCode, Int32 secondaryObjectTypeCode, ParameterCollection fields, CorrelationToken correlationToken, CallerOriginToken originToken, UserAuth userAuth, Guid callerId, Guid callerRegardingObjectId, UserType userType, Guid transactionContextId, Int32 invocationSource, Nullable`1 requestId, Version endpointVersion)  ilOffset = 0x1F2
	at ExternalMessageDispatcher.Execute(IInProcessOrganizationServiceFactory serviceFactory, IPlatformMessageDispatcherFactory dispatcherFactory, String messageName, String requestName, Int32 primaryObjectTypeCode, Int32 secondaryObjectTypeCode, ParameterCollection fields, CorrelationToken correlationToken, CallerOriginToken originToken, UserAuth userAuth, Guid callerId, Guid callerRegardingObjectId, UserType userType, Guid transactionContextId, Int32 invocationSource, Nullable`1 requestId)  ilOffset = 0x0
	at OrganizationSdkServiceInternal.ExecuteRequestRequestWithInstrumentation(OrganizationRequest request, CorrelationToken correlationToken, CallerOriginToken callerOriginToken, WebServiceType serviceType, UserAuth userAuth, Guid targetUserId, OrganizationContext context, Boolean returnResponse, Boolean checkAdminMode, Object operation, UserType targetUserType)  ilOffset = 0x0
	at OrganizationSdkServiceInternal.ExecuteRequest(OrganizationRequest request, CorrelationToken correlationToken, CallerOriginToken callerOriginToken, WebServiceType serviceType, Boolean checkAdminMode, ExecutionContext executionContext)  ilOffset = 0x4B
	at OrganizationSdkServiceInternal.Execute(OrganizationRequest request, CorrelationToken correlationToken, CallerOriginToken callerOriginToken, WebServiceType serviceType, Boolean checkAdminMode, ExecutionContext executionContext)  ilOffset = 0x0
	at InprocessServiceProxy.ExecuteCore(OrganizationRequest request)  ilOffset = 0x34
	at PlatformCommand.XrmExecuteInternal()  ilOffset = 0xBC
	at RetrieveMultipleCommand.Execute()  ilOffset = 0x0
	at RetrieveMultipleCommand.RetrieveData()  ilOffset = 0x0
	at ApplicationQuery.ExecuteQuery()  ilOffset = 0x0
	at GridDataProviderQueryBuilder.GetData(QueryBuilder queryBuilder)  ilOffset = 0x14
	at GridDataProviderQueryBuilder.LoadQueryData()  ilOffset = 0x132
	at GridDataProviderQueryBuilder.LoadData()  ilOffset = 0x0
	at LookupService.ResolveLookupItem(Int32[] typesArray, String bindingColumns, String additionalParameters, String value, Int32 position, Boolean resolveEmailAddress, String savedQueryTypeParameter, View defaultView, String[] values, Boolean sortResults)  ilOffset = 0x12E
	at LookupService.RetrieveItem(Int32[] typesArray, String bindingColumns, String additionalParameters, String[] values, Int32[] positions, Boolean resolveEmailAddress, String savedQueryTypeParameter, String defaultViewId, Nullable`1 defaultViewType, String defaultViewFetchXml, String defaultViewLayoutXml, String[] guidValues, Boolean sortResults)  ilOffset = 0x175
	at LookupService.RetrieveInlineSearchResults(Int32[] typesArray, String bindingColumns, String additionalParameters, String[] lookupValues, Int32[] positions, Boolean resolveEmailAddress, String savedQueryTypeParameter, String defaultViewId, Nullable`1 defaultViewType, String defaultViewFetchXml, String defaultViewLayoutXml, String[] guidValues, Boolean sortResults)  ilOffset = 0x12
	at RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)  ilOffset = 0xFFFFFFFF
	at RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)  ilOffset = 0x16
	at RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)  ilOffset = 0x7F
	at LogicalMethodInfo.Invoke(Object target, Object[] values)  ilOffset = 0x3F
	at WebServiceHandler.Invoke()  ilOffset = 0xAE
	at WebServiceHandler.CoreProcessRequest()  ilOffset = 0x134
	at SyncSessionlessHandler.ProcessRequest(HttpContext context)  ilOffset = 0x3F
	at CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()  ilOffset = 0x187
	at HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)  ilOffset = 0x15
	at PipelineStepManager.ResumeSteps(Exception error)  ilOffset = 0x27A
	at HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb)  ilOffset = 0x31
	at HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context)  ilOffset = 0xB0
	at PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)  ilOffset = 0x131
	at PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)  ilOffset = 0x0
	at UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus& notificationStatus)  ilOffset = 0xFFFFFFFF
	at UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus& notificationStatus)  ilOffset = 0xFFFFFFFF
	at PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)  ilOffset = 0x1E7
	at PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)  ilOffset = 0x0
>Crm Exception: Message: Generic SQL error., ErrorCode: -2147204784, InnerException: System.Data.SqlClient.SqlException (0x80131904): SQL Server encountered error 0x8007042d while communicating with full-text filter daemon host (FDHost) process. Make sure that the FDHost process is running. To re-start the FDHost process, run the sp_fulltext_service 'restart_all_fdhosts' command or restart the SQL Server instance.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at Microsoft.Crm.CrmDbConnection.InternalExecuteWithRetry[TResult](Func`1 ExecuteMethod, IDbCommand command)
   at Microsoft.Crm.CrmDbConnection.InternalExecuteReader(IDbCommand command, Boolean capturePerfTrace)
   at Microsoft.Crm.BusinessEntities.BusinessProcessObject.ExecuteQuery(CrmDbConnection dbConnection, IDbCommand command, ISqlExecutionContext context, Nullable`1 commandTimeout)
   at Microsoft.Crm.BusinessEntities.BusinessProcessObject.QueryAndFillEntityCollection(CrmDbConnection dbConnection, IDbCommand dbCommand, BusinessEntityCollection entities, EntityExpression entityExp, PagingHelper pagingHelper, Boolean useEntityExpression, String aggregateLimitExceededName, ExecutionContext context)
   at Microsoft.Crm.BusinessEntities.BusinessProcessObject.DoRetrieveMultiple(BusinessEntityCollection entities, EntityExpression entityExp, DatabaseQueryTarget queryTarget, PagingHelper pagingHelper, ExecutionContext context, Boolean needToSetRowVersion, Boolean isVersionNumberRequestedInRetrieve)
   at Microsoft.Crm.BusinessEntities.BusinessProcessObject.DoRetrieveMultiple(BusinessEntityCollection entities, EntityExpression entityExp, DatabaseQueryTarget queryTarget, ExecutionContext context, Boolean needToSetRowVersion, Boolean isVersionNumberRequestedInRetrieve)
   at Microsoft.Crm.BusinessEntities.BusinessProcessObject.RetrieveMultiple(EntityExpression entityExpression, DatabaseQueryTarget queryTarget, ExecutionContext context)
   at Microsoft.Crm.BusinessEntities.BusinessProcessObject.RetrieveMultiple(EntityExpression entityExpression, ExecutionContext context)
ClientConnectionId:644af856-e7d9-4c6b-8d5b-bddd232c7f42
Error Number:30046,State:1,Class:16
[2016-10-03 10:58:43.159] Process: w3wp |Organization:6226d5a1-6a38-48ee-9208-97b2c8c99799 |Thread: 1800 |Category: Exception |User: e8b81f7b-870b-441a-b525-9e5b9d2b414a |Level: Error |ReqId: aebfc655-80f9-4761-85ca-e617c9b2824a | CrmException..ctor  ilOffset = 0xA
	at CrmException..ctor(String message, Exception innerException, Int32 errorCode)  ilOffset = 0xA
	at RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)  ilOffset = 0xFFFFFFFF
	at RuntimeConstructorInfo.Invoke(BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)  ilOffset = 0xEE
	at RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes, StackCrawlMark& stackMark)  ilOffset = 0x1C8
	at Activator.CreateInstance(Type type, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes)  ilOffset = 0xAB
	at Activator.CreateInstance(Type type, Object[] args)  ilOffset = 0x0
	at VersionedPluginProxyStepBase.WrapExceptionToThrow(CrmException exception)  ilOffset = 0x63
	at VersionedPluginProxyStepBase.Execute(PipelineExecutionContext context)  ilOffset = 0x65
	at Pipeline.Execute(PipelineExecutionContext context)  ilOffset = 0xDD
	at MessageProcessor.Execute(PipelineExecutionContext context)  ilOffset = 0x1E6
	at InternalMessageDispatcher.Execute(PipelineExecutionContext context)  ilOffset = 0xE4
	at ExternalMessageDispatcher.ExecuteInternal(IInProcessOrganizationServiceFactory serviceFactory, IPlatformMessageDispatcherFactory dispatcherFactory, String messageName, String requestName, Int32 primaryObjectTypeCode, Int32 secondaryObjectTypeCode, ParameterCollection fields, CorrelationToken correlationToken, CallerOriginToken originToken, UserAuth userAuth, Guid callerId, Guid callerRegardingObjectId, UserType userType, Guid transactionContextId, Int32 invocationSource, Nullable`1 requestId, Version endpointVersion)  ilOffset = 0x1F2
	at ExternalMessageDispatcher.Execute(IInProcessOrganizationServiceFactory serviceFactory, IPlatformMessageDispatcherFactory dispatcherFactory, String messageName, String requestName, Int32 primaryObjectTypeCode, Int32 secondaryObjectTypeCode, ParameterCollection fields, CorrelationToken correlationToken, CallerOriginToken originToken, UserAuth userAuth, Guid callerId, Guid callerRegardingObjectId, UserType userType, Guid transactionContextId, Int32 invocationSource, Nullable`1 requestId)  ilOffset = 0x0
	at OrganizationSdkServiceInternal.ExecuteRequestRequestWithInstrumentation(OrganizationRequest request, CorrelationToken correlationToken, CallerOriginToken callerOriginToken, WebServiceType serviceType, UserAuth userAuth, Guid targetUserId, OrganizationContext context, Boolean returnResponse, Boolean checkAdminMode, Object operation, UserType targetUserType)  ilOffset = 0x0
	at OrganizationSdkServiceInternal.ExecuteRequest(OrganizationRequest request, CorrelationToken correlationToken, CallerOriginToken callerOriginToken, WebServiceType serviceType, Boolean checkAdminMode, ExecutionContext executionContext)  ilOffset = 0x4B
	at OrganizationSdkServiceInternal.Execute(OrganizationRequest request, CorrelationToken correlationToken, CallerOriginToken callerOriginToken, WebServiceType serviceType, Boolean checkAdminMode, ExecutionContext executionContext)  ilOffset = 0x0
	at InprocessServiceProxy.ExecuteCore(OrganizationRequest request)  ilOffset = 0x34
	at PlatformCommand.XrmExecuteInternal()  ilOffset = 0xBC
	at RetrieveMultipleCommand.Execute()  ilOffset = 0x0
	at RetrieveMultipleCommand.RetrieveData()  ilOffset = 0x0
	at ApplicationQuery.ExecuteQuery()  ilOffset = 0x0
	at GridDataProviderQueryBuilder.GetData(QueryBuilder queryBuilder)  ilOffset = 0x14
	at GridDataProviderQueryBuilder.LoadQueryData()  ilOffset = 0x132
	at GridDataProviderQueryBuilder.LoadData()  ilOffset = 0x0
	at LookupService.ResolveLookupItem(Int32[] typesArray, String bindingColumns, String additionalParameters, String value, Int32 position, Boolean resolveEmailAddress, String savedQueryTypeParameter, View defaultView, String[] values, Boolean sortResults)  ilOffset = 0x12E
	at LookupService.RetrieveItem(Int32[] typesArray, String bindingColumns, String additionalParameters, String[] values, Int32[] positions, Boolean resolveEmailAddress, String savedQueryTypeParameter, String defaultViewId, Nullable`1 defaultViewType, String defaultViewFetchXml, String defaultViewLayoutXml, String[] guidValues, Boolean sortResults)  ilOffset = 0x175
	at LookupService.RetrieveInlineSearchResults(Int32[] typesArray, String bindingColumns, String additionalParameters, String[] lookupValues, Int32[] positions, Boolean resolveEmailAddress, String savedQueryTypeParameter, String defaultViewId, Nullable`1 defaultViewType, String defaultViewFetchXml, String defaultViewLayoutXml, String[] guidValues, Boolean sortResults)  ilOffset = 0x12
	at RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)  ilOffset = 0xFFFFFFFF
	at RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)  ilOffset = 0x16
	at RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)  ilOffset = 0x7F
	at LogicalMethodInfo.Invoke(Object target, Object[] values)  ilOffset = 0x3F
	at WebServiceHandler.Invoke()  ilOffset = 0xAE
	at WebServiceHandler.CoreProcessRequest()  ilOffset = 0x134
	at SyncSessionlessHandler.ProcessRequest(HttpContext context)  ilOffset = 0x3F
	at CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()  ilOffset = 0x187
	at HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)  ilOffset = 0x15
	at PipelineStepManager.ResumeSteps(Exception error)  ilOffset = 0x27A
	at HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb)  ilOffset = 0x31
	at HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context)  ilOffset = 0xB0
	at PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)  ilOffset = 0x131
	at PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)  ilOffset = 0x0
	at UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus& notificationStatus)  ilOffset = 0xFFFFFFFF
	at UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus& notificationStatus)  ilOffset = 0xFFFFFFFF
	at PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)  ilOffset = 0x1E7
	at PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)  ilOffset = 0x0
>Crm Exception: Message: Generic SQL error., ErrorCode: -2147204784, InnerException: Microsoft.Crm.CrmException: Generic SQL error. ---> System.Data.SqlClient.SqlException: SQL Server encountered error 0x8007042d while communicating with full-text filter daemon host (FDHost) process. Make sure that the FDHost process is running. To re-start the FDHost process, run the sp_fulltext_service 'restart_all_fdhosts' command or restart the SQL Server instance.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at Microsoft.Crm.CrmDbConnection.InternalExecuteWithRetry[TResult](Func`1 ExecuteMethod, IDbCommand command)
   at Microsoft.Crm.CrmDbConnection.InternalExecuteReader(IDbCommand command, Boolean capturePerfTrace)
   at Microsoft.Crm.BusinessEntities.BusinessProcessObject.ExecuteQuery(CrmDbConnection dbConnection, IDbCommand command, ISqlExecutionContext context, Nullable`1 commandTimeout)
   at Microsoft.Crm.BusinessEntities.BusinessProcessObject.QueryAndFillEntityCollection(CrmDbConnection dbConnection, IDbCommand dbCommand, BusinessEntityCollection entities, EntityExpression entityExp, PagingHelper pagingHelper, Boolean useEntityExpression, String aggregateLimitExceededName, ExecutionContext context)
   at Microsoft.Crm.BusinessEntities.BusinessProcessObject.DoRetrieveMultiple(BusinessEntityCollection entities, EntityExpression entityExp, DatabaseQueryTarget queryTarget, PagingHelper pagingHelper, ExecutionContext context, Boolean needToSetRowVersion, Boolean isVersionNumberRequestedInRetrieve)
   at Microsoft.Crm.BusinessEntities.BusinessProcessObject.DoRetrieveMultiple(BusinessEntityCollection entities, EntityExpression entityExp, DatabaseQueryTarget queryTarget, ExecutionContext context, Boolean needToSetRowVersion, Boolean isVersionNumberRequestedInRetrieve)
   at Microsoft.Crm.BusinessEntities.BusinessProcessObject.RetrieveMultiple(EntityExpression entityExpression, DatabaseQueryTarget queryTarget, ExecutionContext context)
   at Microsoft.Crm.BusinessEntities.BusinessProcessObject.RetrieveMultiple(EntityExpression entityExpression, ExecutionContext context)
   --- End of inner exception stack trace ---
[2016-10-03 10:58:43.159] Process: w3wp |Organization:6226d5a1-6a38-48ee-9208-97b2c8c99799 |Thread: 1800 |Category: Platform |User: e8b81f7b-870b-441a-b525-9e5b9d2b414a |Level: Error |ReqId: aebfc655-80f9-4761-85ca-e617c9b2824a | MessageProcessor.Execute  ilOffset = 0x1E6
>MessageProcessor fail to process message 'RetrieveMultiple' for 'productpricelevel'.
[2016-10-03 10:58:43.159] Process: w3wp |Organization:00000000-0000-0000-0000-000000000000 |Thread: 1800 |Category: Platform |User: 00000000-0000-0000-0000-000000000000 |Level: Error |ReqId: aebfc655-80f9-4761-85ca-e617c9b2824a | ExceptionConverter.ConvertMessageAndErrorCode  ilOffset = 0x208
>System.Data.SqlClient.SqlException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #8D50EA41: System.Data.SqlClient.SqlException (0x80131904): SQL Server encountered error 0x8007042d while communicating with full-text filter daemon host (FDHost) process. Make sure that the FDHost process is running. To re-start the FDHost process, run the sp_fulltext_service 'restart_all_fdhosts' command or restart the SQL Server instance.
>   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
>   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
>   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
>   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
>   at System.Data.SqlClient.SqlDataReader.get_MetaData()
>   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
>   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
>   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
>   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
>   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
>   at Microsoft.Crm.CrmDbConnection.InternalExecuteWithRetry[TResult](Func`1 ExecuteMethod, IDbCommand command)
>   at Microsoft.Crm.CrmDbConnection.InternalExecuteReader(IDbCommand command, Boolean capturePerfTrace)
>   at Microsoft.Crm.BusinessEntities.BusinessProcessObject.ExecuteQuery(CrmDbConnection dbConnection, IDbCommand command, ISqlExecutionContext context, Nullable`1 commandTimeout)
>   at Microsoft.Crm.BusinessEntities.BusinessProcessObject.QueryAndFillEntityCollection(CrmDbConnection dbConnection, IDbCommand dbCommand, BusinessEntityCollection entities, EntityExpression entityExp, PagingHelper pagingHelper, Boolean useEntityExpression, String aggregateLimitExceededName, ExecutionContext context)
>   at Microsoft.Crm.BusinessEntities.BusinessProcessObject.DoRetrieveMultiple(BusinessEntityCollection entities, EntityExpression entityExp, DatabaseQueryTarget queryTarget, PagingHelper pagingHelper, ExecutionContext context, Boolean needToSetRowVersion, Boolean isVersionNumberRequestedInRetrieve)
>   at Microsoft.Crm.BusinessEntities.BusinessProcessObject.DoRetrieveMultiple(BusinessEntityCollection entities, EntityExpression entityExp, DatabaseQueryTarget queryTarget, ExecutionContext context, Boolean needToSetRowVersion, Boolean isVersionNumberRequestedInRetrieve)
>   at Microsoft.Crm.BusinessEntities.BusinessProcessObject.RetrieveMultiple(EntityExpression entityExpression, DatabaseQueryTarget queryTarget, ExecutionContext context)
>   at Microsoft.Crm.BusinessEntities.BusinessProcessObject.RetrieveMultiple(EntityExpression entityExpression, ExecutionContext context)
>ClientConnectionId:644af856-e7d9-4c6b-8d5b-bddd232c7f42
>Error Number:30046,State:1,Class:16
[2016-10-03 10:58:43.159] Process: w3wp |Organization:00000000-0000-0000-0000-000000000000 |Thread: 1800 |Category: Exception |User: 00000000-0000-0000-0000-000000000000 |Level: Error |ReqId: aebfc655-80f9-4761-85ca-e617c9b2824a | ExceptionUtility.CreateCrmExceptionFromServiceFault  ilOffset = 0x1B
	at ExceptionUtility.CreateCrmExceptionFromServiceFault(FaultException`1 fe)  ilOffset = 0x1B
	at PlatformCommand.XrmExecuteInternal()  ilOffset = 0xBC
	at RetrieveMultipleCommand.Execute()  ilOffset = 0x0
	at RetrieveMultipleCommand.RetrieveData()  ilOffset = 0x0
	at ApplicationQuery.ExecuteQuery()  ilOffset = 0x0
	at GridDataProviderQueryBuilder.GetData(QueryBuilder queryBuilder)  ilOffset = 0x14
	at GridDataProviderQueryBuilder.LoadQueryData()  ilOffset = 0x132
	at GridDataProviderQueryBuilder.LoadData()  ilOffset = 0x0
	at LookupService.ResolveLookupItem(Int32[] typesArray, String bindingColumns, String additionalParameters, String value, Int32 position, Boolean resolveEmailAddress, String savedQueryTypeParameter, View defaultView, String[] values, Boolean sortResults)  ilOffset = 0x12E
	at LookupService.RetrieveItem(Int32[] typesArray, String bindingColumns, String additionalParameters, String[] values, Int32[] positions, Boolean resolveEmailAddress, String savedQueryTypeParameter, String defaultViewId, Nullable`1 defaultViewType, String defaultViewFetchXml, String defaultViewLayoutXml, String[] guidValues, Boolean sortResults)  ilOffset = 0x175
	at LookupService.RetrieveInlineSearchResults(Int32[] typesArray, String bindingColumns, String additionalParameters, String[] lookupValues, Int32[] positions, Boolean resolveEmailAddress, String savedQueryTypeParameter, String defaultViewId, Nullable`1 defaultViewType, String defaultViewFetchXml, String defaultViewLayoutXml, String[] guidValues, Boolean sortResults)  ilOffset = 0x12
	at RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)  ilOffset = 0xFFFFFFFF
	at RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)  ilOffset = 0x16
	at RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)  ilOffset = 0x7F
	at LogicalMethodInfo.Invoke(Object target, Object[] values)  ilOffset = 0x3F
	at WebServiceHandler.Invoke()  ilOffset = 0xAE
	at WebServiceHandler.CoreProcessRequest()  ilOffset = 0x134
	at SyncSessionlessHandler.ProcessRequest(HttpContext context)  ilOffset = 0x3F
	at CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()  ilOffset = 0x187
	at HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)  ilOffset = 0x15
	at PipelineStepManager.ResumeSteps(Exception error)  ilOffset = 0x27A
	at HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb)  ilOffset = 0x31
	at HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context)  ilOffset = 0xB0
	at PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)  ilOffset = 0x131
	at PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)  ilOffset = 0x0
	at UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus& notificationStatus)  ilOffset = 0xFFFFFFFF
	at UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus& notificationStatus)  ilOffset = 0xFFFFFFFF
	at PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)  ilOffset = 0x1E7
	at PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)  ilOffset = 0x0
>Crm Exception: Message: Generic SQL error., ErrorCode: -2147204784
[2016-10-03 10:58:43.159] Process: w3wp |Organization:00000000-0000-0000-0000-000000000000 |Thread: 1800 |Category: Application |User: 00000000-0000-0000-0000-000000000000 |Level: Error |ReqId: aebfc655-80f9-4761-85ca-e617c9b2824a | LookupService.ResolveLookupItem  ilOffset = 0x12E
>Entity Id:3c63dc0a-1fef-4d07-a399-5045f4dbb114 Error Code: -2147204784 - Error Message: Generic SQL error.
[2016-10-03 10:58:43.159] Process: w3wp |Organization:6226d5a1-6a38-48ee-9208-97b2c8c99799 |Thread: 1800 |Category: Application |User: 00000000-0000-0000-0000-000000000000 |Level: Error |ReqId: aebfc655-80f9-4761-85ca-e617c9b2824a | ErrorInformation.LogError  ilOffset = 0x21
>MSCRM Error Report:
--------------------------------------------------------------------------------------------------------
Error: Generic SQL error.

Error Number: 0x80044150

Error Message: Generic SQL error.

Error Details: Generic SQL error.

Source File: Not available

Line Number: Not available

Request URL: https://crm.intertecsys.net/IntertecSystems/AppWebServices/LookupService.asmx

Stack Trace Info: [CrmException: Generic SQL error.]
   at Microsoft.Crm.Application.Platform.ServiceCommands.PlatformCommand.XrmExecuteInternal()
   at Microsoft.Crm.Application.Platform.ServiceCommands.RetrieveMultipleCommand.Execute()
   at Microsoft.Crm.ApplicationQuery.RetrieveMultipleCommand.RetrieveData()
   at Microsoft.Crm.ApplicationQuery.ExecuteQuery()
   at Microsoft.Crm.Application.Platform.Grid.GridDataProviderQueryBuilder.GetData(QueryBuilder queryBuilder)
   at Microsoft.Crm.Application.Platform.Grid.GridDataProviderQueryBuilder.LoadQueryData()
   at Microsoft.Crm.Application.Platform.Grid.GridDataProviderQueryBuilder.LoadData()
   at Microsoft.Crm.Core.Application.WebServices.LookupService.ResolveLookupItem(Int32[] typesArray, String bindingColumns, String additionalParameters, String value, Int32 position, Boolean resolveEmailAddress, String savedQueryTypeParameter, View defaultView, String[] values, Boolean sortResults)
   at Microsoft.Crm.Core.Application.WebServices.LookupService.RetrieveItem(Int32[] typesArray, String bindingColumns, String additionalParameters, String[] values, Int32[] positions, Boolean resolveEmailAddress, String savedQueryTypeParameter, String defaultViewId, Nullable`1 defaultViewType, String defaultViewFetchXml, String defaultViewLayoutXml, String[] guidValues, Boolean sortResults)

  • Verified answer
    a33ik Profile Picture
    a33ik 84,325 Most Valuable Professional on at
    RE: Product Lookup throws generic SQL Error

    Hello,

    Unfortunately "SQL Generic error" doesn't give any explanation what's going wrong with your CRM. To get detailed explanation turn on trace - support.microsoft.com/.../907490, restart IIS, reproduce an error and open Trace folder to get trace file from it. It will have detailed explanation what's wrong with your instance. If it would not be clear for you what's wrong feel free to update this thread with new details.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,375 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans