Dynamics Community Forum Thread Details

0x80044150 SQL Server Error quck find in view

Hello everyone. An error occurs when using a quick search in the entity view. The error appears in the new and old application What could this be related to?

Client version: 1.4.3672-v91onpremise

photo_5F00_2022_2D00_02_2D00_25_5F00_09_2D00_18_2D00_50.jpg Quotes-My-Quotes-_2D00_-Microsoft-Dynamics-365-_2D00_-Google.png

I was looking for answers on the forum. I managed to find this setting

Enable Quick Find record limits is 'YES',

but it is already enabled, and the error still appears regularly

85a1e4c8_2D00_e1c6_2D00_44e4_2D00_8a36_2D00_f57dd827706d.png

Hi,

Ideally, the query which is used to pull the records for the view to load is timing out.

Collect the platform traces and get the query that is failing tune it using SSMS. or increase the OLEDBTimeout . or that doesn't work use the below SQL query to update the timeout in DB

use MSCRM_Config

Update OrganizationProperties set IntColumn = '120'
where ColumnName = 'SQLCommandTimeout'

And, there is also a new Query Hint feature available in the online instance which I believe should be available in CRM 9. x On-premise as well-

An example of this using the Query Hint feature on the All Accounts view is below: