troubleshoot upgrade to server 8

[swf]

I have had filemaker server 7 running for many months without problem. I upgraded to server 8 today following the steps in exact order. No trouble with that but I have two problems.

1) I need to change the default folder that filemaker server looks in for the databases. The backup program is set to look in the old folder from filemaker 7.

2) 2 of my 3 databases work fine. The 3rd is present but "closed". Trying to open it continually fails. I checked the sharing of the file and it is on for tcp/ip but the "all user" checkbox is greyed out. Is the file corrupted? When connecting via a client this file is not listed as an option.

Thanks for any advice.

[flook]

Hi

I Had the same problem with a database when I upgraded servers, it turned out that Filemaker Server 8 has a consistency checker option which would not let the file open because there was a problem. You can either turn the consistency option off in the server admin or better still repair the file.

to repair the file:

Choose File menu > Save A Copy As > Compacted copy (smaller) - the easiest and most effective fix for many cases. This process will copy all of the data and rebuild the tree structure of the database.

Hope that helps

Edited January 5, 2006 by Guest

[xochi]

I believe consistency check failure would be noted in the server log. Always a good idea to check the server log...

[swf]

I did save as a compacted file and now the file works. I will try to figure out how to check the server log tomorrow when I am back at work. I also was able to change the default backup filepath to match my previous one. (I did not want to rewrite the backup program). I was not able to change the default filepath where server looks for databases. Thanks for all the advice.