Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Add find column for cu...
Microsoft Dynamics CRM (Archived)

Add find column for custom entity throws SQL error message

(0) ShareShare
ReportReport
Posted on by Patrick Friedrich 395

Dear all,

I recently found an issue / bug in CRM 8.2.1 when I do the following:

Add four fields of a custom entity to use them in the global search.

--> I´m using the quick find view

--> Add those columns via the "add find columns" section on the Quick Find View

--> save, publish, refresh etc.

When using any field in the global search I don´t see this custom entity anymore.

When using the standard view for this entity and browse for any data I receive an SQL error message which says nothing.

When I remove those for columns again, everything works fine. Thise are single line of text fields which only contain numbers.

Any ideas?

Cheers

Patrick

*This post is locked for comments

  • Verified answer
    Patrick Friedrich Profile Picture
    Patrick Friedrich 395 on at
    RE: Add find column for custom entity throws SQL error message

    The issue disappeared after we disabled the full text search and reenabled it again after > 24hours.

    So right now we dont face any new issue. MS Support said it could be due to cross entity search on custom entities!?

    Cheers

    Patrick

  • Suggested answer
    RaviKashyap Profile Picture
    RaviKashyap 55,410 on at
    RE: Add find column for custom entity throws SQL error message

    Hi,

    I would suggest to check if his is happening on V9. If it is not happening in V9 then I don't think MS will fix this on v8.2 as we are now need to upgrade to V9 by Jan.

    Hope this helps.

  • Arun Vinoth Profile Picture
    Arun Vinoth 11,613 on at
    RE: Add find column for custom entity throws SQL error message

    Fishy, Have you ever dropped those fields & recreated with the same name?

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans