FileMaker Server v7 - v11

Hi Guys, I need to make a new table & new relationship on my FileMaker Server 12... To do this will I need to take the server offline while I do it? Thanks, Scott

Hi Gang, Needing a bail out ;o) Looking for a Java installer so I can have a compatible version of Java when I install FMS9 for MacOSX 10.5.8 for a client of mine. Any ideas? If you have a copy of an installer, would please send it to me PRIVATELY. Thanks!

Hi. I am running the latest version of Filemaker Pro Server 12. Every few days the server keeps disconnecting clients. The can log back in again but is annoying for them. Then when I try to go and look at the admin tool it says this: HTTP Status 403 - FileMaker Server has encountered an error: Access to the specified resource () has been forbidden. If the Server Launch Page is not available, visit the FileMaker Website for more assistance. The only way to get back into the server admin is to restart the server, disconnecting all the users again! I am running the server on a Mac Mini Server running 10.8.2 Any help appreciated.

Hi Guys, We have our backups set to incremental every 5mins... How many folder should we see for a full day or does it only keep a few?? Just wondering if we have the best backup schedule we can get?? Thanks, Scott

I am new to using FMS, and am trying to set it up on my home PC for testing purposes, etc. I have followed all the instructions on how to install, configure, etc., but not entirely sure how to get it onto the web - so I can remote access it without being on my network. On the LAN, it works fine, but I want to test remote connectivity, etc., - how do I go about doing this? I have read any posts I thought would be appropriate in this matter, but can't find any help! Previously I was hosting solutions using IWP, and had port forwarded my PC, etc. and had it working fine. Do I need to take similar steps here? Thanks!

Hi I Have just installed Filemaker v10.0.3 on a new MacBook pro running 10.8 and found I can see my hosted server but no available hosts. I have other computers accessing the available databases on the network fine but they are running filemaker v9.0.3 and OS 10.5 The FM Server Advanced is version 9.0.2.151 Any ideas

I need to make recovery of the Admin Console Password properly FileMaker Server2011. I assumed management of this server and I would like to avoid deleting the 4configuration file to reset your password. Unfortunately, those who first ran the serverdid not leave the data access. thanks

Hi all, I have a FM Server Advanced 12 Win hosting a large CRM relational database. Since my company recently opened a new unit in a neighboring country I was asked to prepare a clone of the existing CRM for their use. I intend to run both CRM’s on my server and for this purpose I’ve changed the names of all localized database files. But all the rest (relationship names, Tables names, scripts etc.) will remain the same. Does anybody know if doing so I’m risking a possible interference between two CRM’s? Is it possible that by mistake a script from one CRM, even if the files have different names, but the structure of files is exactly the same, ends in the other? Thanks for…

The Filemaker Server 11 Admin Console refuses to show the file "FMServer_Sample.fp7" in its list of databases. If I change the name to let's say "FMServer_Sample_x.fp7" it does show it. Actually, any database that is renamed "FMServer_Sample.fp7"will not show up. How can this be fixed?

I believe I know the answer to this one, but for the benefit of my client, I'll post it anyway.... Uploaded a database to my FMSA 11 test server for him today, and of course, when he went to access it with Filemaker Go, he was able to see all the OTHER files on my test server. "Is there no way to set Filemaker Server up so that Filemaker Go users only see the one file they're supposed to?" Hmmm... I dunno... I only very rudimentarily know how to set it up so that regular Filemaker Network users only see selected files... Thoughts?

We are a summer camp and will be deploying Parent Accounts through IWP and would like to use port 591. The problem is I can't figure out how to configure Filemaker Server to listen on port 591. Port 80 is being used so it makes sense to use the alternate - but how?? The firewall is configured properly to port forward 591. We have no problem accessing the IWP database on the LAN using port 80 (haven't been able to test outside yet - as I stated above port 80 is in use) but when I change the port in the IP address to 591 - http://LAN.ip:591/fmi/iwp/res/iwp_home.html - nothing. I have searched but I can't find where to configure ports in Filemaker Server. H…

Hi people, sorry for being noob but I have one question. I'm working in one small touristic agency and we are using FM10 software of one guy that is designed to put travel reservations in it etc. We paid normaly big price for the app, but every year he is asking for "hosting" about 300euros per year. Is that price real or he is cheating us? Our base isn't much big, about 10.000 names with some small personal info. Regards!

hello, i'd like to know the way to create administrators group with script in fmsa 12... the goal is to provide my user possibility to create user environment infmsa from a php web page to connect fmsa console admin. I didn't find nothing about that may is there another stuuf to do it. Thanks for your help Olivier

Hi all, is it possible to be emailed notification when a user logs in?

OK. I'm just about ready to install fm12 server. I have fm9 server running on an xp system for quite a while. Time for an upgrade. I understand that it needs windows 7 to run. I do not have a windows 7 machine so I have to purchase a new one. I'm asking for help in determing what computer to buy. Here's what I do with fm. We are a school and I have a number of programs written with fm running on the server. However, at most we might have 5-6 people on at a time, usually less. I have 10 licenses for fm12, 1 for advanced and one for server. The progrmas are school type programs, record keeping, etc., not very compute oriented. We also don't have loads of money so I would li…

