Errors!! Missing Records HELP!

September 1, 200421 yr

Haven't seen this before. I have a few databases that contain thousands of records each, that relate to a main "Contacts" database via 1 to Many relationship.

When I look at the records in a portal on the Contacts database, I see all the records I expect, no issues.

When I look in the database directly, there is only 1 Record! The file size is correct. And I can do a recover and all the records appear in the actual database again.

Has anyone seen this kind of thing before? The files are hosted on FM Server 5.5. I know what to do to fix the databases now, how do I prevent this from happening?

Thanks!!

September 2, 200421 yr

have you tried showing all records in the file yet? perhaps you have a find inplace that's hiding the other records.

September 8, 200421 yr

Author

Yeah, I'm sure that it was a database error. When I looked at the file, it showed 1 record in the entire database. Not in a find.

I'm pretty sure the DB got corrupted. It happend to a few of the files we were using.

I'm not sure yet what caused it to happen suddenly.

<shrug>

Thanks

September 8, 200421 yr

Hi Munchie,

I'm not familiar with Server, and there is always the chance that the files could be corrupted, but it doesn't sound that way to me. If this was a single user environment, I would guess that you are using a Go To Related Record (GTRR), and that the script is set to show Only the RR.

Lee

September 14, 200421 yr

Author

Hey Lee, thanks for the response.

I don't think it is related to that. I'm having another issue that I posted in another area about a printing issue that has been happening during the same time I believe the database corruption happened.

http://www.fmforums.com/threads/showthreaded.php?Number=119032

I recovered the DB's, and it hasn't happened again. I'm asking this, because I Haven't figured out how to prevent it. I've attached an image that shows the scroll bar that is causing the issue. I'm thinking this issue crashes the server, and corrupts the database.

When doing this printing loop, I use ProPrint Mega to change printers. Print a letter, change to envelope printer, print envelope, change back, and goto next client.

Any help you can provide on this error would save me some Tums!