Thanks for the quick reply!!!
Can you clarify when you say the database is bad does that mean something is corrupted or I did not do the dump correctly.
Thanks a lot.

Your data is bad.... the dump is worthless. No you cannot fix the database dump files.
Something may be wrong in your live data. Hence the question about which table the load failed on - that is usually a clue of where the problem lies.
So why are you loading data from a dump?

Your data is bad.... the dump is worthless. No you cannot fix the database dump files.
Something may be wrong in your live data. Hence the question about which table the load failed on - that is usually a clue of where the problem lies.
So why are you loading data from a dump?

It fails when processing ICUNIT.

Are you migrating from Pervasive?

The reason for the fail is that you have duplicate units of measure for the same item(s). In other words for one item you have something like each, Each, EACH - the same unit of measure using different cases. If you convert everything to upper case then they are duplicates.