dmw3

We run a set of linked databases on a FM Server Advanced 12. The links work if the databases are all in the same folder on a client, but when moved to the server and accessed from a remote client the links are broken giving an error "missing file" even though the databases are in the same relative place as they were on the client install. Has anyone seen this before? We had to move our setup off a Mac server as this was out of warranty, the same setup worked on the Mac installation of the server. Current setup: Windows 2008 server R2, Filemaker Advanced Server 12.0.4, remote clients all FM Pro 12.0.4

Is there a way to format number fields so that it is allowed to have a leading zero? Problem is that we use both mobile phone numbers and state codes with leading zeros. e.g.: 0417 123 456 or 03

Did you end up finding what in the config file got changed when you uninstalled 12.0.1? have you done a compare with the restored file to find out?

We are about to update our Advanced Server 11 to Advanced Server 12 on our OSX XServe. has anyone experienced any gotchas in doing this? We have about 40 databases being severed from this setup to both clients and IWP. Also interested in the process others have used during a migration such as this, for backlups and restore of previous version if the upgrade fails for some reason.

When running the schedule on the server, I get an event report emailed, but no attachment. Do I need to put the SMTP details into the send script step or just have the details in the server schedule? Its strange that you can set an email schedule on the server but not have the ability to add an attachment.

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?

Ok an update on this. We are able to use the Admin Console on a remote computer after changing a proxy setting and deleting the certificate that Filemaker installed. This then allowed us to reinstall the certificate which resolved the issue on the remote, but the same procedure on the server did not resolve the issue, might be related to a certificate or something else. Any thoughts anyone?

In trying to sort this out, this is the output from the java console: Java Web Start 1.6.0_29 Using JRE version 1.6.0_29-b11-402-10M3527 Java HotSpot 64-Bit Server VM User home directory = /Users/admin ---------------------------------------------------- c: clear console window f: finalize objects on finalization queue g: garbage collect h: display this help message m: print memory usage o: trigger logging p: reload proxy configuration q: hide console r: reload policy configuration s: dump system and deployment properties t: dump thread list v: dump thread stack 0-5: set trace level to <n> ---------------------------------------------------- Could not launch from cache. Will try online mode. [some of required resources are not cached.] Using standard JNLP Launcher Show stack traces: log Arg = keep-alive-interval=60 Arg = log-level=WARNING Arg = carrier-stream-provider=com.ulcjava.base.shared.TrivialCarrierStreamProvider Arg = url-string=https://localhost:16001/adminconsole.ulc Arg = launchtype=normal Arg = server-language=en Arg = server-timezone=Australia/Hobart AdminConsoleJnlpLauncher - using allCertsTrustManager AdminConsoleJnlpLauncher - Installing custom trust manager AdminConsoleJnlpLauncher - Register HttpURLConnection AdminConsoleJnlpLauncher - finished installing custom trust manager AdminConsoleJnlpLauncher - installing File Service AdminConsoleJnlpLauncher - installing Browser Service AdminConsoleJnlpLauncher - createSessionStateListener() Even clearing the Java cache files we still get the error - Admin Console could not start: Admin Server manager unavailable. Running the command "fmsadmin restart adminserver" seems to do nothing after the prompt comes back asking if you really want to do this. Somebody who is running this on a OSX 10.6.8 server please let me know what processes are running, we only have two FileMaker processes running.

What is the process that I would be looking for to see if the Admin Console was working? The Help pdf makes no sense in what it is saying: "If Admin Console is unable to connect to FileMaker Server, it is possible that the Admin Server process has stopped or FileMaker Server has only partially started. To check whether the Admin Server process has stopped, try using the fmsadmin LIST FILES command (see LIST command). If LIST FILES works, the Admin Server process has stopped and you can use the fmsadmin RESTART ADMINSERVER command to restart it. " Why if you type in the List command should you not see files listed if the Admin Console is working? I have deleted the Java cache and restarted, updated the server to 10.6.8 and Filemaker Advanced Server to 11.04, how have others resolved this problem? I have tried turning the Firewall off so it is not blocking ports, strange thing is it was working when we first installed Filemaker Advanced server some three months ago. We are only running Filemaker server on one server and do not have another equal server to use, please help!

Steven, the permissions i refer to are those enabling ODBC or client or web connections. Is there a way to use the Admin server from the command line if we cannot get the java console to work? the Admin server console was working but now does not, even with all updates applied.

We have the same issue. Updated to latest version 11.04 and still no Admin Server Manager. OSX Server 10.6.8 Databases are able to be reached remotely but we cannot add or change database permissions. Hammerton, did you get this resolved? Is there a command line version of the Admin Console? This problem has halted our deployment of more databases with FileMaker.