Yes but they are out of state, I could have them Zip the files and then look at them. But would the type of corruption help pin point the problem? I would rather it be something I can fix compared to messing with network techs.
Marc From: Paul InterlockInfo Sent: Thursday, August 19, 2010 3:02 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Corrupt DB Do you have Rscope? If so are the extra row pointers at the end or middle? 7543 vs 7541 two extra entries with missing pointers. Sincerely, Paul From: [email protected] [mailto:[email protected]] On Behalf Of MDRD Sent: Thursday, August 19, 2010 3:58 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Corrupt DB Dennis I checked the indexes and here they are --- ------------------ ------------------------------------------------------ 1 custnum Type : INTEGER NOT NULL Consrnt: FOREIGN KEY REFERENCES PTINFO Consrnt: UNIQUE 2 Date_con Type : DATE 3 TxDate Type : DATE NOT NULL Consrnt: UNIQUE 4 Treat_dr Type : TEXT 2 Consrnt: FOREIGN KEY REFERENCES DRINFO This is the error Examining data in TravCard Rows: Active 7541, Deleted 0 Actual rows counted: 7543, expected count: 7541 -ERROR- The number of rows counted was not expected. (1254) Thanks Marc From: Dennis McGrath Sent: Thursday, August 19, 2010 2:43 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Corrupt DB It could be that is that is the only table that user hits frequently. Network connection is high on the list of causes, card or cable. One other issue to check, the indexes on that table. Are there any indexes that are highly inefficient, i.e. one value predominates, like NULL? If so get rid of the bad index(es) I had one client that required a rebuild of the db on a regular basis because it kept getting corrupted. Eliminated a bad index and I haven't had to fix it for years!!!! Dennis McGrath -------------------------------------------------------------------------------- From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Thursday, August 19, 2010 1:17 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Corrupt DB Is the corruption always happening in the same table? If it is, then it is hard to make a case that it's something hardware or network related... Karen
