3 Replies Latest reply on Aug 15, 2017 11:07 AM by TSGal

    No error, infinite beach ball when PSoS script result is over limit

    Chris Irvine

      Product and version - OS and version

      FileMaker Pro Advanced 16.0.2.205 (MAC) connected to FileMaker Server 15.0.3.308 (WIN)

      also, FileMaker Pro Advanced 15.0.2.220 (MAC) connected to FileMaker Server 15.0.3.308 (WIN)

       

      Description

      The documentation for the Perform Script on Server describes a 1 million character limit that applies to script parameter and result. If the script result is larger then this limit, it appears to me that the FMSE thread wraps up cleanly, with the server returned to a normal state.

       

      The client which was waiting for the script, normally beach balls while the script is running. However, even after the server has finished working, the client will continue to beach ball forever. To a typical user, it appears that they need to just keep on waiting.

       

      The client script execution should resume after the failed PSoS step, and throw an error which we can catch with Get(LastError). It would also be ideal, if the "result exceeds limit" condition would be logged in some way on the server.

       

      How to replicate

      Create a client script that calls a server script using PSoS. Have the server script generate and exit with a result around 2 million characters.

       

      Workaround

      It does appear that the client process is not completely hung or in a broken state. The server administrator can disconnect the client with an optional message.

       

      The developer could manually monitor the length of potential script result and make efforts to avoid the condition. However, without any error reporting on the issue, or a Remote Debugger , a developer isn't likely to realize that they have a result near the limit.