Skip to main content
Answer

Execution Timeout Period Expired" issue with a Generic Inquiry (GI)

  • October 16, 2023
  • 4 replies
  • 329 views
Sagar Greytrix
Captain II
Forum|alt.badge.img+3

Hi Experts,

I'm currently facing an "Execution Timeout Period Expired" issue with a Generic Inquiry (GI). When I remove the grouping in the GI, it loads successfully. However, when I apply grouping, it takes an excessively long time to load and eventually results in the "Execution Timeout Period Expired" error.

Interestingly, I tested this on my local instance, and the GI loads without any issues. But when I try it with the client's data, the timeout problem occurs. I suspect that I might have missed something in the joins, but I'm having trouble pinpointing the exact issue.

I would greatly appreciate any assistance or guidance to resolve this issue.

Best regards, Sagar

Best answer by Manikanta Dhulipudi

Hi @sagar07 

If you are facing an execution time out please create a case with Acumatica and increase time for executionhttps://asiablog.acumatica.com/2017/09/database-timeouts.html

Or else

please disable all results data once and troubleshooting the Generic inquiry by enabling one joins and verify the results, then after enable another join.

First suggestion to enable below child relation 

 

1 Attachments
Sagar Gadge Team Lead - Acumatica O: +91-22-67687800 E: sagar@greytrix.com

4 replies

Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+15

Hi @sagar07 

If you are facing an execution time out please create a case with Acumatica and increase time for executionhttps://asiablog.acumatica.com/2017/09/database-timeouts.html

Or else

please disable all results data once and troubleshooting the Generic inquiry by enabling one joins and verify the results, then after enable another join.

First suggestion to enable below child relation 

 

Acumatica Functional Consultant & Customer Experience Supervisor
Chris Hackett
Sagar Greytrix
dcomerford
Captain II
Forum|alt.badge.img+15
  • dcomerford
  • Captain II
  • October 16, 2023

From a quick look at the GI it looks fine but the tables you are using would contain a lot of data so it is going to be quite timeconsuming especially with the grouping which always makes it slowever. As @manikantad18 suggests you can ask Acumatica to increase the time out.

I would review the GI and see if you can eliminate any unncessary tables or tackle it in a different way. Also see if you can use the conditions to filter out any unneeded records. 

Dermot Comerford
Chris Hackett
S
Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Naveen Boga
  • Captain II
  • October 16, 2023

@sagar07  I have seen the issue with JOIN CONDITIONS in all the places. I just modified your GI and attached it for your reference.

 

Please check and let me know if you still facing the time-out error.

1 Attachments
Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
Chris Hackett
Sagar Greytrix
Sagar Greytrix
Captain II
Forum|alt.badge.img+3
  • Sagar Greytrix
  • Author
  • Captain II
  • October 17, 2023

@Naveen Boga @manikantad18@dcomerford  Thank you so much for your prompt responses.

I have resolved the issue by modifying data field links.

Regards,

Sagar

Sagar Gadge Team Lead - Acumatica O: +91-22-67687800 E: sagar@greytrix.com
Terms & ConditionsCookie settingsAccessibility statement
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved