Jump to content

All fields in a record show question marks


This topic is 5761 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I've seen this a couple of times in different DB's where a record in a database display question marks (?) in all the fields. When I perform a file recovery, no errors are reported, but the record in question disappears. What is odd is the record can be found based on data that was on the record, say, by Student ID number. As far as I can tell the record is completely corrupted so I import a good copy of the record from a backup. Any ideas on why this is happening?

Link to comment
Share on other sites

It sounds like corruption. Any file which recovery was performed on should not be used again. Instead the recovered data should have been exported and reimported into a clean backup.

Link to comment
Share on other sites

... When I perform a file recovery, no errors are reported, but the record in question disappears. ..

Has this File been closed by a system error, power failure, or has FileMaker just quit?

Was this file converted from a older version of FileMaker?

HTH

Lee

Link to comment
Share on other sites

Has this File been closed by a system error, power failure, or has FileMaker just quit?

Was this file converted from a older version of FileMaker?

Lee

Not recently. I was able to the track progression of the corruption using our nightly backups. The records became corrupt over a two day period (Friday and Saturday). On Saturday the file was only accessed by our "Sentinel" box so that leads me to suspect it. This box is set up to automatically import data every morning around 5:45 AM & runs 24/7. It has not had a problem in weeks so I don't think it is crashing out, but the imports are kinda big so that might be munching the data.

As for the conversion question... Yes, it has been converted over the years starting with FMP 4 or 5. I've never seen problems like this in any of our DB's hosted by FMS 4, 5 & 7. We did upgrade this year to FMP 9 Server Advanced, but can't directly tie this issue to the upgrade.

Thanks,

Darrin

Link to comment
Share on other sites

Not recently. I was able to the track progression of the corruption using our nightly backups. The records became corrupt over a two day period (Friday and Saturday). On Saturday the file was only accessed by our "Sentinel" box so that leads me to suspect it. This box is set up to automatically import data every morning around 5:45 AM & runs 24/7. It has not had a problem in weeks so I don't think it is crashing out, but the imports are kinda big so that might be munching the data.

Sounds like you have nailed it.

As for the conversion question... Yes, it has been converted over the years starting with FMP 4 or 5. I've never seen problems like this in any of our DB's hosted by FMS 4, 5 & 7. We did upgrade this year to FMP 9 Server Advanced, but can't directly tie this issue to the upgrade.

Take a look at this white paper about file corruption Link, and the white papers available at FileMaker Inc on Migration.

HTH

Lee

Link to comment
Share on other sites

This topic is 5761 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.