Dayle, If you can extract only the table definition and data for just the table giving you the error message, I would create a database just to load that table. If table depends on other tables just load there first. Object of the game is to deal only with your problem and not any of the other working items. If on loading the data you can't identify the column and row(s) giving you the problem then try breaking the row data into small parts and load them in order to detect problem. Also be sure you table and column names are not using reserved words.
Jim Bentley American Celiac Society [email protected] tel: 1-504-737-3293 ----- Original Message ---- > From: A. Razzak Memon <[email protected]> > To: RBASE-L Mailing List <[email protected]> > Sent: Thu, February 10, 2011 9:15:18 AM > Subject: [RBASE-L] - Re: Issue LOADING table in 9.1 > > At 09:38 AM 2/10/2011, Coxen, Dayle wrote: > > >You are correct. The 6.5++ reload throws the same error. > > > >It must be a very subtle problem with the data. The application > >that uses it works fine. Very curious... > > > Dayle, > > You SHOULD be curious, and should lose sleep until you know that > your database is healthy and you don't know of any error(s). <g> > > Maintaining the data integrity is among the strengths of R:BASE! > > While LOADing the data, values are checked for correct data type, > and an ERROR is thrown for incompatible value(s). The record (row) > with such ERROR is NOT loaded. > > In your specific situation, you will need to correct the appropriate > column(s) value(s) in the original database (6.5++) by using a very > simple approach as follows: > > 01. EDIT * FROM tablename ORDER BY colname > > Once the data is displayed, carefully look at the values from > top to bottom for obvious incorrect values. > > 02. You may also use the "TALLY colname FROM tablename" approach to > view the obvious incorrect values. > > Once you have corrected these specific values, use your favorite > approach to UNLOAD DATA, and then LOAD the corrected DATA in 9.1. > > You may also take a look at the following articles for more details: > > From The Edge: http://www.razzak.com/fte/ > > Topic: Database Maintenance > > Hope that helps! > > Very Best R:egards, > > Razzak. > > >
