We help IT Professionals succeed at work.
Get Started

Filemaker Pro damaged

FujiMed
FujiMed asked
on
544 Views
Last Modified: 2012-05-11
Hi,

Unfortunately I'm no DB admin nor knows anything about filemaker.
One of the software supplied that we are supporting uses filemaker as a back end.
Out of the blue one day, we got reports from the users that the software cannot access the database.
I checked the server and found the following errors:

Database "databasename" is damaged and has been closed.

I restarted Filemaker server and the software was able to access the database again.
A few hours after, the error message comes back and the database went down again.
This has happened a few times now.

We escalated to the software vendor, yet their response was that it has to be a third party influence.

1) File backup ran on the database file while it is live.
We confirmed that the folder where the database is sitting has been excluded and the schedule of the backup does not coincide with the database going down

2) Anti-Virus
The only AV running on the server is only scanning applications on memory and not the files.

Other than that, they couldn't see anything else.
They said they have tried to recover the database, but after the recovery, the error still occurs.
I did ask them if the database is damaged and cannot be used anymore, they said it's impossible because after the service is restarted the database is normal for a few hours, meaning the integrity of the database is intact.
Seems the vendor has reached their conclusions that it's either third party or OS and therefore off their case.

A year ago we had a similar issue with the same database, back then the issue was with the backup, the folder exclusion has been accidentally deleted causing the file to be backed up while live. Could an incident from a year ago have caused the database file to be corrupted?

Does anyone have any suggestions what else we can look into?
Comment
Watch Question
FileMaker Database Developer
Commented:
This problem has been solved!
Unlock 1 Answer and 4 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE