At 03:58 PM 3/13/2008, John Engwer wrote:
I have a table with 500,000 rows that produces one error during
a reload.
-ERROR- Values for rows in UPC_MASTER must be unique. (2738)
The table has one Column with a PK.
When I search the table for duplicates, I find none.
Delete Duplicates from Upc_Master using ColumnWithPK
(no duplicates are deleted)
Autochk (no errors)
Rscope (no errors)
Does anyone have a suggestion as what may be wrong?
I am using the latest version of V8ee
John,
Why not run the UNLOAD/LOAD procedure to find the "exact" problem.
See my posting on 03/12/2008 4:03 PM (EST) for step-by-step
instructions.
Do yourself and your lovely clients a big favor! Perform one
additional task (UNLOAD/LOAD) to validate the integrity of your
database.
Believe me, the time spent on this exercise will save you a lot
of hassle and embarrassment, instead of chasing something obvious
that should have been taken care of a long time ago.
Very Best R:egards,
Razzak.
