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

v3.2 - Iman jobs seems to be "stuttering" during creation of records in SQL table & duplicating records (3 replies)

Sue Herrmannn
5 years ago
Sue Herrmannn 5 years ago

I have a client on Iman v3.2 and I built a job that reads a few csv files, formats the data and inserts records into a SQL table. I have the SQL table built to autogenerate a unquifier for each record - the field is called PMTUNIQ. I have the job's concurrent instances set to 1 - so they can't run the job when it's already running. We have noticed that about 1-2 times a month, the job seems to "stutter". It takes the first 10 or so records from the csv file and inserts records into the SQL table, and then it might do those same records again a few times, and finally it cycles through one more time at the end and ALL the records.

Please see the following attachments:

2 csv files - these are the csv files that the Iman job reads

Payment 2019-06-14.pdf - this is a report that shows what happened with the records. the job was only run once that day, but you can see it created 10 records, starting with PMTUNIQ 35,306 and ending with 35,315. And then it did the same records again (PMTUNIQ 35317 to 35326). And then it did it again. And finally it created all 487 records starting with PMTUNIQ 35339...

Iman job events.bmp - proof that this is a very simply job - 4 steps only, not much logic there, so it's not likely to be my job logic. (Plus, the stutter only happens about 1-2x/month, and they run this job daily M-F.)

Thanks for your help!

Payment-2019-06-14.pdf
Support
5 years ago
Support 5 years ago

Are there any errors?

Sue Herrmannn
5 years ago
Sue Herrmannn 5 years ago

Ha! Good question - sorry! No, no errors - I have it set up to send me an email if there is a transform error, and I never got an email. I also checked errors.txt for the date this was processed and no errors on this job at all. (Gotta love those undocumented, intermittent issues - sorry!)

Support
5 years ago
Support 5 years ago

This was actually an issue with the data....IMan does not stutter.

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