I've got a question about a task possibly running multiple instances of itself creating duplicates in imis db.
99% of the time this task runs fine every 1min and creates rows and sets a flag to indicate these rows don't need to be added again, but for some reason 1% of the time this task seems to repeat the creation of the row causing duplicates. One of our providers suggested we set the maximum concurrent instances option within general tab --> options --> advanced --> to unlimited instances from the previous setting of single instance in hopes of solving this issue. Reasoning being it would give taskcentre more opportunity to catch up if it was behind from running this task every 1min. My thinking is this might not work because allowing concurrent instances would mean the task could create more duplicates by running multiple instances of the create row step before creating the flag step.