database goes offline

[bonitashar]

Database goes "offline" and is not available via the Web, but the database is "open" on the host machine is accessible via FileMaker clients over TCP/IP.

The FileMaker Pro error.log shows the following message "HTTP session disconnected." and "Badly formated url"

Does anyone know what would cause this error?

[Reed]

I've had databases go offline from web publishing too. I'm using a Mac with 10.3.5. What platform are you using?

I've found through looking at the unix top command that the web publishing process starts to utilize a lot of CPU and stops responding to requests. One way to repair it is to open the IWP config dialog, and turn IWP off and back on again.

I've also found that you can restart the web engine remotely by killing just the web process, and restarting it. This doesn't appear to affect FMP clients at all. You have to dig around inside the FMP.app package to find the name of the process to launch from the terminal.

Has anyone else had this problem? Is anyone making heavy use of IWP with server advanced? I'd hate to have to buy server advanced for my small setup just because IWP on regular FMP is unstable. I'd hate even more to shell out all that cash for server advanced to find out that it's unstable too.

I'll stop ranting now.... it's just that the new IWP is sooo cool and it could actually be useful if were more reliable.

[MichelVH]

Me me me ! ! It runs for awhile then the web quits. If I try to quit FM I get a message that there are 1 or 2 people online. I get the option to ASK or Cancel. when I click ASK I get a box that says some poeple (fm...) may not see the ASK. Others (fmiwp ? ) will be automatically disconnected. After clicking all of the proper buttons all I can do is cancel. FM still won't shut down. I think one time I turned off sharing and that fixed it ( I had forgotten that until I read it) Usually I just do a force quit and reopen the file and all is well for a while sometimes more than a day. If anyone has any clues I'm open.

Thanks

Mike

[sdaines]

I have the same with filemaker 6 unlimited and custom web publishing, the only way I can seem to fix it is to force filemaker to quit and reload it.

I am using in on Apples new G5 Xserves and OS X 10.3. It is real problem as we use it all the time.

Cal anyone tell me if upgrading to Filemaker 7 fixes the problem?

[bbjprod]

has anyone found a solution to this problem? im trying to share 5 or 6 files with 20 users. i am running FM 7 on an iMac 500 with 10.3.2 and the machines that are accessing the files are G5 iMacs using Safari.

Thanks for any help.

[JamieT]

I'll add my complaint to the chorus. I'm running FMP 7 Server Advanced on a windows 2003 server with IIS.

I'm only hosting two very small and simple files with IWP and only a handful of users. But, like clockwork, it stops working every few days. Files are still shared just fine but IWP is nowhere to be found.

I've tried just restarting the service but the only thing I've found to work is restarting the server.

This is really a pain. Is there no one out there who knows the answer to this dilema???

Thanks!

[Reed]

I can't speak about server advanced, but ever since I updated to 7v3 of FMP, I haven't had any problems with with IWP. I believe there is an update coming soon for server advanced that is supposed to fix "deafness" issues. Hopefully it also makes IWP work with mozilla browsers too, just like the 7v3 FMP update did.

Dana

[Robert Moran]

I am having the same ******* problem. I sent an sos to filemaker and nada. I am running FM6 rev 3 on OSX 10.38 with a Linksys router. For 2 weeks, everything was cool then I get the 127 number whereupon I can no longer connect to FM7 remotely. This is a big time bug because I have seen other folks having the same problem I am having. Is there any way a fire can be lit under Filemakers ass to resolve this.

I also see this running under Windows 2000. I did the 591 bit and nada. I got rid of FM7 preferences, nada, I get the same Ask message as Mike and question, how do I kill the web process and where is the IWP config file.

FM7 is truly awesome and so is IWP when it works. (Open source andyone?) but reliabilty on IWP is not outstanding. Any help on this would be terrific.

[Robert Moran]

I am having the same ******* problem. I sent an sos to filemaker and nada. I am running FM6 rev 3 on OSX 10.38 with a Linksys router. For 2 weeks, everything was cool then I get the 127 number whereupon I can no longer connect to FM7 remotely. This is a big time bug because I have seen other folks having the same problem I am having. Is there any way a fire can be lit under Filemakers ass to resolve this.

I also see this running under Windows 2000. I did the 591 bit and nada. I got rid of FM7 preferences, nada, I get the same Ask message as Mike and question, how do I kill the web process and where is the IWP config file.

FM7 is truly awesome and so is IWP when it works. (Open source andyone?) but reliabilty on IWP is not outstanding. Any help on this would be terrific.

[Robert Moran]

I am having the same ******* problem. I sent an sos to filemaker and nada. I am running FM6 rev 3 on OSX 10.38 with a Linksys router. For 2 weeks, everything was cool then I get the 127 number whereupon I can no longer connect to FM7 remotely. This is a big time bug because I have seen other folks having the same problem I am having. Is there any way a fire can be lit under Filemakers ass to resolve this.

I also see this running under Windows 2000. I did the 591 bit and nada. I got rid of FM7 preferences, nada, I get the same Ask message as Mike and question, how do I kill the web process and where is the IWP config file.

FM7 is truly awesome and so is IWP when it works. (Open source andyone?) but reliabilty on IWP is not outstanding. Any help on this would be terrific.

