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

Notifications

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) / Frozen client - Releas...
Microsoft Dynamics AX (Archived)

Frozen client - Release approved purchase requisition form

(0) ShareShare
ReportReport
Posted on by Community Member

Hello,

Recently we are facing performance issue with the form: Procurement and sourcing>Purchase requisitions>Release approved purchase requisitions. In our PROD environment it locks the client  occasionally when simply traversing between the records (on different records, there is no rule). In such case only killing the client can help the user to work.

I see that it is connected with infoboxes - when infoboxes are closed or turned off (in Client performance options) it works fine. We tried to debug but no luck, seems that it is something in the kernel. I also tried to use trace parser - but the same - I was not able to catch anything valuable.

I checked the same in standard AX version (application 6.3.5000.133) with Contoso database and I faced similar issue - form was freezed.

Version in our PROD:

Dynamics AX 2012 

kernel: 6.3.5000.2713

application: 6.3.2000.323

Best regards,

Maciej

*This post is locked for comments

I have the same question (0)
  • Vilmos Kintera Profile Picture
    Vilmos Kintera 46,149 on at

    When there is a "freezing/locking" in AX UI it is typically due to a slow performing query or database lock. What do you see on your SQL Server?  How does your Query Execution Plan look like for the problematic SQL statement?

  • Community Member Profile Picture
    Community Member on at

    Unfortunately in this case there are no activity on SQL side. No running queries for the SPID of Ax user, no locks.

    Seems rather like some kernel glitch.

  • Vilmos Kintera Profile Picture
    Vilmos Kintera 46,149 on at

    What does the trace show? That should highlight badly designed display methods which can lead to such behaviour due to lack of caching for example.

  • Community Member Profile Picture
    Community Member on at

    In the trace I did not find any long queries/methods.

    Last writes are:

    >PurchReqConsolidationPart::FormDataSource::linkActive

    >>PurchReqLine::FormDataSource::cancelTimeout

    >>PurchReqConsolidationPart::FormDataSource::leaveRecord

    >>Map::lookup - repeated couple times

    >>ClassFactory::QueryRunClass

    >>Map::exists

    >>Map::insert

    >>Map::lookup - repeated multiple times

    >>Query::pack

    Best regards,

    Maciej

  • Vilmos Kintera Profile Picture
    Vilmos Kintera 46,149 on at

    Did you collect a client and a server trace too? They are separate. Long running statements and complex code would be showing on server-side trace, while the pasted parts indicate a client trace (query and datasource-related calls).

  • Community Member Profile Picture
    Community Member on at

    Yes, you are right Vilmos, I checked only client-side trace.

    But now after checking the trace on server side I cannot say more :( The longest SQL query was 32ms, the longest X++call was 1200ms - which can't block the client as in my case.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Priya_K Profile Picture

Priya_K 4

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#3
Ali Zaidi Profile Picture

Ali Zaidi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans