Jump to content
Sign in to follow this  
turner_marketing

Databases going bad

Recommended Posts

We use a database in our office that is housed on our Mac OSX server (XServe). It is accessed accross in single user mode by 8 different users at various times. Some of the users are Windows XP users using FM6, some are Mac OS 9.2 (using FM 5 and 5.5) and some are Mac OS 10.2.4-6 (using FM 6). What is happening is that this database is frequently requiring the use of the recover function to be opened. A couple of weeks ago even this wouldn't work, so I rebuilt the database from scratch and imported the data from the previous day's backup. I thought this would solve my problem, but now I am having to recover the file again. Does anyone have any idea why this may be happening to this database? It isn't happening to the other databases, even the databases this one is related to.

Share this post


Link to post
Share on other sites

RE: It is accessed accross in single user mode by 8 different users at various times.

Server??? In any case -- do not use FM server on MaxX.

Good versions are all others, like MacOS, Linux and Windows.

Share this post


Link to post
Share on other sites

No, we are not currently running FM Server. I have read in the various posts that it is not very stable with OSX. Since an XServe is what we have and we won't be switching any time soon, I don't know where to go from here. Perhaps I could get a cheap OS9 computer just to act as the FM Server? Do you think running FM Server would solve the issue of the files going bad?

ps

For those that will try to knock down the Mac OSX Server because of this issue: it has been the easiest to administer, most stable server I have ever used. It has literaly never had an unplanned shut down. It easily provides file sharing for all of the computers listed in the original post. This is the first compatibility issue I have encountered with this server.

Share this post


Link to post
Share on other sites

RE: No, we are not currently running FM Server... It easily provides file sharing for all of the computers listed in the original post.

You are doing something wrong and that is corrupting your FM databases.

Share this post


Link to post
Share on other sites

The problem is not with OSX servers. But there are known problems with FM Server running under OSX corrupting the FM files. FMI knows about this but there is no fix yet.

You say that users are not accessing the files at the same time. How do you know for sure? If they are, then that is the cause of the corruption.

I suggest you get hold of a cheap computer with OS9, Windows or Linux and run FM Server on it. And, turn File Sharing off to make sure that users don't access the files except by the "hosts" option.

Share this post


Link to post
Share on other sites
Guest

No, we are not currently running FM Server. I have read in the various posts that it is not very stable with OSX. Since an XServe is what we have and we won't be switching any time soon, I don't know where to go from here.

Yeah, everyone is bad mouthing FMS here, but we are now into our seventh month using FMS on OSX without a reboot.

Share this post


Link to post
Share on other sites

Yeah, everyone is bad mouthing FMS here, but we are now into our seventh month using FMS on OSX without a reboot.

The problem is usually when the service is stopped -- FMS corrupts FM databases. It was confirmed by FMI. Maybe it is just waiting for you in near future. Backup twice as much as with other OS.

Share this post


Link to post
Share on other sites
Guest

That's interesting. Are you running it on OSX or OSX server?

We are running a dual G4 with mirrored drives and OSX (not server). I would definitely do all development off line and use FMPS's automatic built in backup capability daily (seven scheduled backups named M,Tu,W,Th,F,Sa,Su) when no one is around. Then encrypt the backups and manually burn them to CDR weekly.

Share this post


Link to post
Share on other sites
Guest

The problem is usually when the service is stopped -- FMS corrupts FM databases. It was confirmed by FMI. Maybe it is just waiting for you in near future. Backup twice as much as with other OS.

I have shut down FMS many times while setting up the server. It may be crashing and burning for some users, but it is working well for us.

Share this post


Link to post
Share on other sites

So I downloaded the trial version of FMS to see if it would cause me problems. However, I can't even get the thing running. I installed it and it started, but as soon as I accessed a menu item, it stopped running. When I tried to start it again, it said there was an instance of FMS already running. Is this the type of problems people have been having?

Share this post


Link to post
Share on other sites

I've been having problems like Turner describes on a few occassions with the paid version as well.

Problem seems to be that the actual server and it's user interface loose communication. Sometimes it helps to look at the event log to see what's actually happening (event log sits in the FIlemaker server folder and opens with the console app)

Best thing to do when the server is running is to just let it run, don't shut down the computer and open and close the files via a client with the server plugin installed.

I find it quit frustrating that Filemaker, being an Apple-owned company, do not get their stuff together on this matter.

Regards,

Ernst

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Similar Content

    • By Tumma K
      Hello, All!

      I am an aspiring developer for Filemaker. The company I work with is stuck in the past working off of Filemaker Pro 4.1

      I was given the task of bringing us up to Filemaker Pro/Server 13. So far my conversion prototypes are successful but we recently had a layout issue that can only be fixed in versions 3-6 (as the file is an .fp3) I work off of a macbook while our network is all Windows 7. In order for me to repair the layouts without tampering our active database, I decided the best option is to repair a copy of our solutions off the network. Unfortunately, when I go to download the trial version of Filemaker Pro 6 off of the respected website, the file is corrupt! I've tried multiple times, with different extraction apps and in different directories.

      My question is;

      Does anyone know a place where I could obtain version 6 (or better yet, 4.0) for an OSX computer? I've looked everywhere!
       
      Thank you for your time,
      Tumma K.
    • By MrEddByrnes
      I'm hoping my question can have a happy ending. In the mid-90's, I purchased Filemaker 3. When Filemaker 5.5 Pro was released, I bought the update CD, which requires the user to either have FM 3 installed or to have the installation CD for FM 3. I've used it all these years, most recently with Windows XP Pro, and it has worked just fine. The databases I began with were long ago converted to FM Pro 5.5 databases.
       
      I'm still using FM Pro 5.5 on a laptop with WinXP Pro, but in 2013, I purchased a PC with Windows 8. I haven't been able to install FM 3 on it, therefore can't install FM Pro 5.5. I am retired and rarely use Filemaker, but I have a few Filemaker databases I'd like to add to my Win 8 machine. I don't feel it's worth upgrading FM for the sake of using a couple of databases.
       
      Has anyone else run into this situation and/or have a (possible) solution? Is there perhaps any other software that can read FM 5.5 databases? Thanks in advance for your help.
       
    • By bmill
      I am using a custom filemaker solution for medical office billing written with fp5 running on a mac with snow leopard. In addition, I have a patient management db (which I wrote) that is linked through pt. ID number to the billing program allowing transfer of some demographic information (name, DOB, etc).
       
      Other than being limited by hardware restrictions, the billing program serves our needs for now and upgrading to fp12 will take some time (and money).  In the meantime, I am upgrading my pt. management program to fp13 and would like to move new patient demographic information from the billing program ( fp5 running on snow leopard through Parallels) and the new pt management program ( fp13 running on OS X 10.9) on the same mac.   
       
      Ideally, demographic information would be entered once into fp5 and then a scipt would make the data available for fp13.
       
      Any ideas on how to make this work?
    • By randyinla
      Hi, can anyone tell me why my on-line database might have stopped allowing me to delete records?  All of my access privileges and passwords are correct.
       
      thanks!
    • By randyinla
      Hi, I still use filemaker 5.5 and am very happy with it and don't want to upgrade.  Does anyone still host filemaker 5.5?  Thanks!
  • Who Viewed the Topic

    10 members have viewed this topic:
    vwgtiturbo  mvoogt  Josh Ormond  Arkarna  Aris Ongaro  Richard Carlton  MorFologist  sal88  djc728  Lee Smith 
×
×
  • Create New...

Important Information

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