John -
Break the UNLOAD/RELOAD into three files. UNLOAD STRUCTURE to one file then break that file into two parts, splitting it at the first CREATE VIEW statement. So that the first half of the file is in databasename1.str and the second half is in databasename2.str. The second file will contain all the GRANT and CONSTRAINT commands. UNLOAD DATA into its own file, databasename.dta. Rename or move the original database files from the working folder. SET MESSAGES ON SET ERROR MESSAGES ON Trace the first file, databasename1.str, noting any errors that occur. If there are any, fix them in the databasename1.str file and re-trace it. Then, do this: OUTPUT databasename.txt WITH SCREEN RUN databasename.dta OUTPUT SCREEN Open the resulting file, databasename.txt and see if there are any errors or other messages. If all is well, make a copy of the database at this point. Then TRACE databasename2.str, again noting any errors or duplicated constraints. If there are errors, fix them in this file, copy from the interim backup and try again. Good luck! Sami ____________________________ Sami Aaron Software Management Specialists 913-915-1971 [EMAIL PROTECTED] From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of John Engwer Sent: Friday, March 14, 2008 8:22 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Error durung reload 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.
