1 Reply Latest reply on Mar 17, 2015 1:00 PM by TSGal

    FileMaker Server PHP error -"XML error: No memory at line 1 (error )"

    JamesCollins_1

      Summary

      FileMaker Server PHP error -"XML error: No memory at line 1 (error )"

      Product

      FileMaker Server

      Version

      13.0.5.520

      Operating system version

      OS X - 10.9.3 and Windows Server 2012 Standard

      Description of the issue

      After performing a find command in PHP, if filemaker returns a large amount of data, the error message 'XML error: No memory at line 1 (error )" is returned and process halted. The actual line number varies.

      Trial and error suggests returning around 200,000-300,000 or more fields cause this issue (1,000 records from a layout with 200-300 fields).

      I have found this problem occurs with any database if enough data is returned, including those made from scratch with just one one table. The problem is not with my deployment, as the same result is returned when using cleaned installs of OS X 10.9 and Windows Server 2012.

      The issue started occurring when I did the latest update (as far as I can work out).  I cannot find any previous versions of FMS so I cannot test if this is the case.

      Steps to reproduce the problem

      Create a new database with 300 fields, put all 300 in the layout 'data' and create 1000 records, upload it to Filemaker Server 13.0.5.520. Use the PHP below to return all records:

      $findCommand =& $fm->newFindCommand('data');
      $result = $findCommand->execute();
      if (FileMaker::isError($result)) {
      die('

      '.$result->getMessage().' (error '.$result->code.')

      ');
      }
      else {
      $records = $result->getRecords();
      }

      Expected result

      Returns 1,000 records

      Actual result

      Returns "XML error: No memory at line 1 (error )"

      Exact text of any error message(s) that appear

      "XML error: No memory at line 1 (error )"

      The line number varies

      Configuration information

      Single machine setup. Tested under:
      - PHP Version 5.4.24 in OS X 10.9.3, Apache, (12GB Ram)
      -PHP Version 5.5.16 in Windows Server 2012 Standard Edition, IIS/8.0,  (8GB Ram)
      -PHP Version Version 5.4.27 in Cent OS (connecting to the above Windows server)

      Workaround

      Optimise the layout, so it has fewer fields. Perform a search for fewer records.