[Larry Schroeder]

I'll add my 2 cents to the experiences.

I was a hard core mac guy running many fmp 6 and 6 unlimited on system 9 machines. Where I work the command was given to convert everything and everybody to PC and no more macs.

Soon my fmp servers were not available every morning. I suspect they were flushing the router catches or something like that every night and fmp server 6 would require a restart to again establish themselves to the network.

After converting to windoze 2000 professional machines with all updates they never go off line (unless the power goes down). It seems they are to dumb to know that the network has disappeared, they just wait patiently until the traffic returns (it seems that way).

With Filemaker Server 7 advanced on a Windows 2003 Server with IIS, I am currently running fine as far as staying on the network. I have only taken the system down to add hardware (a 3 drive RAID made of old mac SCSI drives) Some Ram. I must admit this machine is really a pile of junk. It is a pent III running at 700mhz with 500mb ram and a couple of internal drives and the RAID indicated above and a couple of 100bt Network cards (just wanted to see how that would work). The nic cards I have been able to stuff full of about 1% of their capacity. That was a waste...

Anyhow, My only suggestion would be sure both your OS and fmp server and Advance are up to date. You don't run anyother software on the server, or at least check to see if it would help if it was turned off (like virus checkers)

Those of you using IWP with FMP 7 (not server) Isn't there some limitation as to how many TCP/IP users can hit it in a 24 hr period? Like 10?? You wouldn't be hitting that would you??

Anyhow, hope youins can resolve there issues.

[Larry Schroeder]

I'll add my 2 cents to the experiences.

I was a hard core mac guy running many fmp 6 and 6 unlimited on system 9 machines. Where I work the command was given to convert everything and everybody to PC and no more macs.

Soon my fmp servers were not available every morning. I suspect they were flushing the router catches or something like that every night and fmp server 6 would require a restart to again establish themselves to the network.

After converting to windoze 2000 professional machines with all updates they never go off line (unless the power goes down). It seems they are to dumb to know that the network has disappeared, they just wait patiently until the traffic returns (it seems that way).

With Filemaker Server 7 advanced on a Windows 2003 Server with IIS, I am currently running fine as far as staying on the network. I have only taken the system down to add hardware (a 3 drive RAID made of old mac SCSI drives) Some Ram. I must admit this machine is really a pile of junk. It is a pent III running at 700mhz with 500mb ram and a couple of internal drives and the RAID indicated above and a couple of 100bt Network cards (just wanted to see how that would work). The nic cards I have been able to stuff full of about 1% of their capacity. That was a waste...

Anyhow, My only suggestion would be sure both your OS and fmp server and Advance are up to date. You don't run anyother software on the server, or at least check to see if it would help if it was turned off (like virus checkers)

Those of you using IWP with FMP 7 (not server) Isn't there some limitation as to how many TCP/IP users can hit it in a 24 hr period? Like 10?? You wouldn't be hitting that would you??

Anyhow, hope youins can resolve there issues.

[Larry Schroeder]

I'll add my 2 cents to the experiences.

I was a hard core mac guy running many fmp 6 and 6 unlimited on system 9 machines. Where I work the command was given to convert everything and everybody to PC and no more macs.

Soon my fmp servers were not available every morning. I suspect they were flushing the router catches or something like that every night and fmp server 6 would require a restart to again establish themselves to the network.

After converting to windoze 2000 professional machines with all updates they never go off line (unless the power goes down). It seems they are to dumb to know that the network has disappeared, they just wait patiently until the traffic returns (it seems that way).

With Filemaker Server 7 advanced on a Windows 2003 Server with IIS, I am currently running fine as far as staying on the network. I have only taken the system down to add hardware (a 3 drive RAID made of old mac SCSI drives) Some Ram. I must admit this machine is really a pile of junk. It is a pent III running at 700mhz with 500mb ram and a couple of internal drives and the RAID indicated above and a couple of 100bt Network cards (just wanted to see how that would work). The nic cards I have been able to stuff full of about 1% of their capacity. That was a waste...

Anyhow, My only suggestion would be sure both your OS and fmp server and Advance are up to date. You don't run anyother software on the server, or at least check to see if it would help if it was turned off (like virus checkers)

Those of you using IWP with FMP 7 (not server) Isn't there some limitation as to how many TCP/IP users can hit it in a 24 hr period? Like 10?? You wouldn't be hitting that would you??

Anyhow, hope youins can resolve there issues.

[JamieT]

Well, I've installed the v.3 patch for FM Server Advanced and not only has the problem persisted, now the ASP application running on the same server stops working at the same time. I would like to only run FMP on the server but that is not an option at this time. Would running an ASP site on the same server cause this to happen?

Our College would dearly like to finish implimenting an expansive web-database project, but with this problem I am seriously considering ditching FMP altogether in favor of SQL Server or anything that has some shred of reliability.

It's not like this forum to be stumped by such a glaring problem. Surely someone out there knows something?

I will reiterate: Setup: Windows server 2003 with current patches, IIS, FMP Server Advanced v.3.

Problem: IWP stops publishing every 3-4 days, ASP stops working simultaniously but static pages still display. The only way to clear the problem is to restart server.