Hi; In my script Filemaker pro 11 , I used the function : Export records [No dialog; “<output filename>”; Automatically open>] This script is used like a schedule script which running every 20mn from the filemaker server; what I need , is to export records from the DB as an .XLS file than Open this file automatically in the server when I test the script in my descktop , I receive the exported files and it will be " automatically opened" But , on the Server , That can't be open automatically !! what shoud I do please to open exported files automatically in the server ??

We have FMS11 installed in a 2003 server under a local domain. We have installed FMP11 in 50 computers working remotelly from different locations. All of them are connecting fine except a group of 8 Win7 PCs that are connected through a local domain on a Windows 2008 server. They can see the list of Databases but when they want to open any of them it takes at least 30 minutes to just open it. Obviously, the navigation through it is impossible slow. We did connect from a PC out of the domain but in the same network and it worked fine. We are assuming that the problem is somewhere in the domain policies or configuration. According to the local administrator all the required…

We have an online shop selling bento boxes and other random things from Japan. Our current Filemaker server system (running on a custom built PC from an SSD, with backups made to another SSD for speed, then those backups are moved to a hard drive regularly) works exceedingly well and has given us a big speed increase over the old server we were running from. The only speed bottleneck is this: when we bring up a product that has sold a lot, usually 1000-10,000 copies, the calculation that must report the number in stock slows Filemaker down for the user, causing delays of a few seconds while the information is tallied. Some of these are download products so we don't need…

As a TechNet member, I have downloaded the FMSA12 Development License for testing. I tried installing it on a new laptop I purchased for this purpose (8 GB Ram, 1TB disk, 3rd Gen Intel Core-i7-3630). When I started the install I got a "not compatible" message. I continued the install and when finished (no further messages) I didn't have access to the admin console. Has anyone successfully installed FMS12 on Windows 8? Is this a Java problem? Figuring I did something wrong, I uninstalled it and am waiting for some assistance. I have successfully installed FMSA12 on both Windows 2003 and WIndows 2008 servers. The only problem I ran into on the Windows 2003 server wa…

Ok we have always rolled with IWP for a while now and it seems to have become so slow when we have more than 8 users on their so we need to explore alternatives. Everyone I have spoken with has said Deploy with PHP and still use IIS (as we are on a win server 2008 platform) Ok... So I contacted Filemaker and they suggested using the Deployment wizard. So this is what I have done so far; -Removed IWP publishing -Added PHP (Using the Filemaker supported version) -Even though it says PHP is on, the light next to it is red (in the console) -Another issue is when I browse the site we get an IIS error (403- Forbidden) -When I use the "Test PHP Web Publishing" I ge…

