Some users is very slow on InventOnhandItem screen

(2) Share

Report

Posted on by Faruk Durak

109

We are using Ax 2012 R3, SQL Server 2016 SP2 is installed.
When users constantly using the InventOnhandItem screen add the InventLocationId field from the dimensions view, the screen runs too slow to be usable. When I try with different users at the same time, it works normally for some users.

Even though I reset all the usage data of the problematic user, I cannot fix the problem. AOS restart does not solve the problem either, I have to restart the complete SQL server. We encounter this problem every 3-4 days. Anyone have a suggestion for a solution?

I have the same question (0)

All responses (15)

Answers (2)

nmaenpaa 101,162 Moderator on at

Like (0)

Report

Do all the users query the on-hand with the same settings?

Or is it rather that some users open it with different settings, and the slowness happens with those settings, regardless of the user?

Was this reply helpful? Yes No
Faruk Durak 109 on at

Like (0)

Report

Nikolaos, There is no specific setting for the users I am experimenting with, I just add the InventLocationId field and it gets slow. Still no problem if I add dimensions view other than InventLocationId .

I reset all the user's data to make sure the settings are different.

Was this reply helpful? Yes No
Suggested answer

Umesh Pandit 9,315 User Group Leader on at

Like (0)

Report

check if this works for you: community.dynamics.com/.../101608

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Faruk,

Are you running the very latest R3 version?

I am asking because there are a number of issues & fixes listed on LCS.

This one seems to apply to what you describe:

fix.lcs.dynamics.com/.../Details

There are, however, more.

Please see:

fix.lcs.dynamics.com/.../Results

Best regards,

Ludwig

Was this reply helpful? Yes No
Verified answer

jannawangD365 on at

Like (1)

Report

Hi Faruk,

plz try to run some cleanup job in inventory module, onhandcleanup or warehouseonhancleanup if you have WMS enabled items.

Was this reply helpful? Yes No
Faruk Durak 109 on at

Like (0)

Report

Hi Ludwig,

Thank you for interest. Our Ax Version is R3 CU11. There is a lot of localization development in the General Ledger module. That's why we hesitate to install new CU versions. However, I want to install and try the Fix packages you sent in Test environment.

Was this reply helpful? Yes No
Faruk Durak 109 on at

Like (0)

Report

Hi jannawangD365,

Thank you for interest. That is good Idea. I will try it.

Was this reply helpful? Yes No
Verified answer

jannawangD365 on at

Like (0)

Report

Hi Faruk,

how is the performance now? Is it improved?

Was this reply helpful? Yes No
Faruk Durak 109 on at

Like (0)

Report

Hi jannawangD365,

we got a complaint again in 06 Mar 2021 then I ran first Inventory journal cleanup in the our LIVE Ax. The job complited quicly then I checked the screen but It was still slow. Then I ran On-hand entries cleanup job, I gave 0 as a paremeter. It was finsh about 15 hours and deleted about 800K record, our database decreased by 2 GB, we have ran first time and we have data the total of 4 years. I checked the screen when it was complated, the screen was still slow then I restart the all servers. if we don't get a complaint about slowness in the week, I think it was working.

Was this reply helpful? Yes No
jannawangD365 on at

Like (0)

Report

good to know it's working, Faruk. Cheers.

Was this reply helpful? Yes No