2 posts in this topic
Admin Server Console - Connection Refused Error
By Andrew Nicolay
I'm helping a client who has an old install of Filemaker Server Advanced 11 running on a Mac Mini.
It's been running Filemaker v11.5 for about 2 year without any issue... All of a sudden today, it stopped working!
I checked to see if there were any updates installed from apple or java... NONE!
I completely uninstalled Filemaker Server and reinstalled v11.5 and applied the java fix... still won't start.
Just for laughs I installed v11.2, that installed fine, up and running no problem, as soon as I restart the Mac Mini, everything takes a dump. When I go to localhost:16000 or serverip:16000 in the browser, nothing happens, as if filemaker server was never even installed. If I double click the applet icon, it says "Unable to launch the application - Connection Refused".
Script to access data in another file
By Miss A!
I am working on a script to be triggered when a field is modified so that it can pull data and update fields on a layout. Some data is in another file and i do not know if possible how to access this file and search for the data i need?
Any thoughts on how to accomplish this?
Thank you for assisting,
Error: Database not available
My users are getting this error "database not available" when attempting to access a solution (the only solution) on this server. I get the error on a Macbook with Safari, they get the error with a PC using IE.
I notice when searching for this error that some solve it by redeploying the server, or rebooting the server, or removing the "spaces" in the name and replacing them with "_". I've tried all that. Still getting the error. I'm not sure what else to try.
FMS 18.104.22.1682 / WS 2012 R2
Self-Join Relationship for finding Duplicate Value with "OR" condition
I have two tables: Companies and dupcheck_companies...Self-joined with Companies:company = dupcheck_companies::company AND Companies:pk != dupcheck_companies::pk
And attached script trigger with layout (onrecordcommit) to show custom dialog if duplicate key (serial of table occurrence not empty) is found .. it works fine when duplicate company name value is found , but what if I want to check another field (phone number) for duplicates , I think it would be better if I could self-join with an OR condition instead of AND , but don't know how
Relating tables with month and year
I have two tables Claims and Premium
Records on both tables have dates
I want to do an analysis for both tables on monthly and yearly basis with a calculation field
Analysis (Claims::claims + Premium::premium)
my objective is to be able to gather all the records for each month and each year on both tables using that analysis. That is my basic task. There are other fields like Remark, and recommendation but they are based from the result I get from the Analysis. For example, Analysis field is > 120 , Remark shows Excellent..
please how do I achieve this?