Hello, We have a Filemaker server 9 on an Mac Xserve. This is all working fine, but I can't acces the controll panel. I tried googling it and no correct solution for me. This is what I've got: Filemaker Server 9 (fully updated to 9.0.3.325) J2SE 5.0 So when I go to localhost:16000 and I click on the 'start admin console' button, It downloads the a file that starts up the 'FMS9-...' application. I click to allow the certificate, but then I get this error log: java.lang.reflect.InvocationTargetException at sun.reflect.NativeMethodAccesorImpl.invoke0(Native Method) with a lot of error lines. I also tried opening the app on a windows machine (7) with the Java 6 (u…

We upgraded our Windows Server running Windows Server 2003 R2 from FMS11 to 12 and PHP stopped working. All files with a.php extension yield a 404 error. We re-deployed several times. According to KB6538, the deployment wizard... None of those settings appeared: no ISAPI filter, no index.php in Documents tab, no .php mapping, and no Web Service Extension. Yet the deployment log says those changes succeeded. (log below) I did a little work to try to manually change those settings and decided I do not know IIS well enough. I don't know how to overcome this deployment problem, nor does our IT manager. Any ideas? Thanks. Gary Deployment l…

We're receiving 'Admin Server Connection Error: The Admin console cannot establish a connection to the admin server' errors intermittently, after only a few minutes connection; initially we can log into admin console, and use it to open files, but then intermittently this error appears. Thoughts? Running Win7 Pro x64, 4 GB RAM/Intel Quad Core Q6600 @ 2.40 GHz, FM Server 11.0.3.309 Also, I see in log, at 3 min 5 sec intervalks, "Administrator 'fmsadmin' no longer responding; connection closed (192.168.0.21) where 192.168.0.21 = IP address of FMServer Then 7 sec after I see 'Administrator connection; "fmsadmin [192.168.0.21] (fmsadminserver)." I'm n…

FMP has two new DLLs that will fix the issue where clients disconnect yet FMP still sees them logged on and that causes FMS to go unresponsive. DBEngine.dll and EngineMGR.dll have been updated. Im sure if you contact FMP they can give you access to the fix

Is there a way to structure script steps to tell the server to preform steps rather then the client. Specifically, I am exporting XML, but this script step runs from the client machine. The code that comes out of filemaker is... 1. Not human readable due to bad formatting 2. Has bad chars that are not recognized by the automated system that will receive the files 3. Needs to be exported to a different server for automated operations. I currently have the XML being exported to a 3rd mac server which opens the XML file in TextWrangler and cleans to human readable and removes bad chars and XML definitions that the next system does not like. Then…

Wondering about experiences developing with server running on same pc as fm pro when developing. Filmaker help says server not designed for this, but it seems to work fine for me. Doing a seperation model with ui in fm pro and four files running on server. Get share warning at ui startup but all works fine. Any one have opinion pro or con of this setup for developing only, not for final end use. If this is not optimum what are your suggestions for sep model development. I started with fmpro adv 12 with ui file and four shared files. Then after putting on server had to re - reference 50 tos in the ui. Cant find a best practices doc from filemaker on the development…

Our old Power PC server crashed, so I installed fms9 on a 10.6 Intel box, and copied the Data folder over. At startup Admin server console wouldn't start. I checked the forums ansd followed advice to clear Java cache. That worked. Sort of. Now the conswole tries to start up but says "Database server not running." Found the same issue in the forums for FMS10. As in that case, the server *is* running and clients can open databases. As the old poster said, "For a server that's not running it gives a good impression of one that is." One solutiion offered was that there might be two versions of Filoemaker Server running. The previous poster killed one ansd said the proble…

so I am ready for an upgrade. I have FMS 9 on a 5 yr old Dell Vostro. Operating System: Windows XP Home Edition (5.1, Build 2600) Service Pack 3 System Manufacturer: Dell Inc. System Model: Vostro 200 Processor: Intel® Pentium® Dual CPU E2140 @ 1.60GHz (2 CPUs) Memory: 2038MB RAM HD: Western Digital WD800JD 80GB 7200 RPM yes, I am ready for an upgrade (please dont shoot me). The machine has been running 24/7 for 5 years! my solution is 11 tables, largest of which is 70,000 records. I also run Supercontainer for scanned images. the scanned images are stored on the HD too. total # of users 6. I have been very pleased with performance. …

When the FMSA ver10.0 starts running scheduled script, it always seems to be failing. The system log says "Scripting Error 100 (FileName) Perform Find" What it's doing in that script is, 1.Perform Find to search for "0" of the flag field in the table of the another file, which is related to the current table. 2.If there's any records found, it starts getting data from the table of the another file related, and change the flag field to "1" as finished. 3.It keeps doing above from the beginning record to the end. This is all I wanna do. If anyone knows how to solve, please help me.

FM have issued a list of minimum and recommended specs for FM12 http://www.filemaker.co.uk/products/filemaker-server/server-12-specifications.html They show the recommended RAM and HDD space for each supported Operating System - my question is, does it make a difference which OS we use ? ie does it make any difference if we use Windows 7, or 2003 or 2008 ? Or 32 bit vs 64 bit ? FM just says they are all supported, but does not seem to say if one is better than another. Am I wrong in thinking that a server that is hosting databases that are larger or busier or have more users might run better on one OS vs another ? Or does it really not matter which …

Ok to install? I think Im on 33 at the moment.

Good morning. I have just had a client install FMS 12 on a new Server 2008 R2 server, and whilst I didn't witness the installation process, I was advised that it went fine. The problem I do have is that no icons were created so I am unable to run the FMS Admin tool. Can anybody please advise what icon I can create manually, or as no icon was created, what other problems I am likely to encounter? Thanks, Greg

I'm wondering whether anyone can help, I run a filemaker 8.0v4 advanced server on a G5 running 10.3.9, and the hard disk went pop. I thought I had all the disks to re-install the software, but I am missing the 'web publishing engine' installer (which was on a separate CD). I contacted filemaker and they were unable to supply the software, as it was obsolete. I was wondering whether anyone had access to this software? I have everything else running fine again, I just need can't install the WPE. Thank you in advance. Kieron

The latest Java updater causes issues with the FileMaker Server Admin Console on OS X 10.7 and 10.8. Please see http://thefmkb.com/11251 for additional information. Steven This post has been promoted to an article

I have made many years ago a file converted now in Fm 12. I need now a simple version of Fm 12 , just to enter new records and have them on iCloud with fm Go 12 in iPad Thus, I do not want to buy servers etc, but just a simple file for entering information Is it possible and what is the name of this simple version ?

Dear All, I am working on executing a script through FileMaker Server, But I am getting the error number 101, But when I am executing the same script using only FileMaker application, it is working and executing up to the mark. This is the first time, when I am trying to execute a script from FileMaker Server. Please help me on this. Am I missing something over there. Please suggest me the right way. There is an attached screenshot of script.

Hi all, I'm having some trouble getting a server-side script to properly execute on FileMaker Server 12 on 10.6.8. I have a DSN setup on the server to an SQL database and the FM database works fine when run through FileMaker Pro on the server machine, the scripts run fine too, so this tells me that there is no driver issues when running via FileMaker Pro. However when FileMaker Server on the same machine runs the script, I receive an error in the logs at each of the import record script steps where it is trying to import data to the external sql source. My google research doesn't give much of a hint but if I had to guess it is something to do with driv…

Hi All, I was wondering if there was some php scripting i can ue to directly login to our database instead of going through fmp then the database so we only have one login as a index.php page. Thank you Alex

I tried to search the forum but didn't see anything on this. Have the underlying problems in the DB engine been corrected? Is it necessary to recover files every few months with FMS12 to improve speed or deal with corrupted records? It appears there is still no provision for command line recovery or control. I've read through the specs and a few reviews but they did not seem to address these issues.

Hi friends, Filemaker Server 12 in the Instant Web Publishing in a database running. This database is a catalog of a product. A product in this catalog at the time of the search in a search engine like google, what can I do to find our database. Thank you.

So I'm planning my next server "step-up" configuration and I want to do the recommended 1+0. I plan on using Mac Pro Servers but I'm not sure which way to go on the RAID setup. http://store.apple.com/us/product/MB845Z/A/mac-pro-raid-card or http://www.promise.com/storage/raid_series.aspx?m=192&region=en-global&rsn1=40&rsn3=47 So which one should I use? Can I use the pegasus as the system disk as well and not even use the internals?

I purchased a new machine for FMS12 - 2 remote people could not access the file the other 4 could could. Installed FMS11 and plan to stay there. Seaver was on FMS10 working great. I want to make some changes to the database compact it - save as compacted - and cannot find the file anywhere on the server. I used the upload feature - file name was 4specs_db.fp7 and there was a 4specs_db2.fp7 in the normal database space. It is still there and not available to the server admin screen. The original 4specs_db.fp7 file is still where it was. 4specs_db.fp7 shows up in the server admin dabatase screen. I changed the comments field dark red to be sure whic…

Hi, every one, I install Filemaker Server 12 on windows server 2008 r2 service pack 1, when my client connect to database from remote, after 1 minute disconnect from database. Can tell my why this happend? Thank you.

We have a script that will pull records of a find and then export them to an .xlsx file on the FileMaker server. Cannot find a way to then email that file via SMTP from the server in a script step using a server-side schedule. Script below: Perform Find (Restore) Set Variable [$path; Value: "filemac:" & Get (DocumentsPath) & "export.xlsx"] Export Records {No dialog; "$path"; Unicode (UTF-16)] Show all records This script successfully exports the found records to the default store on the server, now how to email this as an attachment?

Multiple servers/licenses? I remember seeing something about using a third party (syncdeck or something) to achieve this in 2010. Better ways to do this with FMSA12?

Hi, I see in the FMI site that the recommended Windows operating systems for installing FMS12 are: - Windows Server 2008 Standard Edition SP2 * (64-bit) - Windows Server 2008 R2 SP1 * (64-bit) Is there any difference in terms of performance of using either of them? which one would you go for? thanks in advance!

Hi there, We have an FMSA11 server running on Windows 2008 64 R2 in a datacenter ( HP Proliant Intel Quad Xeon / 4GB / 1TB Raid Disks ). We serve an IWP and Filemaker Go solution to education clients across the UK. Normal server loads are fairly light with around 10 - 30 concurrent users, all accessing the same database to upload images from filemaker go (current file size is around 800MB which is mostly pictures) and from IWP to view and evaluate the uploaded images and comments. Just the last two days, the server seems to be stopping serving requests, clients are experiencing some or all of the following issues: - - Cannot upload images to container…

Does anyone know if it is possible to convert a fp7 database to fmp12, then to a stand alone run time and have it access the original database in fp7 format hosted on FMP 10 Server? We currently have FMP10 Server and about 20 machines with a standard FMP10 client installed. We've purchased FMP12 Server and a few client licenses but are trying to avoid upgrading ALL the clients if the run time solutions can be used to access either server. We would prefer if they could access the FMP 10 server, at least for now until the migration is complete. If it is possible, do you have to change the table::field reference for every field in every table to the remote DB? Or i…

It's great I can run run system-level scripts through FMS. There is an option to include parameters, but I've never used that. How would a shell script access those parameters? A quick look at Unix scripting makes me think that if I pass parameters as... ABC 321 "blue dog" ...then I can reference those parameters as $0 $1 and $2. so: echo "i like the $2" would return i like the blue dog Is that the correct method for handling system-level script parameters? Thanks, DJ

To start a program that's on my FMServer 9 from an icon on my workstation I enter fmp7://ip address/filename.FP7. What would I do to get to start a file on my FMserver 12?

Hi. I'm finally moving up to getting the server12 up and running. The problem I currently have is getting to the admin console from my workstation. On my server 9 I go to the IP address with a :16000 after it and it works fine. When I try the server12 IP address with :16000 I just get connection problems. Any help on that?

Occasionally SMTP mail fails on server for no known reason. To fix it, we send out a mail from an email client, it goes through and then server resumes sending out mail without errors. No settings are ever changed. At one point we thought that a certain character in the email body might be causing an issue but we have never been able to pinpoint what it is or if that is actually what is happening. HELP!!!!

Good afternoon. I've just purchased two high end HP servers with the intent of migrating from FM11, which ran on two ancient Windows 2003 servers, to these two and FM12 (server Advanced). I brought the servers (both obviously 64bit) online over this last weekend, installed FM12, and everything seemed good. The installation of the "Production" server on the first one has performed flawlessly. "Production" in this case means that only the Database server is running. The other server, our "WEB" server, has been a horrible disappointment. In brief, neither the IWP test nor the CWP test in the technology test page works properly, and installing mySQL …

Upgraded from FMSAdv11 yesterday to FMSAdv12, to try to relieve pressure on a Win2011server where my install of FMSAdv12 is a disaster. Things went a LITTLE better than most of the installs of ServerAdv12 that I've done to date, and IWP actually works in the 2003 install. There was nothing in that final listing to indicate anything failed, but when I tested CWP from the Tech Tests page it returned a "The page cannot be found" and a bunch of gibberish at the bottom. When I tried to test things on a real live site, I simply received a "cannot read page" message. This is a server that has worked as our web server for years, on implementations of Server versio…

Hi there.... what I thought should be a fairly simple thing is apparently not... am I missing something... The plug in is web assistant by 360 works.. confirmed to work on fm server 12 Plug in is in the extensions folder Server has been restarted... Tick boxes in the server plug ins tab have been ticked and un ticked and ticked again! The plug in doesnt show up in the list "Choose the plug in for FMSE to use" Am i missing something here?

I've had no success trying to get mySQL Connector 5.1.1 Community Edition to work with my installation of FMServerADV12. In Windows Server 2011 (64bit) the 64 bit connector will allow entry/configuration of DSNs, but as soon as s/o attempts to USE a database in which they're involved, the database server (only) crashes. In the same server, using a 32-bit connector also allows entry/configuration of DSNs, but in THAT case, we get the dreaded "Architecture Mismatch Error". In an upgrade of a 2003 Server (32-bit) we'd hoped to get rid of, the 32-bit installation of FMSAdv12, the 32-bit connector installs fine and allows entry/config of DSNs, but as with the 64…

Hi, My team had been successfully accessing our database via FileMaker Pro and Go for a while from our office and from our home. Today a colleague of mine tried accessing the database from another wifi network outside of our office and homes but failed. Is there some way I can rectify this? The database in question is deployed with FileMaker Server 12 Advanced on a server computer in our organisation. We've been accessing it with FileMaker Pro and Go (both with iPads and iPhones) for a couple of months now without problem. We've only ever accessed it when we're in the office, or at home. My teammates are having a meeting elsewhere today and got the message …

hello I have this strange problem, I am using FMS12 trial and i was able to connect to it but now I've came back two days later and it has stopped working, I am able to start it up, then it says everything is functioning but when try to connect with my iPad there is no files available... Is there something i can do to fix this??? thanks in advance for all of the help, jafacakes2011.

Hi everyone, I've transferred across a database to my FileMaker Server which was previous being hosted by another company. Most users connecting via a custom php IWP login page uisng a sub-domain of my site. However some users, including me when I use my office PC, type in that URL and still get the old login page from when it was hosted with the other company. They simply cannot load the new database as its moved location. I have successfully changed the DNS settings on the subdomain and have contacted my hosting company (1&1) to verify this. To access the custom IWP login page I’ve tried: Flushing my office PC’s DNS (cmd > ipconfig /flushdns) Del…

Hi All - I have a scary issue at one of my clients. FileMaker Server 11.0.3.309 installed on a Windows Server 2008 R2 Standard 64-bit server with 32GB RAM. The problem is that FMS Admins Console will only allow me to set the Cache Flush distribution interval to 22:00. Any time I try to change it, it simply reverts back to 22:00. This is a scary thing as a LOT of data can entered in 22 hours and lost if it's not flushed to disk. The cache size was set to 500MB. I set it now to 40MB to minimize potential loss. Does anyone have any idea what I can do about this? Is reinstalling FMS my best bet?

I have a script sequence running in an FMS11 hosting environment. The script successfully finishes and logs its times. The server has now ghosts users with (?) logged into the DB and they cannot even disconnect them, the server has to be restarted to get rid of them. Has anyone seen this before? Thanks, Agi

New 12.0v2 update for FileMaker Server was just released. Here here for list of fixes. http://help.filemaker.com/app/answers/detail/a_id/11044

Hey all, Diving deeper into FM than I have before and had a question or two about a database I am hosting. It's a simple word order / dispatch solution and I'm currently using a 30 day trial at triple8 dot net to host it. Tried to search a little for the answer, but am not even sure at this point what to search for. I have 5 layouts in my DB that are designed for use on an iPhone. Is there a way to set it so that it always opens to a certain layout whenever someone logs in? In this instance, I have one I call "Home". I'd like to go to that page automatically upon loginng into the DB. Also, is there a way to adjust the auto logout with FM Go? I've noti…

Has anyone ran into this issue? I have a field that counts the # of records in a related portal of which I perform a "find" on. This has worked for over 3 years. Just last Friday, it stopped working. (I usually do a find, * in the field, and it will return the result. However, it is returning 0 records found which obviously is incorrect since there's a # in the field. I tried to recreate the field and relationship and it still returns 0 records. I made a copy of the database on my desktop and performed the same find and it worked as intended. I'm quite puzzled and have no idea how to fix this except restart the server. I don't see any issues with the server (i…

Hi All, I'm running into a problem installing FMS12 web publishing on Windows 2008 R2 Standard. FMS12 is installed but without web publishing, I'm trying to add the web publishing by running the deployment wizard from the admin console. IIS7 is installed and running. Default web site is running, it has ID #1, I can see the IIS7 start page in my browser. Anonymous authentication is enabled, all other authentication is disabled. Anonymous is default, has the iUSR set up and that account exists. When I get to the point in the FMS deplpyment wizard where it connects to IIS I get the following error: "Test web server (http://xx.xx.xx.xx:80/fmi-test/test…

1) Can a User activate a scheduled script? I read somewhere that Wim said we could use HTML but it was some twitter feed - there then gone and hours of research has not returned it to me. A link or example would be awesome if it's possible. 2) If scheduled script sets a global field (in a file it is serving) is that global value retained just as though it were manually set off line? 3) Are scheduled scripts always client? Do they always follow same rules as a User or are there exceptions where scheduled script would behave/evaluate differently (scripting, calculations, globals), possibly from different perspective? 4) If a scheduled script (as Client) h…

We are currently setting up with an offsite disaster reocovery backup service and I am having some trouble figuring out the best way to include our Filemaker database. First off I am well aware that the offsite backup should not touch the live database. It will obviously be setup to pull a backup copy. The offsite does incrimental backup so it only pulls data that has changed from day to day. Our database is 17 gigs and growing. So due to the cost I would like to be able to take advantage of the incrimental capabilities of the offsite backup and I only want to backup the latest database backup. I setup a seperate filemaker backup schedule to only keep 1 day, but…

Is it possible to have FM Server run a backup from a client script? This awesome thread seems to indicate that schedules can NOT be run on the Server from Pro (though scripts can). That would have been a nice solution. I'm wondering if there's another way to do it. I don't want to run a schedule every 5 minutes, checking a flag field, I need the backup to happen "on demand". I'd prefer a solution that was cross-platform or maybe two solutions one for Jobs and one for Gates. This is for FMSA 12 on OS X Server and FMS 12 on Windows 2008. Thanks, DJ

Just found this by Wim Decorte: What you have in mind won't work with just the native features of FM12: when you host a file, the path to its container data is always a subfolder of the folder where the FM file itself is. This answers my question below, but I will leave it here in the event someone else needs the answer. I think this may be a Server question so I will post it here. We purchased FMA12 and were super excited about the ability to store images outside the database. We put in a 3tb hd and called it Z: in my work station. We had our container images going to Z: and all was grand as the db was remaining small in size. We decided to g…

I've got FMSA11.02 installed on a Windows Server 2008 R2 64 bit machine. 8 gigs of RAM, which all is dedicated to the database cache. Everything appears to be running fine. When the database server isn't running, memory usage is at about 11%. When I first start the Database server and all files are opened, the system is using about 19% memory. As soon as a FMS scheduled backup starts, that's when all hell breaks loose. The memory usage jumps up to around 80%. Even after the backup completed, the usage stays constant at 80% or higher, which is what is bothering me. It doesn't matter if there are users on the system at the time or not - the available memory is dr…

On FM Server 11, there was a issue with Java. We solved this issue but uninstalling and reinstalling Java. Now on a new version of 12, we updated Java and now we cannot get into the Server Start Page. Tried the same thing that worked for 11, but apparently there is more wrong. Anytime you double click on the Start Up it says "The shortcut for javaws.exe is missing, would you like to remove it?" I don't know if I want to or not. If you open the "Start Page" that is in the Start > All Programs > Filemaker Server 12, it gives our information and says that you need to install "Java 6 or newer." We've done that, and even manually installed JavaFX, but still nothing.…

Look at the provided screenshot, what does this status mean? Thx Lars

We are trying to improve the performance of our Filemaker WAN performance and have identified several ways we might do this. Namely, • move the interface file to an FM server at the remote site • faster hardware • the design of the db itself • upgrade the FM server software to v12 (currently v10) • invest in a faster WAN So that we can measure the effects of these changes, our developer has written a simple latency measurement script into our main DB. The results so far are interesting, but I don't understand the difference between the read and write performance. The script writes some text into multiple fields, then reads it back, then cleans up. …

If a field is referenced in an unstored calc from another table is just that result sent down the pipe or is the whole record from that other table cached and then the result is parsed on the client side?

I just installed Filemaker server 12 on my Windows 7 ulimate OS computer. When the start page goes through its startup it stops with an error to update JAVA. I have uninstalled all JAVA, upgraded, rebooted and still have the same problem. I see there is a sticky about JAVA but it addresses Server 11. Does anyone have any idea? I cannot even see if I like the server yet I am having problems before I can even start it. Please advise. Thank you.

hi, we are seeing this error pop up in our logs. We aren't sure what it means nor how to fix - or even how serious it is (although we note it's an error, not a warning or information). Please let me know what you'd do if you saw this error. Thanks!

Hi gang, Trying to access Server Admin Console. FMS11v2 is installed on an iMac running Mac OS 10.7.4 with Java SE 6 (32-bit and 64-bit, both versions 1.6.0-b03-424) When I run localhost:16000 from a web browser, the first error I get is: The Database Server is not available. To edit server deployment, please start the Database Server first. Then I hit the Restart button. THen I get this error: Unable to start the database server. Please contact your system administrator for assistance. Anyone out there gracious enough to step me through getting this server installed properly and configured so I can access the Sever Admin Panel successfully. …

Hi, Got a problem with establishing ODBC connection on relations: my local PC to the file on remote server. "Failed to connect to listener[2]" is the error which I got out of ODBC FileMaker DSN configuration manager while testing connection. I did use manual and advices from this link: http://help.filemake...kw/xdbc drivers Few possible reasons: 1.) In FileMaker ServerDatabase ServerExtensions folder I'm missing xDBC.fmplugin. I was digging the web to find xDBC.fmplugin plugin but couldnt get it. Does anyone know where I can download xDBC.fmplugin? 2.) In official JDBC/ODBC filemake…

Hello , i like to know to create a server script that send emails to people that havent complete the delegate task? i had already setup SMTP email , and works well , but im stock in writing the script since filemaker server does not let to save as pdf on the server . thank you

Any chance I can run an FMS script after a backup schedule runs? I know there's options to run FMS scripts and system scripts in conjunction, but not with a backup schedule. I could just schedule the script to run on the same interval as the backup plus one or two minutes, but that feels inelegant.

Okay from the top. My client has a WebServer (-A-) linked to a FM Dbase Server (-B-) (v8.5). A and B are standing in a less secure Zone. My client also has a second FM Server (-P-) (v11.3) standing in a highly protected zone with so many firewalls around it that you would be pushed not to easily trip over one. Now. I need to transfer some records from a table in an FM file on (-P-) into a similar table in an FM File on (-B-) once a night, so that they can be published on the Web. Due to internal politics I cannot access the FM Server (-P-) directly from (-A-) (nor would I really wanto). The FM files on both Servers (-B-) and (-P-) have the same field…

We are running FMS 11 Server advanced and also run a 'robot' FMP 11 Client on a separate computer on the network, whose job is to assemble a certain data set overnight from databases on the Filemaker server - this dataset is used for personnel scheduling. A Planning database on the server references the robot's scheduling data and updates it's own dataset. The script in the Planning database that runs the update calls several scripts in the robot client. This script works correctly when run locally from a client. We set up a schedule on the server to run the update script in the Planning database but it does not appear to work. Using the 'Show Compatibility' bo…

The question has come up if Filemaker updates can be deployed by the server or if each client needs to download and install updates individually.

Fm server 11 advanced I have a script that runs everyday to email an invoice to a customer, these invoices are located on the domain server. which is \\server2003\lan\ and is mapped as the F drive. when I run the script locally it works fine, when run by the server it does not include the attachment. I tried the following filewin://server2002/lan/invoice/123456.pdf filewin:/server2002/lan/invoice/123456.pdf filewin://F:/invoice/123456.pdf filewin:/F:/invoice/123456.pdf I can not figure out why the server can not find and attach the file... it does send the email just without the attachment...

In the first few hours after deployment of FM Server Advanced 12, IWP crashed abnormally six times and counting. The served database, accessed by dozens of users, has been working perfectly on FM Server Advanced 11 for months. This weekend we upgraded to 12 and this Monday morning it is HAVOC. The alerts say: "2012-07-23 09:58:43.343 -0400 Error 701 [company server name] Instant Web Publishing process has terminated abnormally." When this happens, looking at the console, the Web Server icon is on Red. Clicking on Green seems to fix it, as does restarting the service. But after a few minutes here we go again. The logs do not show any specific action that …

Hi, We are using FM11 clients (8) and FM server under W2003 server. On the same server is also running a print server. When printing a report a. the set-up screen for the printer reacts very slow b. after confirmation, FM11 is very busy to spool the report Someone know any tips? greetings, Jan.

I am using Filemaker 11 with Filemaker Server 11. We have a mix of Windows 7 and Windows XP computers. For this situation it happens on Windows 7 computers. I have been having problems starting Filemaker . It shows the splash screen and at the bottom of the screen is usually flashes through all the fonts or items being loaded. Recently on my co=workers computers, it has been stopping at "AutoUPdate". It refuses to go further. after half hour still at Auto Update. I have to use Task Manager to end the process. I have logged off that person and logged on as a different user. Filemaker starts up fine! therefore something wrong with that user's profile(?). …

I can't seem to find an answer to this so it must be a really stupid question. Can I hot a FMpro 11 file on FMS12?

I am having a problem accessing the admin tool on my servers. Server Version: 11.0.3.309 OS: Windows Server 2003 R2, Standard edition, Service Pack 2 Java: both version 6 update 24 and version 6 update 33 are installed and update 33 is the active version. I get the same error whether trying to run the admin tool from a client machine or on the server itself: Error: Unsigned application requesting unrestricted access to system Unsigned resource: http ://[redacted]:16000/admin-client-lib/admin-console-client.jar JNLPException[category: Security Error : Exception: null : LaunchDesc: at com.sun.javaws.LaunchDownload.checkSignedResource…

Hello all -- I have 1 external IP Address ... currently port 5003 is being forwarded to FMServer 11 (on 5003) and this works fine. I just set up a FMServer 12 on a different Server and I would like to make this visible to the outside as well. With my external router, I can easily map external port 5004 to the 5003 port to the FMServer 12. It seems that the FM Client has some issues with aiming at a different port (or at least the ways that I have tried... fmnet:/77.77.77.77:5004/sandbox.fp7 ). Any suggestions ? Thanks in advance, --Rich

