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
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
So I guess the "official" solution is to create an index in EcoResProductTranslation for field "Name"
And adding it for the index property of the form's datasource
This also solved the freezing problem in our test environment.
Thank you very much Yves!
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.
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.
@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.
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?
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.
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!
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?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,902 Super User 2024 Season 2
Martin Dráb 229,316 Most Valuable Professional
nmaenpaa 101,156