Thanks Razzak and James Bentley. I finally found the offending row. There was a space in a column defined as real number. It was 1 in 3,673.
I found it by the process of eliminating rows (500 at a time) from the reload .DAT file until it loaded without error. ONE IMPORTANT LESSON LEARNED: I did not know the error message came from the RULES for the table. If I had searched the RULES first, I would have seen the message and known the column in question. I still consider myself a newbie with R:Base. Thanks again for your support. Dayle Coxen Florida DOT (850) 410-5635 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: Thursday, February 10, 2011 10:15 AM To: RBASE-L Mailing List 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.
