Skip to main content
Solved

Is it possible to schedule 'Refresh All Inventory Parts' job based on a Site?

  • October 5, 2021
  • 4 replies
  • 188 views
Nimesh Kasun
Hero (Employee)
Forum|alt.badge.img+10

Hi community,

Product: App9 - UPD16

 

A customer has 24/7 service globally and they are scheduled to run Refresh All Inventory Parts twice a day. It’s running for 2+ hours sometimes (not identified the situation). Usually it runs within 10mins for them. 

Since they have many mobile users connecting to the system during the same time period, and since the job locks all these user sessions, the system run out of the connection pool and goes down for all users.

 

Question:

Can this job “Refresh All Inventory Parts” scheduled to be run based on site?

 

So that they can schedule few jobs where each job runs in off-peak time for each site. Appreciate any inputs.

Best answer by Bandula

Hi @Nimesh Kasun  Yes, if the workaround implemented they don’t need to run the task daily. 

But please note current refresh task collect part/user data from different sources. eg.connected warehouses, materials, returns and few more. So if they not run the task daily, their custom method need to take care of all. 

Please have look on   Mobile_User_Invent_Part_API.Refresh_All_Inv_Parts()  method in plsq. Then you can get an idea how we populate the table. 

Nimesh | www.linkedin.com/in/nimeshkasun | www.twitter.com/NimeshKasun
Subash Perera
Bhanuka Senevirathne
Asela Munasinghe
This topic has been closed for replies.

4 replies

Bandula
Hero (Employee)
Forum|alt.badge.img+12
  • Bandula
  • Hero (Employee)
  • October 6, 2021

Hi Nimesh,

In the current design, first thing done inside Refresh_All_Inv_Parts() method is delete all records in MOBILE_USER_INVENT_PART_TAB

Then run different cursor to repopulate the table. eg. connected warehouses, materials, returns and etc.

So it is not possible to run based in site. 

But you can try out a workaround solution like writing a custom method or event to insert records (new part/user combinations) to MOBILE_USER_INVENT_PART_TAB when you want to send a new part. Then you can keep Refresh_All_Inv_Parts job to off peak time.

 

Subash Perera
Nimesh Kasun
Asela Munasinghe
Nimesh Kasun
Hero (Employee)
Forum|alt.badge.img+10
  • Nimesh Kasun
  • Author
  • Hero (Employee)
  • October 6, 2021

Hi @Bandula,

Thank you for the response.

If the customer implements the workaround, then is it ok to run the Refresh_All_Inv_Parts job during weekends? Will that be an issue?

Because, customer doesn’t have common off-peak hours as users are accessing the system globally. 

 

/Nimesh

 

Nimesh | www.linkedin.com/in/nimeshkasun | www.twitter.com/NimeshKasun
Bandula
Hero (Employee)
Forum|alt.badge.img+12
  • Bandula
  • Hero (Employee)
  • Answer
  • October 7, 2021

Hi @Nimesh Kasun  Yes, if the workaround implemented they don’t need to run the task daily. 

But please note current refresh task collect part/user data from different sources. eg.connected warehouses, materials, returns and few more. So if they not run the task daily, their custom method need to take care of all. 

Please have look on   Mobile_User_Invent_Part_API.Refresh_All_Inv_Parts()  method in plsq. Then you can get an idea how we populate the table. 

Subash Perera
Nimesh Kasun
Nimesh Kasun
Hero (Employee)
Forum|alt.badge.img+10
  • Nimesh Kasun
  • Author
  • Hero (Employee)
  • November 26, 2021

Hi @Bandula,

Thank you for your support. Customer has implemented the suggestion from their end.

/Nimesh 

Nimesh | www.linkedin.com/in/nimeshkasun | www.twitter.com/NimeshKasun
Terms & ConditionsCookie settingsAccessibility statement