Thanks to everyone for your responses. I am still fighting through this issue. When I perfom the unload.all and reload I get a slew of errors relating to grants. When I unload.all/reload the table that produced the original error does not produce any errors. It ultimately tells me that I do not have access rights to some of the tables even though I am logged on as the owner. The unload.all produces a huge file so it take a lot of time to edit the file to trap the errors. I will continue work on this project over the weekend; time permitting.
The client that is using this database in not having any problems in production. They are currently running on V 7.5 and I am converting to V8. John -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of A. Razzak Memon Sent: Thursday, March 13, 2008 4:34 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Error durung reload >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.
