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) / CRM 2016 Quick Find Vi...
Microsoft Dynamics CRM (Archived)

CRM 2016 Quick Find View not finding active records

(0) ShareShare
ReportReport
Posted on by Seemorgh 145

We are having a bizarre issue with our 2016 on-premise CRM Quick Find View. Basically, we are not able to use Quick Find View to search for some active records (incidents to be exact).

When we go to the incident's All Active Incidents view and use the search bar (which uses Quick Find View), we are able to search for some active records, yet are unable to search for some others.

We have configured the incident's Quick Find View to search in columns such as ticket number and title. I have compared two such records (one returning and one non-returning) together side-by-side in the SQL Management Studio, and all seems OK.

At first I thought the columns we are searching in might have invalid characters in them for the non-returning record. But that is not the case.

Also, the column names are selected in the Add Find Columns configuration of the Quick Find View. So that's not the cause either.

Any help is greatly appreciated.

*This post is locked for comments

  • Suggested answer
    Charles Abi Khirs Profile Picture
    Charles Abi Khirs 3,569 on at
    RE: CRM 2016 Quick Find View not finding active records

    Hello,

    Maybe it is a security role permissions, maybe the other record should not be retrieved because it is owned by other business unit? check the security role read permission of the user you are using and make sure you have the right permission, and check the owner of the record to see if it is comply with the security privileges set.

  • Seemorgh Profile Picture
    Seemorgh 145 on at
    RE: CRM 2016 Quick Find View not finding active records

    Hi David. Thanks for your response. I did check the SQL server and all other servers, (back-end, front-end, etc) and there was no service that seemed to have crashed or stopped. They were all running. Also, there was no error specific to the full text indexing service in the event log. Maybe as you said, it did not have a chance to write to the log.

  • David Jennaway Profile Picture
    David Jennaway 14,063 on at
    RE: CRM 2016 Quick Find View not finding active records

    Based on the timing, that sounds like the SQL Full Text Indexing service had a problem (hung or crashed) on that date. I would normally expect an error in the event log, or maybe the SQL log, though if it was a hang, it may not have written an error. If the service did crash/stop, you can set the recovery options on the windows server to have it restart automatically

  • Suggested answer
    Seemorgh Profile Picture
    Seemorgh 145 on at
    RE: CRM 2016 Quick Find View not finding active records

    Upon more investigation, we realised that any case and query record created on or after a certain date could not be searched for. Any other record created before that date could be searched for.

    We don't know what exactly happened to the CRM SQL database server on that date, however we decided to restart the SQL services on the server and it seems to have resolved the issue. All case and query records are now searchable.

    We are still trying to find what caused the issue. I will update this answer as soon as we find the cause so that it might help others.

    Thank you all for your suggestions.

  • Seemorgh Profile Picture
    Seemorgh 145 on at
    RE: CRM 2016 Quick Find View not finding active records

    Hi Goutam. Thanks for your answer. Full text search is enabled. There is no filter in Quick Find View. Only in the All Active Incidents view but that's not the cause as I am able to find the record with the same criteria in Advanced Find. Also, there is n security role or BU secured data, or plugin that might affect the result. I suspect it's to do with DB indexing and search catalog. I will update this page once I have found the cause.

  • Seemorgh Profile Picture
    Seemorgh 145 on at
    RE: CRM 2016 Quick Find View not finding active records

    Hi Kokulan. Thanks for your suggestions.  Full text search has always been enabled and find columns are configured correctly. I will check the maintenance job and the server logs.

  • Seemorgh Profile Picture
    Seemorgh 145 on at
    RE: CRM 2016 Quick Find View not finding active records

    Hi Jarrod. There is no extra filter on the view. I've got a feeling it has something to do with database indexing.

  • gdas Profile Picture
    gdas 50,089 on at
    RE: CRM 2016 Quick Find View not finding active records

    Hi Seemorgh,

    Check first full text search .

    [View:https://community.dynamics.com/crm/b/crmtipstrickstroubleshooting/archive/2018/01/07/full-text-search-in-ms-dynamics-365]

    Try to apply same quick view filter criteria in the advanced find and see the results. I am suspecting something you are missing in the filter criteria. So remove the filter criteria from quick view and see the result.

    In addition by any chance is there  any security privilege/BU secured data. You may check with different system admin user.

    Also check if you have any retrieve multiple plugin , which may add additional filter.

  • Kokulan Profile Picture
    Kokulan 18,052 on at
    RE: CRM 2016 Quick Find View not finding active records

    Hi

    Do you have full-text search enabled? if you have configured your find columns right and if you are using the right search terms and if it snot bringing back the results you are expecting,  i would also check if the Maintenance  job is running regularly or is it failing? If the indexing is not done by the maintenance service, you may experience this sort of issue sometime. So its worth checkign CRM server where the Async services are installed and check the event viewer, and possibly enable trace and check that as well.

  • Jarrod Williams Profile Picture
    Jarrod Williams 1,747 on at
    RE: CRM 2016 Quick Find View not finding active records

    You need to look within customizations to see if there is a filter on the quick find view itself that is applying an additional filter on it.  

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,494 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,305 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans