Why are we getting the ICM18174 error in DataMigrator?

We have the commit set to 10000 and get this after processing 160000 of the 169000 rows. Is it that it's actually not an error, just that it hasn't made it to the next commit which should happen at 170000?

The "? 18174" command show the following:

? 18174
(ICM18174) Agent has been forced to terminate
 Agent is crashed, hard killed or terminated by other unexpected event.

Thanks Again, Doug

This message has been edited. Last edited by: FP Mod Chuck,

That is a crash. Can you explain your flow in detail?

Yeppers, It's is a crash

More Info, step by step:
Assumptions:
A) This is based on 169123 rows in the source.
B) The proc is set to update/add.
C) On Match Update.
D) On NOMATCH Include.

1) Start with a new or truncated destination table.
  * Run the DM proc.
  * All 169123 rows.
  * No error message.
  * Stats show that 169123 inserted.
2) Deleted 10 rows from the destination.
  * Rerun the DM proc.
  * The destination still has 169113 rows.
  * Ends in ICM18174 error, agent crashed.
  * Does not show any stats after the crash.
3) Expected Results of step 2:
  * Rerun the DM proc.
  * The destination should haves 169123 rows.
  * Does not end with an error.
  * Stats show that 169113 rows were updated.
      And 10 rows were inserted / included.

So, what's missing?

Does it do the same thing if you reduce the process to say 10k rows?

quote:

Does it do the same thing if you reduce the process to say 10k rows?

Checking... When I can get to it...