18 posts in this topic
I had been using FM EasySync for few months now, so it had been working fine till now.
Without having any change in the table structure, i got the error " The attempt to push data into server has failed ( The mesage recevied rom the server was "852" )
852 Error is : Cannot write a file to the external storage
I believe this is related to container fileds I am using. There has been no change in the Container field options. They are still being stored "Externally" on the server with Open Storage option. Also there hasn't been any change on Server policies as well.
I have no clue as to what could have cause this. Anyone having idea about this ??
I am using Insert From URL to send HTTP GET request to my server and get the result.
I have a function PING that returns 1 if the server is online, but it cannot returns 0 if it is not so I am catching the error on filemaker :
Connection timed out; the timeout value is 60 seconds.
Is there a way to reduce this timeout value so the user does not have to wait a minute to know that the server is offline ?
Similarly, if a process takes too long to answer, is there a way I can timeout the Insert From URL command ?
I have a system being hosted using FMS14. I also have a duplicate database hosted for testing/exporting using FMS15. PSOS is much slower in my hands with FMS15.
Both servers are physical boxes, with similar (maybe identical) specs (Cores, RAM HD Space, HD Space available)
I also have a Server Side script that creates a found set, exports data to excel and emails it to a user. (This is based on https://www.skeletonkey.com/restoring-filemaker-clients-found-set-within-server-side-script/). The exports have a couple of related fields, but no unstirred calculations.
Using FMS14 this has been working just fine. Using FMS15 it has been significantly slower.
As a test, I exported 13,000 records from both FMS14 and FMS15.
Using FMS14, it takes about 10 Seconds to recreate the found set, then 70 Seconds to create the export.
Using FMS15, it takes about 20 Seconds to recreate the (same) found set, then 175 Seconds to export the data.
In another series of tests, this time exporting 30,000 records (more realistic in my scenario) I found;
Using FMS14, it takes about 25 Seconds to recreate the found set, then 168 Seconds to create the export. (2.5x longer to find/2x longer to export 3x records)
Using FMS15, it takes about 90 Seconds to recreate the (same) found set, then 825 Seconds to export the data. 9x longer to find/11x longer to export 3x records)
In the last series of tests, this time exporting 50,000 records I found;
Using FMS14, it takes about 59 Seconds to recreate the found set, then 262 Seconds to create the export. (6x longer to find/4x longer to export 5x records)
Using FMS15, it takes about 160 Seconds to recreate the (same) found set, then 1700 Seconds to export the data.(16x to find/24x to export 5x records)
Any ideas? Anyone see similar results with PSOS on FMS15?
Again, the machines are identical, the databases are identical and the scripts are identical. the only difference is FMS14 vs. FMS15. I am also letting another user pull data using ODBC. That has also gotten extremely slow using FMS15, but that is a discussion for another thread. I am not using WebD on this server. In general the FMS15 database performs find using FMP Clients. But the FMS15 functions are not very impressive. I am petrified to move my production database to FMS15, and even considering moving the test server back to FMS14. Help!
I have a problem with server side import of records. I have a simple script which just does an import of a textile (with tab delimiters):
Set Variable [$FileList; Value: "filewin://server/folder/1795739.txt"]
Go to Layout ["files" (files)]
Import Records [No dialog; "$FileList"; Add; UTF-8]
When I run it client side, everything is fine. When I run it server side with Perform Script on Server I'm getting an error:
The previous script step, "Perform Script on Server", could not be completed because of an error....
If I run Get ( LastError), I get error code 100 (File is missing)
I have tried many different file locations for the textile. Network path, Local path (on the FM server) and Relative path (from where the database is placed on FM server).
I have tried placing the file in the FM server Databases and Documents folder AND the User Documents folder:
filewin:/C:/Program Files/FileMaker/FileMaker Server/Data/Documents/1795739.txt
filewin:/C:/Program Files/FileMaker/FileMaker Server/Data/Databases/1795739.txt
Every time I get error 100. What am I doing wrong??
FileMaker server is v14 on Windows Server 2008 and the client is running on Windows 7.
By Miss A!
I have scheduled a script that i expect to search for a running tour(on current date) and creates and invoice for that tour. The server gives a notification that that script ran but when i check the database, there are no records created. Also the script ran just fine initially and suddenly that began to happen, without any alterations.
Anybody aware of a situation like this with server scheduled scripts and have an idea how to fix this.
Thank you for your time and support.