Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

Item details form freezes while opening an item with filter.

Posted on by 110

I experience a very strange problem, that on the released products screen, When I use a filter on column(cntrl+G) and filter the items and open one of the item, the Item details page is opened. but when I use the filter "product name" (shift+f3) and filter the items and the try to double click to open the item, the system freezes and I have to eventually kill the session.

Is there any solution for this or ideas ? 

*This post is locked for comments

  • MW-23091441-0 Profile Picture
    MW-23091441-0 2 on at
    Item details form freezes while opening an item with filter.
    Many thanks, saved me as well. Problem suddenly occurred on an application which is in production for some 8? years.
  • Ghetz Profile Picture
    Ghetz 2,983 on at
    RE: Item details form freezes while opening an item with filter.

    Commenting the if statement seems solve the issue. We also were having a terrible freeze; our catalog is quite large.

    I've found 2 related issues at Microsoft LCS

    pastedimage1596461585129v1.png

    pastedimage1596461418956v1.png

    So I guess the "official" solution is to create an index in EcoResProductTranslation for field "Name"

    pastedimage1596462507150v1.png

    And adding it for the index property of the form's datasource 

    pastedimage1596462600019v2.png

    This also solved the freezing problem in our test environment.

  • Vaishnavi Profile Picture
    Vaishnavi 45 on at
    RE: Item details form freezes while opening an item with filter.

    Thank you very much Yves!

  • Yves Y Profile Picture
    Yves Y 55 on at
    RE: Item details form freezes while opening an item with filter.

    Hi Vkunchakuri,

     

    I was having the same issue in AX 2012 R3 CU13 for a customer having 60K+ products  and millions of records in EcoResProduct.

     

    After investigating in a Contoso environment, it appear the kernel is adding some strange stuff in WHERE clause.  Imagine a scenario where you are filtering the ListPage with letter D and then choose to edit product D0111.  SQL will look like this :

     

    WHERE (((T1.PARTITION=5637144576) AND (T1.DATAAREAID=N'usmf'))

    AND ((T1.ITEMID LIKE N'%D%' ESCAPE '\' )

    AND (((((((((T1.ITEMID=N'D0111') AND (T7.DISPLAYPRODUCTNUMBER=N'D0111')) AND (T7.RECID=22565440158)) AND (T18.PRODUCT=22565440158)) AND (T18.LANGUAGEID>=N'en-us'))

    OR ((((T1.ITEMID=N'D0111') AND (T7.DISPLAYPRODUCTNUMBER=N'D0111')) AND (T7.RECID=22565440158)) AND (T18.PRODUCT>22565440158)))

    OR (((T1.ITEMID=N'D0111') AND (T7.DISPLAYPRODUCTNUMBER=N'D0111')) AND (T7.RECID>22565440158)))

    OR ((T1.ITEMID=N'D0111') AND (T7.DISPLAYPRODUCTNUMBER>N'D0111'))) OR (T1.ITEMID>N'D0111'))))

    AND ((T7.PARTITION=5637144576) AND (T1.PRODUCT=T7.RECID))

    AND (((T8.PARTITION=5637144576) AND (T8.DATAAREAID=N'usmf')) AND ((T8.MODULETYPE=1) AND (T8.ITEMID=T1.ITEMID)))

    AND (((T9.PARTITION=5637144576) AND (T9.DATAAREAID=N'usmf')) AND ((T9.MODULETYPE=0) AND (T9.ITEMID=T1.ITEMID)))

    AND (((T10.PARTITION=5637144576) AND (T10.DATAAREAID=N'usmf')) AND ((T10.MODULETYPE=2) AND (T10.ITEMID=T1.ITEMID)))

    AND (((T11.PARTITION=5637144576) AND (T11.DATAAREAID=N'usmf')) AND ((T11.INVENTDIMID=N'AllBlank') AND (T1.ITEMID=T11.ITEMID)))

     

    I tried to call clearDynalinks and clearLinks over EcoResProduct data source without any effect.  I then tried to set property JoinMode = Delayed.  Still no luck.  I even tried to remove all EcoRes* tables from data source section (and also removed all my usage date).  No matter what I try, I still see [CROSS JOIN ECORESPRODUCT T7] in the SQL statement.  This is very strange.  I’m suspecting the kernel to have some sort of internal hardcoding for the query used by EcoResProductDetailsExtended when standard box to filter is being used (instead of filtering using CTRL-G).

     

    Here is a work-around :

    Edit method AOT\Forms\EcoResProductDetailsExtended\Data Sources\InventTable\Methods\init

    At the end of the method, there is a block of code used to add a range using refInventTable.ItemId.  Comment out the IF statement above the block to make sure the range will always be added.

     

    Hope this helps.

  • Vgubba Profile Picture
    Vgubba 110 on at
    RE: Item details form freezes while opening an item with filter.

    Thanks Sohaib,

    I will try using trace parser and hopefully get some information. I was unable to find anything strange while debugging in AX.

    I am just not able to understand that, when same record is being opened without using filter, the product details open up. Same record when opened from a filtered list of record makes client non responsive. Also, from the filtered list, when I do a view details on Item number, the same functions and form is called and this time productdetailsextended opens up. so even the view details on filtered list works but the normal open/double click to open doesn't work.

  • Sohaib Cheema Profile Picture
    Sohaib Cheema 46,610 User Group Leader on at
    RE: Item details form freezes while opening an item with filter.

    @Vkunchakuri

    The Trace Parser shows the amount of time each query takes as well as many other facts. Using it may help you to put some facts on front. It could be something wrong with data something wrong with expensive query something with memory or anything else. It's very hard to say a Single Reason for the issue for any of us. I would definitely recommend you to open Trace parser and see what is happening.

  • Vgubba Profile Picture
    Vgubba 110 on at
    RE: Item details form freezes while opening an item with filter.

    Thanks Sohaib, I am trying to debug this but to add a little more description. on the list when I double click or open , the Item details page opens up in few seconds. the same item doesnot respond/ open up when trying to open from filtered results(exp when it is filtered on product name).

    So I tried to debug to see what happens when I open the item from a list of unfiltered items and from a filtered list. I could not find a difference but in the EcoResProductDetailsExtended form, run methods, while debugging from filtered results, AX freezes up.

    I am trying to understand what is the difference when opened from filtered results to when opening the item details form from a released products list without using filter.

    Is there any suggestions that you can point me?

  • Sohaib Cheema Profile Picture
    Sohaib Cheema 46,610 User Group Leader on at
    RE: Item details form freezes while opening an item with filter.

    This could be ANYTHING. I remember been through such an issue on Released Products list-page where it was taking more than 12 minutes to open details page as we were clicking Edit for product (Released Item). The interesting thing was that issue was not happening for all products/items, it was for few items only. We found it the case of expensive query that was taking long time to complete, changing join types helped us.

    Using Trace parser and some debugging should help you.

  • Vgubba Profile Picture
    Vgubba 110 on at
    RE: Item details form freezes while opening an item with filter.

    We have around 25000 items and indeed on item name, it is quicker than the filter on product name. Issue is not with filter, the filter results display within 5 seconds or so, but when I try to open the Item details from the filtered results, it never opens up. it is very slow and non responsive. yes we have a customized field which shows manufacturer's name for the item. Is there anything that can be done here?

    I also tried to search other posts with same issue https://community.dynamics.com/ax/f/33/t/269566

    but there is no suggestions on that either!

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 290,902 Super User 2024 Season 2 on at
    RE: Item details form freezes while opening an item with filter.

    When you use the CRTL+G option, do you then also filter on the product name? Or another field? The product name is not on the released product details table (InventTable) itself. If you filtered on another fields which is actually in the same table, it can be indeed quicker.

    How many released products do you have in your environment? Do you have some additional customizations on the products or released products?

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,902 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,316 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans