AnsweredAssumed Answered

Perform Script on Server OnLastWindowClose trigger causes server hang

Question asked by dansmith65 on Aug 1, 2014
Latest reply on May 12, 2015 by TSGal

Summary

Perform Script on Server OnLastWindowClose trigger causes server hang

Product

FileMaker Server

Version

13.0v3

Operating system version

Windows Server 2012

Description of the issue

If a file uses Perform Script on Server step and has a script triggered OnLastWindowClose that performs a script in another file that also triggers a script OnLastWindowClose, the server often gets stuck in a loop opening/closing the second file.

As the Access.log file in the download shows: this error is intermittent. The first test worked as expected, the second test opened/closed the PSoS_ancillary file 3 times, the third test ran in an infinite loop so I disconnected the user via fmsadmin.exe.

Note that the Access.log file shows the client as "Server 13.0v2", but I do have server 13.0v3 installed and provided a screenshot as evidence.

Steps to reproduce the problem

1. Download this file: https://dansmith65.permalink.s3.amazonaws.com/filemaker.com/PSoS.zip
2. Host it on FileMaker Server
3. Open it in FileMaker Pro
4. Click the "Perform Script on Server" button on the layout while watching server CPU usage. FileMaker server will use ~100% of a single CPU core when the issue happens. You may need to click this button multiple times (usually less than 10) before it causes the hang.

Workaround

In the file where Perform Script on Server is performed, do not allow a script that is triggered OnLastWindowClose to perform a script in another file.

Outcomes