Custom XML Web Publishing Engine needs a longer timeout
Operating system version
Mac OS X 10.10.3
Description of the issue
XML Web Publishing Engine requests fail if it takes more than 60 seconds to return a result.
This is a big problem when reading or writing large batches of records, or when calling scripts that take a long time to run.
Steps to reproduce the problem
On a hosted file, create a new script called 'wait'. It should contain a single script step: Pause 70 seconds.
From an OS X client machine, use curl to trigger an HTTP request to run this script and find any record, like this:
curl -I -u username:password "http://serverAddress/fmi/xml/FMPXMLRESULT.xml?-db=TestDatabase&-lay=TestLayout&-script=wait&-findany"
I would expect that after 70 seconds, I would get an XML result for a random record from TestLayout.
After exactly 60 seconds, a 502 (bad gateway) error results.
Exact text of any error message(s) that appear
HTTP/1.1 502 Bad Gateway
Date: Fri, 05 Jun 2015 01:23:19 GMT
Server: Apache/2.4.9 (Unix) OpenSSL/0.9.8za
Content-Type: text/html; charset=utf-8
Edit the file at /Library/FileMaker Server/Admin/admin-helper/WEB-INF/conf/mod_proxy.conf
Change this line:
ProxyPass /fmi/ http://127.0.0.1:16021/fmi/
ProxyPass /fmi/ http://127.0.0.1:16021/fmi/ timeout=600
Stop and start Apache by using fmsadmin.
A similar problem exists on Windows servers, but I have not come up with a workaround yet.