
DataCruncher
Members-
Content Count
92 -
Joined
-
Last visited
Community Reputation
1 NeutralAbout DataCruncher
-
Rank
member
Recent Profile Visitors
3,284 profile views
-
Hello, since yesterday, all of a sudden my downloads are failing in a script like that: The temporary path is present on my local disk as follows: /Macintosh HD/var/folders/cw/l28ygv6523d4tgfjwknnc85r0000gq/T/S10/ But the directory is empty? Has anything changed with the SuperContainer plugin or with a Mac version update recently perhaps? Thank you! --------------------------------------- UPDATE - nothing wrong with SuperContainer or OS X. I rebooted my client machine and everything was back to n
-
Where to increase -Xmx memory with MS6 on Linux
DataCruncher replied to DataCruncher's topic in MirrorSync by 360Works
Thank you! I was able to figure it out last night for RedHat: It required a setenv.sh file to be created and a restart of TomCat. Works like a charm now. Thank you. -
Getting the dreaded: java.lang.OutOfMemoryErrorL Java heap space message again on initial sync, MS6. I know the advanced topics outline how to increase heap space on Mac and Windows - but which file do I amend to increase memory allocation with the mirrorsync installed on tomcat 8 / Linux? Thank you!!
-
I have a calculation field, with a text result, that I want to give some sort of visual indication of how expensive an item is without displaying the actual price. In a list view, I would want that text calculation field to provide quick visual reference as to how expensive an item is: ITEM 1 - $$$$$$$$$ ITEM 2 - $$$ ITEM 3 - $$$$$$ ITEM 4 - $$$$$$$$$$$ ITEM 5 - $$ Short of nested Ifs, what is an elegant way to achieve that calculation? Thank you
-
FMS18 on Mac randomly crashing at around 11:55 PM
DataCruncher replied to DataCruncher's topic in FileMaker Server 18
SOLVED! Wim was very right. On my virtualized Mac server, I looked high and low and couldn't find any cronjobs that would run at that time. However, I did not check the launchd plists!!! D'Oh! Turns out, /Library/LaunchDaemons contained two .plist files that invoked letsencrypt renewal scripts at 11:51 PM every Saturday! The StartCalendarInterval was the dead giveaway. I assume FMS shuts down into some sort of safe hibernation that disallows it to be re-started if someone tries to mess with the SSL certificate while the server is running. -
Multi-dimensional query - SQL hard-code or related tables?
DataCruncher replied to DataCruncher's topic in Relationships
Yes, that would allow me to script that result, but ultimately, I need that result list as dropdown to be rendered on a website. So I need all of that to work in a Field calculation? -
Multi-dimensional query - SQL hard-code or related tables?
DataCruncher replied to DataCruncher's topic in Relationships
I'm sorry I didn't explain this properly. The dropdown field for specialty would be from within the context of a specific insurance company. In other words, you could start from no context and make it two dropdown boxes: - Select any one medical specialty - Select any one insurance company Result list should then show all physicians matching specialty and insurance company. Any doctor may have one or more medical specialties and any doctor may be credentialed with one or more insurance companies. -
Good morning - so this is something I have struggled with for some time and it seems easy enough but I can't seem to figure it out. For every simple relationship in my database, I can very easily show related records. It's literally one direct related record away and can be processed easily in formulas, lists, scripted - it just works. However, I struggle when more than one relationship is involved. As an example, assume I want my solution to manage a team of physicians in different insurance networks. So my basic tables are: PHYSICIANS INSURANCE
-
FMS18 on Mac randomly crashing at around 11:55 PM
DataCruncher replied to DataCruncher's topic in FileMaker Server 18
Thank you Wim and John - I will keep looking. Like I said, it's a graceful shutdown as far as FMS is concerned - but after that has shut down, it won't come back on even from fmsadmin CLI. That's what's weird, but I agree it has to be something in the environment. -
FMS18 on Mac randomly crashing at around 11:55 PM
DataCruncher replied to DataCruncher's topic in FileMaker Server 18
Thank you, John - I have data restoration disabled on all my machines as this can really really have things head south, and fast 🙂 I was hesitant to move to FMS19 without identifying the cause first, simply because I did not know what else that would break and whether the same error occurs again. But I'll give it a try! Thank you -
FMS18 on Mac randomly crashing at around 11:55 PM
DataCruncher replied to DataCruncher's topic in FileMaker Server 18
Bumping this topic. It keeps happening, light clockwork, to all three of our FM 18 servers 11:55 PM every Saturday. All filemaker functions drop off, and CLI result in 10007 error. What I did observe is when it goes down, the connected FMP clients get this warning message "Filemaker Server is shutting down now' so this appears to be some sort of graceful commanded shutdown that then kills the entire ecosystem for good. We do not have scheduled script tasks or cron jobs running at that time - why would Filemaker Server do that? Which log should I check for hints why this is h