Welcome to the Sage 300 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
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?
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.