AX 2012 opens the released products menu items open it very slowly.

(6) Share

Report

Posted on by CU30040216-0

When the user opens the released products menu items, it is very slow and takes about 3 minutes to open it. so how can i solve it ?

thanks

Categories:

Microsoft Dynamics AX

I have the same question (0)

All responses (4)

Answers (2)

Suggested answer

Arvind Bharti 720 Super User 2025 Season 2 on at

Like (1)

Report

Hi,

This would defintely require analysis from technical team.

Do you have any customization on this list page or form which is getting displayed using some logic?

May be reach out to technical consultant in your team to idetnifiy what is causing delay

Was this reply helpful? Yes No
Verified answer

Adis 6,069 Super User 2025 Season 2 on at

Like (1)

Report

Hey,

I guess you have custom code somewhere? One reason could be that when you open it there is information from other tables. If the query that pulls the data is not optimized or the DB in general is not optimized it can lead to very slow queries, ie. opening the form.

Even without custom code its hard to determine where this is coming from as the amount of data is different from each company.

Although, its not a quick solution, however, still the quickest would be to debug this and check which part of the query takes the most.

Kind regards, Adis

If this helped, please mark it as "Verified" for others facing the same issue

Keep in mind that it is possible to mark more than one answer as verified

Was this reply helpful? Yes No
Verified answer

Zain Mehmood 4,187 Most Valuable Professional on at

Like (0)

Report

Hi,

If the Released products form in AX 2012 takes several minutes to open, it’s likely due to performance or capacity issues. Common causes include:

Too many records loading without filters — try opening with filters (Ctrl+G).

Heavy display methods or joins on the form — these can slow performance, especially on large datasets.

SQL performance/capacity — check for missing indexes or high table size (e.g., InventTable, EcoResProduct).

AOS or SQL server load — system capacity (CPU/memory) might be strained during peak usage.

Customizations — review any custom logic in form init() or data sources.

You may also want to run a SQL Profiler trace or use Trace Parser to pinpoint the exact delay.

Warm Regards,

Zain

Was this reply helpful? Yes No
Suggested answer

CU30040216-0 18 on at

Like (0)

Report

Thank you for your responses. We have asked the consultant to handle it。

Was this reply helpful? Yes No

Join the conversation

Community site session details

AX 2012 opens the released products menu items open it very slowly.

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

AX 2012 opens the released products menu items open it very slowly.

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates