Maximo Open Forum

 View Only

 we have around more than 1 lakh record stucked IN HOLD status how can i reprocess them all on a single go

  • Everything Maximo
  • Integrations
  • Maximo User Groups
Pradeep Rout's profile image
Pradeep Rout posted 03-08-2022 01:08
we have around more than 1 lakh record stucked IN HOLD status how can i reprocess them all on a single go.
I have changed the external system queue setting try count from 1 to 5.
But is there any way to change the status of all records from Hold to RETRY so that they can process sucessfully. Please note curently the DB fetch limit is set to 5000.
Steven Shull's profile image
Steven Shull

I'm not sure what you mean all at once as Maximo wouldn't process 100,000 messages simultaneously even if you forced them all to reprocess. I would filter your list down to <5000 records and choose the action to process all messages and it will reprocess everything in your filtered list.

You could either remove the stop limit on MAXINTERROR (add it to the mxe.db.fetchStopExclusion system property) or bump your fetch limit higher (either bumping mxe.db.fetchResultStopLimit or create a new system property as mxe.db.fetchResultStopLimit.MAXINTERROR which would be specific to that object) but I wouldn't recommend that myself. 

Venkataraman Guruswamy's profile image
Venkataraman Guruswamy
To add to what Steve mentioned above it is unclear as to what kind of queue setup you have. Do you have a continuous queue to allow parallel inbound processing ? Or is this outbound ?
Irrespective of this, you may have to do in batches and wait for the backlogs to clear. This will ensure that there is no data loss or synchronisation issues across systems.