Back to forum list… Back to Issues and Problems...

IMan 4.2 - PU5 - INSTANCEID being reused in same job (2 replies)

Randy
3 years ago
Randy 3 years ago

For some reason IMan appears to be re-using the INSTANCEID

 

Screenshot1: Job "SENT1XCEL1MAGE1-ProductImport" just ran and updated the LASTRUNDATE.  NEXTNO is set to 10567.

Screenshot2: Job "SENT1XCEL1MAGE1-ProductImport" has logged "Starting job." 5 times for INSTANCEID 10567

Screenshot3: Job "SENT1XCEL1MAGE1-ProductImport" has the INSTANCEID value jumping all over the place.  It appears to increment to 10589 before running 10564 twice and then incrementing up to 10571.   After that it appears to revert to 10564 again, running twice.

 

https://www.realisable.co.uk/wp-content/uploads/2021/10/mMY54kIV4v.png
https://www.realisable.co.uk/wp-content/uploads/2021/10/drAfpmOzey.png
https://www.realisable.co.uk/wp-content/uploads/2021/10/cOO6QNOzrw.png
Randy
3 years ago
Randy 3 years ago

Found more instances using a GROUP BY query:

https://www.realisable.co.uk/wp-content/uploads/2021/09/Ssms_NyiSOg0Y37.png
Randy
3 years ago
Randy 3 years ago

Dug a little deeper and this has to do with the Pause Schedules setting.  It appears that when you pause the schedules, any currently schedules jobs will reserve the INSTANCEID value, but if you step through the job, the INSTANCEID is still incremented.  This means that when you eventually un-pause the schedules, the INSTANCEID will go back to a previous value, doubling up like in my screenshots.  Additionally, it appears that the setting of a previous INSTANCEID value is written to the JOBDETAIL job and so it reduces the NEXTNO value, leading to more duplicates.

 

I can show you in a meeting if you want, I am able to cause IMan to double up on INSTANCEID values at will.

https://www.realisable.co.uk/wp-content/uploads/2021/09/xm97jdjPus.png

Contact

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close

Request Demo

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close

Access Downloads

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close