Solved

System queues monitor - queue size is possibly exceeded


Userlevel 2
Badge

Hoping someone can help. I wonder if I can have a few ideas on how to resolve/investigate this case as we are experiencing this issue to one specific site. The queue size is overloaded not letting a business event get triggered.

 

I have tried cleaning the queue and restarting the dispatcher, and it works fine, however, the next day I checked the business event history and no further events had been triggered so I updated one customer to ensure it was still working and it didn’t work. Then I manually cleared all the queues again as I did previously, retested the customer and it worked…

 

how can we optimize the system so this will run as it should?

Furthermore, I’m comparing a few GIs and Business events but I have no idea what is causing this as the GI has only a few records. 

 

 

Thanks !

icon

Best answer by jeffersonmacedo 1 July 2022, 08:09

View original

9 replies

Userlevel 7
Badge +17

Hi, @jeffersonmacedo  There are a couple of reasons for this issue.

  • Push Notification associated GI, may have bad joins getting the huge dataset and cause this issue. (Push Notification is should be as much as simple like without joins,group by and etc.)
  • Also, we need to review the Business Events, it may trigger frequently, and trying to insert the details into the set.  

@Naveen Boga you rock! This is exactly what we were experiencing and using this approach were able to identify the problem GI. Thanks again! 

Userlevel 7
Badge +17

@ngohil15  I’m glad that you review my comments and solve the problem. Thanks for sharing the update.

Userlevel 2
Badge

Hi @Naveen Boga 

I resolved this issue after exporting the messages from MSSQ and then I could identify the culprit business event.

 

Thanks

Userlevel 1

@jeffersonmacedo 

I am wondering if you could share with the rest of us how you were able to export the messages to identify the problematic business event?  Thanks in advance!

Userlevel 2
Badge

@Naveen Boga   Each Business Event has it’s own GI, so once the field is changed it is supposed to get triggered only to that record. 

However, I can see the option “Raise Event” is set as “For each record” in Business Event’s screen, so is it going to run against all records even if it hasn’t got changed? It’s my first time investigating this screen and I couldn’t find the definition of these options on Acumatica Wiki. 

Also I noticed the dropdown seems to have a misleading sequence:

 

The GI sent previously returns 24 records, second GI returns 17 records and the third 23.

I was trying to find out how to export the latest messages sent to MSQS, maybe it helps to find out where the issue is coming from?

 

Thanks

Userlevel 7
Badge +17

Hi @jeffersonmacedo  Great :) Thanks for the sharing update.

Userlevel 2
Badge

Thanks for your reply @Naveen Boga . I’m currently checking the GI’s

 

About the Business Events, do you think the configuration below should be an issue? We have 3 similar records linked to the GIs according to the Credit %

 

The other 2 Business events and GIs have a similar configuration and returns less than 20 records.

 

is there any way we determine which process is overloading the queue?

Userlevel 7
Badge +17

Hi, @jeffersonmacedo  Business Event configuration looks good to me.

As you are saying their similar records liked to GI, can you please check when BE is triggered, and how many records are getting affected in the GI?

 

Reply


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