web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / "Released product...
Microsoft Dynamics AX (Archived)

"Released products" Form freezes when fitering by "Product name" for fuzzy search

(0) ShareShare
ReportReport
Posted on by Yuka Furumoto 20

Hi all,

When I do the following steps, the high-load SQL is executed and it pressures Database server.
It results that the form freezes and cannot operate.

1. Filter by fuzzy search for "Product name" in "Released Products" Form. (like *aaa*)
2. Open Released Products detali Form. (double-clicking for one record in the grid in "Released Products" Form.

Does anyone have any solution for it?

Best regards,
Yuka

*This post is locked for comments

I have the same question (0)
  • Vgubba Profile Picture
    Vgubba 120 on at

    I have the same problem, Did you get any solution?

  • Yuka Furumoto Profile Picture
    Yuka Furumoto 20 on at

    Dear Vkunchakuri

    I received the possible solution from Microsoft and they recommend to recreate Index and to change the options in SQL server...

    I tried them to multiple environments but some environments have still the same problem.

  • Vgubba Profile Picture
    Vgubba 120 on at

    Hi Yuka Furumoto,

    Thanks for the reply. Its sad to know that the issue still exists. I will also give a try to recreate indexes. What are the other options to be changed in SQL server?

  • Yuka Furumoto Profile Picture
    Yuka Furumoto 20 on at

    Hi Vkunchakuri

    Please refer the following information.

    > > > > Resolution

    > > > > 1) Open the SQL Server Configuration Manager of the TEST

    > > > > Environment

    > > > > 2) Go to SQL Server Services / SQL Server (MSSQLSERVER) and open

    > > > > the properties

    > > > > 3) Go to the Startup Parameters and add the following trace flags

    > > > > (red are the most important flags)

    > > > >

    > > > > -t1117

    > > > > -t1118

    > > > > -t2371

    > > > > -t1224

    > > > > -t4199

    > > > > -t9481

    > > > >

    > > > > 4) Restart the SQL Server

    Best regards,

    Yuka

  • Vgubba Profile Picture
    Vgubba 120 on at

    I will try the suggestions. Thanks a lot Yuka.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 39

#2
Michel ROY Profile Picture

Michel ROY 14

#3
imran ul haq Profile Picture

imran ul haq 8

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans