Search the Community

Good morning all, We are currently running FMS12 hosted on a Windows Server 2003. All clients are also windows users and are running FM12. Everything has been fine, then yesterday, due to an internal office move, we had to move the server to a new room. Everything was closed down properly and restarted correctly. However, the server is no longer showing in the Open Remote dialogue. Opening the file via 'Open Recent' works fine and the files open fine. I initally did a re-boot of the server and this corrected the issues and the Open Remote wokred last night, but this morning it is back to having an empty 'Open Remote' list. The server IP address and name has remained constant. Any suggestions?

For nearly 8 months, the company I work for has been experiencing very frustrating issues with xDBC Listener on FileMaker Server 12. We migrated to FileMaker Server 13 last week and we're seeing the same issues.  Both FMS12 and FMS13 have been installed on (separate) virtual machines, both running Windows Server 2008 R2 Standard (Dual-core, 16GB RAM, hosted DBs and backups live on secondary drives). ODBC connections hitting database files hosted on these servers are aborted anywhere from once to four times a day, but not always every day (it may go several days between abortions). The error reported on the server when the ODBC disconnections occur is "xDBC Listener process has terminated abnormally".  I have reported this problem to FMI and am in routine contact with their top-level support regarding this issue. They understand how important it is to fix this problem, but after nearly 8 months of troubleshooting with FMI, we are still having the same headaches.  I'm just wondering, am I the only one experiencing issues with xDBC Listener? I've searched the forum and found a few older posts semi-related, so I apologize if this is a duplicate post in any way.  Here's a screenshot of the xDBC Listener's affect on processor performance: What you don't see in the image is the CPU consumption for the listener alone is 55%. Once the ODBC connections drop off, CPU usage drops off to a normal state (<30% total).  My suspicion is that xDBC Listener.exe is simply the problem child of the FMS software. It's either the Listener, or possibly the ODBC driver that's at the root of the problem. Either way, I'm hoping this will be resolved soon. Without a reliable way for external systems to access data, it's hard to argue in favor of the FIleMaker platform is a viable enterprise-level solution for data management.

Hi all, I'm new here so I hope I get everything right. I've done a search already, but I can not find my issue listed. Sorry if it's been covered before. OK, here goes..... VMWare Server running on HP Prolient G7 tin 2 Virtual Cores 4Gb RAM Windows Server 2012 R2 DataCenter x64 IIS v8.5 (Default for 2012 R2) FileMaker Server 12 FileMaker Pro 12 Advanced with Bonjour JRE v7 This is a brand new build specificity for this use. I've installed FileMaker Server 12 on to the above setup with Custom Web Publishing using PHP I followed the deployment wizard and deployed for a single machine setup. I allowed FMS to install the provided version of PHP with it's own configuration. There is NO SSL configuration on the server at present. The admin console shows three green ticks to indicate that everything is happy. However, when I run the PHP Custom Web Publishing Test, I get the page displayed correctly, (PHP is working) and it identifies the name of the server, but below the main information box, I get the following error message: The PHP connection to the FMServer_Sample database failed. The PHP test was not able to communicate with the Web Publishing Engine. Make sure you have PHP publishing enabled and the database has the fmphp extended privilege enabled. (Error 22; Unknown error) The sample database is installed and it is listed in the admin console, status, normal and dots across the line. I can't imagine that it wasn't installed with the correct Extended Privileges for CWP and I would not be 100% confident to know what I should check for. I am viewing the CWP Test webpage on both the server and a client and getting the same error message. Can anyone suggest any further areas that I should be looking at? Cheers in advance, Barry.

Hi, I've Googled and read, but given the "Preserve external container storage” option available now in in 13.v2, it seemed many recommended protocols were outdated. The setup: Separation Model both UI and data, hosted with FMS12. Replacing both files time.FMS12 (yep, still not updated to FMS13 - working with IT to do so)Clients are FM13Migration script (imports) written and ready to go.So, can someone please list the steps needed to replace a file on a FMS12 that has secure external containers? Should I have FMS13v2 installed on the FMS12 box and run the migration locally (via Teamviewer)? I usually copy off a backup to DropBox and do the updates on my iMac and then rehost. Is this still possible without breaking links? -Barbara

Hi, I'd like to sort records using value lists as well as text fields. My FirstName field works (try Steve) but I'm at a loss on how to make the valuelist sort records correctly. I want to search records from CA in my State valuelist. Here's a link and the php code. Thanks All! http://ssvtennis.com/valuelistsort.php valuelistsort.php

I have lots of searchs that may return 'no records'. Is there coding that will not kill other php requests on the same page? Can I make an If statement that will search my db for a count of records before a result is executed: something like if ($_Get Count($field == 1) my field is 'lafall1'. it is a tennis tournament. when someone clicks 'yes' for lafall1, it returns the number '1'. this way, when someone plays 'lafall1', lafall2 and la fall3', a calculation field returns that 3 tournaments have been played. If no one has clicked 'yes' for 'lafall1', the query will return an error: no records match this request. It stops the script and the coding on the rest of my page dies. Here is a snippet of my code. Thanks! <?php $RandyFind = $fm->newFindCommand('mylayout'); $RandyFind->addFindCriterion('lafall1', '1'); $RandyFind->addSortRule('ssvm', 1, FILEMAKER_SORT_DESCEND); $RandyFind->setRange(0,500); $result = $RandyFind->execute(); if (FileMaker::isError($result)) { echo($result->getMessage()); exit; } ?> <?php $found = $result->getFoundSetCount(); if($found == 0) { $record_count = ''; } elseif($found >= 2) { $record_count = '(' . $found . ' players)'; } echo $record_count;?>

Hi, I'd like my New Record.php to advance to an Edit.php upon clicking submit on the New Record form. I don't want to remain on the New Record.php, but doing otherwise gives me a 'no record created' message. Here's an example of my New Record.php Thanks! newinputplayer.php

LS, I am trying to enable Web Publishing tool in FileMaker Server 12.05 on a Windows 7 x64 with Java 7 (update 75) and IIS running (World Wide Web Publishing Service running normally) . but I am facing this wired error which I can't get rid of. Tried a lot of things I saw on the internet without any luck. I have attached a snap of the error as well. Any tips or ideas are highly appreciated it.

Hi, I was successful in creating records with drop down valuelists from my db, now I'd like an edit form on a new page to show those values and edit them. I only see the unedited drop down lists in the edit form. Here is some code: $layout =& $fm->getLayout('mylayout'); $values = $layout->getValueList('statelist'); $statelist = '<select name="State">'; foreach ($values as $value) { $statelist .='<option value="' . $value . '">' . $value . '</option>'; } $statelist .= '</select>'; $edit = $fm->newEditCommand('mylayout', $_POST['id']); $edit->setField('State', $_POST['State']); $edit->execute(); $record = $fm->getRecordById('mylayout', $_GET['id']); $State = $record->getField('State'); <td><?php echo $statelist; ?></td> Thanks so much!

Hi, when a search returns a listing, I'd like a numbered sequence like: 1 2 3 4 any example of how to do this? I appreciate your help!

Hi, I'm used to using tokens with FM 5.5. What's the best way to pass a field variable thru a form with PHP? I have a 'club number' field that is auto-entered for the head of a club. I'd like to pass that field variable thru via a form to a new input form that will give new users that club number thru a hidden input. Thanks!

Hi, I'm running FileMaker 12 database on a Filemaker 12 server. With my business file I'm able to sort and delete records, but cannot edit or create new records. With a second new test file, I'm able to edit, create, delete, everything. The 2 files have identical permissions and privileges. I know my PHP is correct because it works on the test file. The business file was converted from FMP 5.5 to FMP 7 to FMP 12. It is not a corrupt file. How can my business file not edit or create new records, yet be able to delete records? I appreciate your help! Here is the file. ssvdb.fmp12

I have noticed for quite a while now (a few years) that often when I try to reopen a hosted file that FMPA will spin for 20-30 seconds and respond with "file not available on this server..." error. But upon retrying it a 2nd time, it always comes right up. Anyone else run into this? This has happened on FMS12, 13 and 14 for me. This has been across multiple servers (same client location), different machines/clients, and different files. It has been just a minor annoyance so I haven't tracked it real well: I can't attest to whether it happens every single time I open the file; or perhaps it is only after leaving the office (after properly shutting a file down), and then coming back to the office the next day; or ?? Anyone else had something similar happen? -- Justin

Good morning all, we run several FMS12 windows servers with both FileMaker GO and FM13 clients. Very recently, we started to notice occasional duplicate / stale / ghost users in the client list on the server side. It occurs most often in the wireless / GO clients. It would appear a connection to the server is dropped, and when the client (GO) re-authenticates, it is occasionally starting a new session/client on the server without releasing the old one. This is wreaking havoc as the new session claims the old session has records in use, etc. The problem has also occurred on FM13 clients (wired)! We are not aware of any changes to our server configuration or GO clients. We have, however, recently switched non-iPad clients to FM13. Any advice as to how to track this problem down would be appreciated.

I am having some troubles with containers and PDF files. I want to be able to display the files to end users within the solution (i.e. they aren't downloading them), so wanted to use a container w/ interactive/preview capabilities so they could just scroll through it then and there. However, I seem to run into a problem whenever I host the file on our server and access from a remote client. Here's my testing: Create new file, add container field (internal storage); add field to basic layout, enabling 'Interactive content...' for the field; add PDFs to the file. A ) Storing and viewing this file on my local machine: works fine. I can right click and get 'Insert PDF' from the popup; files that I add to records preview fine. B ) Host the file on a server and open it with a remote client running on the same server hardware as is hosting the file: works fine. Same as A, above. C ) Host the file on a server (same server as B ) and open it with my local machine's client: FAILS. The PDFs don't preview; I am unable to get the right click menu to display anything other than 'Reload'. Can someone help me understand what I need to do here? I thought it might be an 'installed PDF viewer' issue, but the fact that it runs fine when the file is opened from my own local machine seems to go against that. Server is Mac OS X 10.6.8, FMSA v12.03. My system is Mac OS X 10.8 running FMPA 12.05; remote client is FMP 12.03 (?). Thanks, C

Hi all, Please bear with me; I'm a graphic designer learning to develop for my company when I have time. My boss bought me a copy of FMPA14 because I had heard our FMS12 could still host it, but I'm getting an SSL error when I try to connect to the server from FMP14. We have FMS12v04 on an old G5 running OS X Lion and it can't be upgraded any further. I've been researching this a bit and I found links to update FMS12 to v09 (I think?) which I haven't done yet. We all connect to the server with our workstations via LAN. We don't use FMGo or XML or anything like that (at this point). Is there a workaround or an option I can turn off somewhere? I don't want to buy an SSL certificate and I wouldn't know what to do with it if I had one. Thanks!

When I try to open the FMS12 Console, I see a dialog   Is this because I'm running Java 7.75?  I could not find any settings in System Preferences or Safari Preferences that had to do with certificates.   This occurred on Yosemite.  On Mavericks, nothing at all happens when I click the Start Admin Console button.  Please give me some suggestions.  --Doug  EDIT:  Fixed with installation of version 12.0.5 on Yosemite.  Off to install 12.0.6 on Mavericks to see if that helps there.

Does anyone know when I can buy FileMaker Server 12 ? I'm currently on version 11 and want to upgrade. Can some please help me out? Thanks, John

Can the Filemaker 12 Server Upgrade be used to upgrade from FileMaker 11 Server Advance even though the FileMaker 12 Server is not the Advance version? Can it be used?

Hi, I can obviously use application_version() as the means to detect a desktop, iPad or iPhone, or Web Publishing Engine. But is there any way inside the Web Publishing Engine, to detect if its's a desktop, or iPad or iPhone? Many thanks

Greetings! I've inherited an instance of FileMaker Server 12 that is hosting 100+ files, and 80% of them haven't been used or even logged into in years. 5% are used regularly, and 15% are used very occasionally. The issue is I haven't the foggiest idea which is which. Does anyone have any clever ideas on how I could, in one fell swoop, figure out which ones have fallen out of use? Are there database file properties hiding somewhere? In a perfect world, I would like to know: The date any user last logged into a file; The date any user last edited any data in the file; The account name of those users; The date the file was actually hosted. (I realize the answer is probably no, but I can dream, right? And there has to be SOME way to figure this out besides asking 500 people which databases they use...) Any and all ideas are welcome. Thanks! - Joy

We are going to deploy a new Filemaker Server 12 on Mac OS 10.9 We want to take our time with this to set it up correctly. Is it a good way to setup the new server completely and then at the end change the ip address to the right one? (after taking done the old one) We are also using IWP.

Hi, I'm looking to buy FileMaker 12 Server ? Any advise? Thanks

Let me start by saying I'm not a server or Windows expert in any way, shape, or form. I am the one-eyed FileMaker guru in the land of the blind, therefore, I'm the expert by default. I have taught myself everything I know from books and this forum and lots of trial and error. Our FileMaker server environment (v 12) is humming along just fine, and now corporate wants to revoke my access to the server and have everything go through a ticket system at the corporate level, which would mean a review by a board for any time I need to take the files offline. They estimate it'd probably be a week's wait for each ticket to be reviewed and approved, and then someone remote would have to take the files offline. Aside from the fact that I can't fathom waiting a week at a time for a simple fix (and other more complex issues having to do with financial reporting requirements and deadlines for such), apparently there is an idea floating at corporate that I should be able to access the server admin console via a web browser and not need to log in to the server, which is what I do now. Is this something that is possible with the basic "out of the box" FileMaker Server 12? If I can actually access the admin console through a web browser, then this loss of server access is probably not a big deal, but I don't even know where to begin looking for that. Any pointers in the right direction? Google is not my friend this afternoon. Thanks!

Our company purchased a new mac mini to run as a dedicated fmserver. It came with Yosemite. Attempting to install stops after accepting the licensing agreement, displaying a warning about bonjour needing to be installed: See attached screenshot. Â How do I install or modify Bonjour so the install continues?