Sign in to follow this  
Followers 0

XML Error line 1

6 posts in this topic

XML error: No memory at line 1

Greetings, this error occurred when the Filemaker API cannot generate a bunch of records. (1000+ records and above)

I've adjusted the time out settings for PHP even the memory limits.

Is there any possible solution for this?


According to some information, the error turns out that the 10 MB XML scripts is unchangeable.


Share this post

Link to post
Share on other sites

Do you really want to get 1000+ records in one go?  Is this for a user-facing routine?

Share this post

Link to post
Share on other sites

Posted (edited)

Actually I used the reference from formulations Pro

I used the Pagination of navigation links (the next, previous, last and first) where it will show one by one.

Therefore despite of 1000+ records that should not caused any drawback as  it will show one by one only.

Is there any root to fix the XML error? I'm working on a quick development of project where I will create a web version of a filemaker projects.

Edited by jamescv7

Share this post

Link to post
Share on other sites

We'd need more information about the actual call, the configuration, the FM file, etc.

I did a test a few weeks ago to compare the new FMS16 Data API to the XML API for speed and was asking for 10,000 records.  No errors.  So I don't think it is the # of records necessarily that is causing this.

What is the result if you just use the -findany command?

Share this post

Link to post
Share on other sites

Posted (edited)

I export 5000-10000 records on a regular basis, and occationally millions; I have not yet seen this error before you posted this here.

How much memory do you have?( all involved machines to reproduce the error ) Also how much memory is free on the bootdisk. Do you use for-each in XSLT? Then change to template.

Of course the number of fields pr record also counts, both calculations and keys do spend a considerable amount of resources; Compared to plain data fields.

22 hours ago, jamescv7 said:

Is there any root to fix the XML error? I'm working on a quick development of project where I will create a web version of a filemaker projects.

This may or may not be a design issue, not necessarily one of XML, but I do not know enough to make any conclusion.

Edited by ggt667

Share this post

Link to post
Share on other sites

What a bummer, I replicate the problem and it seems there is no issue when retrieve even 20k of records.

Likely I need to fix the source code again.

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  
Followers 0

  • Similar Content

    • By gczychi
      I want to access a data base «Import.fmp12» hosted on FMS 16 with the new Rest API but cannot get it to work.
      Testing with «ARC Plugin for Chrome» (great tool, btw) and Postman.
      In ARC, I get the error 802 – Unable to open file; in Postman, I won't even get that far:  «Could not get any response»

      This is what I did so far:
       – The file is accessible fine with any FileMaker client using FileMaker username and password (triple checked spelling, etc.)
       – Can connect fine to WebDirect with any browser and http
       – Cannot connect using Rest API and http, so went for https
       – Got an authentication error with https, so
       – Installed a self-signed certificate both on the server Mac and on local Mac for my
      Getting mixed results:
       – Firefox: certificate: Error code: SEC_ERROR_UNKNOWN_ISSUER  (to be expected)
       – Safari: FMI Default Certificate: Certificate not valid (host name mismatch). For whatever reason, Safari doesn't use my certificate.
       – Chrome: strikethrough https but shows the WebDirect server
       – ARC Plugin: Using Can get now through to the server (no SSL-Auth problems anymore), but the result is: {"errorMessage": "Unable to open file","errorCode": "802"}
       – Postman: Using «Could not get any response» and an error message: «{"errorMessage":"Method Not Allowed"}»
      Any ideas?
      Thanks  for any help.
    • By Ken d'Oronzio
      FREE fmREST.php – Simplifies & manages PHP connections to FileMaker 16’s REST-based Data API.
      The newly released FileMaker Server 16 now offers REST access to your FileMaker databases. There’s more about that how this impacts PHP developers here.
      The bottom line is that to use REST as part of your PHP solution, you would usually need to write a series of cURL functions and you would have to manually manage connecting & disconnecting from your server, and saving your tokens.
      This is a pain!
      We know it’s a pain, because we have spent the last several weeks rolling REST functionality into soSIMPLE Calendar.
      We created this class file to make it easier to manage dynamic REST sessions for soSIMPLE and our custom development. The goal of the class file was to help PHP developers start using the new REST engine as quickly and easily as possible.
      We’ll also be updating it with new features. If you’d like to add something to it, please let us know.
      What fmREST.php does:
      Makes every REST call available as a PHP function. Automatically login into FileMaker Server whenever you call any REST functions Saves your token for 15 minutes to reuse Checks for a broken or disconnected token and automatically reconnects and runs your function again Where do I get it?
      You can download the fmREST class file here.
    • By GisMo
      I have a php script that takes two PDF files and merges them into one file. I am using this in conjunction with the insert from URL script step. 
      The way the script works is it takes two PDFs in container fields and base64encode each files. Then, those two base 64 strings are POSTed via insert from URL.
      I've tested the script forwards and backwards and it does combine the PDF files reliably. The issue is when posting from FileMaker. What typically happens is the first page is combined twice and that's my resultant PDF. 
      My php script checks that both inputs are different and throws an error is they are identical. I don't get any errors there.
      Is there a way to POST a file from insert from URL?
    • By Jason Mundok
      I have a website that is displaying FileMaker data using the PHP API. Is there a way for the web site to display the basic text formatting from a FileMaker field? For example, a few words in the comments field are bold in FileMaker and I would like them to also be bold on the website. Thanks for any ideas.
    • By randyinla
      Hi, I have a field called 'mytournament1'.  I also have a field called 'mytournament1played'.  With a form, I create the variable $tournament to bring 'mytournament1' to my results page.
      $tournament = $_GET['tournament'];
      I'd like to force the results page to search for the field 'mytournament1played' for each record by using the variable $tournament and combining the word 'played' or the variable $played.  
      $played = 'played';
      $tournamentplayed = $tournament . $played;
      $tournamentplayed2 = $record->getField('$tournamentplayed');
      (I want it to deliver)      $record->getField('mytournament1played');

      I know the 1st '$record->getField' line is wrong.  Can I combine 2 variables that spell out a database field name (mytournament1played) that can be used to call up a field in a search?  i.e.
      if ($tournamentplayed2!='1') {

      thanks in advance for your help!