Hi: I have heard that a SSD improves server performance for Remote Access. Not in my tests, speeds are nearly identical, Access through Internet done using my alternate internet provider service. Clone copies of everything, only 1 server connected at a time to router for testing. Software: Server 11 Win + FMPro10 Mac Server 1: Intel Core i3 M350 @ 2.27Ghz - 2.27 Ghz 4 GB RAM (2.86 usable) 32 bit Win 7 Ultimate (fresh install) Crucial SSD Server 2: Intel Core i3 M350 @ 2.27Ghz - 2.27 Ghz 3 GB RAM (2.74 usable) 32 bit Win 7 Professional (factory install) 5400 RMP normal HDD Sort all records in order control database HDD 13 sec, SSD 12…

Firstly apologies if this has already been covered (I'm sure it has but I'll be damned if I can find it!). What is the easiest and cleanest way of initiating a backup of a FileMaker Server based database from FileMaker Pro. I just want the user to be able to click a button on a layout which then backups the files, preferably without using plug-ins. I know I could do this through an event or vb script or bak file perhaps with a timer etc. but is there a cleaner way of initiating this through FileMaker Pro. Cheers in advance.

I'm not even sure where to ask this or how. Never had anything like this before. I put together a new workstation. FM 9 is installed like all the other ones. I go to open remote files. I get the host name, but no files to open. I didn't do anything different with this machine than the other ones. No messages, just doesn't do the usual file listing of files to open on the host. Any ideas? Mike

Hi, FMS 11v3 on a Windows 2008 R2 64 bit Server and Fm 11v3 on Windows 7 I have written a simple script that imports data from my SQL Server into a Filemaker table. The script is one script step long (Import records). Locally, on my Client PC it works great; when the Filemaker file is on my Client PC, the import script step executes a simple SQL Query and imports the found stuff into my table. Now I move the Filemaker file to my Filemaker Server. When I execute the script there (I want this script to execute once a night Server side) I get an Error 802 (Could not open File.) Any ideas why? I have set up the System DSN on the Se…

In our FileMaker 11 solution, I created a script to update totals in a table. Rather than have that script manually-invoked by a user, I decided to have the FileMaker Server Advanced run the script every 2 minutes. The script is not really complex: The script options on the server are a 1-minute time limit set to abort schedule if time limit is reached or the server is stopped. What is occurring at least one or more times throughout the day, is that the totals stop updating. A review in the Admin Console shows that the script's last completion was more than 2 minutes ago, and it's status is "Running". Without restarting the server, I have to delete the …

Hi Our client has a firm policy that the system partition is backed up once a week in snapshot mode, and that C:Program File** is read only. FMSA 11 places its databases, scripts etc. under C:Program Files (x86)FileMakerFileMaker ServerData. To get the databases backed up daily, and to be compliant with windows server policies, we mounted the D: partitition under the path above. Is there another way to get the databases off the program files directory? Peter

We are planning to migrate to Filemaker 12 in the following weeks. FMS 11 is already running on a mac mini server which is working well. That's its only task. Lately we purchase a real server from HP with fast 15krpm HDDs (raid-5), dual CPU, plenty of memory, etc. The server is used as a virtual host using Hyper-V. We have a couple questions : Will it be faster to serve Filemaker from the new server or leave it on the mac mini? Can FM server run on SBS 2008? We will virtualize the OS. [*]Is it better to run on SBS or Windows 7 Pro? It won't run any service except Filemaker Server [*]If we keep the Mac Mini, how can we make it faster? Change the …

Since about a week ago, we noticed that after a routine server restart that the previous radio button enabling External Authentication is now always disabled and must be re-enabled. Is there a plist or preference file that may be damaged, and if so, which file(s) should I yank (and where would they be located)? We have also been experiencing "communication was lost to the host…" errors, which affects all connected users, connected via the WAN from any location (Austin, Sacramento, VPN). Maybe it is related, since it never seemed to occur previously? Thanks in advance, - - Scott

Howdy, First, this solution works as a stand-alone file on my desktop. Yet, when I upload it to the server it does not. I have a container field that holds a PDF. I have a layout with the container field on it. When I open the layout FileMaker churns for 30+ seconds then comes back with a message in the container field "This program cannot display the webpage." I know the PDF is on the server because I can "export field contents" to a file on my desktop and view it. This isn't a work-around because the solution is server hosted and PC environment variables (%username% or %userprofile%) don't seem to work in a script step. Therefore, I can't create a temporary fi…

Hi All I posted this on TechNet, but want to try you guys as well. We have a very busy production server running FMSA9 on Windows Server 2003 (yeah, go tell it to our IT department) and twice this week users have lost the ability to acquire the server. What we see is this: Users with no files open on the server cannot see the server. Users with any file open on the server can see all the files on the server. Users with any file open on the server can work as normal. Admin can run the console remotely (but a bit slow). Admin can RDC into the server normally. Rebooting the server solves the problem, but this is happening during the mi…