Question

Cancelling 7000 tasks assigned to a mobile user

  • 18 August 2022
  • 2 replies
  • 56 views
Thilina Gurugamage
Rank
Userlevel 3
Badge +7

This question was raised by a FSM 6 IFS managed customer via a Support Ticket.

 

Last week an operational user triggered multiple mass updates that resulted in the mobile message queue climbing to 4M messages. They have requested a rolling restart and believed that this queue would stopped.

 

As of today it looks like these messages are queued again.

They have a single user that has 7K of tasks assigned to him and they need to kill that queue as these work orders were pushed in error. If we try and cancel these WO we will add tasks to the already backlogged queue.

 

Is there a safe way to cancel these WOs?

 

Thanks.

 

Best regards,

/Thilina

2 replies

Thilina Gurugamage
Rank
Userlevel 3
Badge +7

Customer has added a screenshot. User Larry with 7k in the queue.

1 Attachment
Lee Pinchbeck
Rank
Userlevel 7
Badge +24

Hi @Thilina Gurugamage,

It depends on whether there was anything on the users mobile device still waiting to sync back to the database. If the device is clear then you can remove the device from the person device list and this will clear the queue. Then, once you are happy that only the correct data is set to sync, re-initialise the device.

If there are items still waiting to sync then you will either lose that information and it will need to be captured prior to re-initialisation and entered manually or the queue would need to be amended manually in the database. Please be aware that the latter should only be done by an experienced DBA with great care as, whenever data is amended directly, it poses a great risk to data integrity.

Kind regards,

Lee Pinchbeck

Currently reading: The Way of Kings - Brandon Sanderson

Reply


Terms & ConditionsCookie settings