Court Bowman Posted April 7, 2011 Share Posted April 7, 2011 All, We ran a sql call that selected two fields from a table "SELECT CATEGORY, AMOUNT FROM TABLE" where the table had 135K+ records in it. FileMaker unexpectedly quit during the evaluation of the function call. It was a function that was in a plugin that was created via ScriptMaster Advanced. The function works for all other sql queries (it basically just returns the value from fmpro.evaluateSql ( sql ; field_seperator ; row_seperator) ). The ScriptMaster logs show the function being called, but there is no information after that in the log. We ran the same sql query through a different plugin and the query took awhile, but did successfully return. We put the text returned in a text file and it was 5.8MB total. Not sure what the problem is, but it seems there's some sort of return limitation with the SQL query function that is in ScriptMaster where there wasn't in the other plugin. Do you guys have any ideas? Thanks in advance! Link to comment Share on other sites More sharing options...
Smef Posted April 7, 2011 Share Posted April 7, 2011 Hi Court, What version of ScripMaster are you currently using? I think there was an issue similar to this with an older version of the plugin, but this should be resolved in the latest build which is 4.123. Link to comment Share on other sites More sharing options...
Court Bowman Posted April 8, 2011 Author Share Posted April 8, 2011 Thanks for the prompt reply. We were using version 4.12 so to test I downloaded 4.123, rebuilt the plugin, and tried it again and it crashed the same as before. I also tried running it directly through scriptmaster, rather than in the seperate plugin we built, however it still crashed FileMaker... Court Link to comment Share on other sites More sharing options...
Smef Posted April 8, 2011 Share Posted April 8, 2011 I think the plugin is running out of memory with your large result and the simple fmpro.executesql function call. Can you send me a file to try and reproduce this on? You may want to try to increase the amount of memory that the plugin is using. Directions to do this are available at http://wo.360works.com/cgi-bin/support/productsupport.cgi/Heapspace_Out_of_Memory_Error Link to comment Share on other sites More sharing options...
Court Bowman Posted April 8, 2011 Author Share Posted April 8, 2011 Sure, do you want me to email it? and if so to what address? Court I think the plugin is running out of memory with your large result and the simple fmpro.executesql function call. Can you send me a file to try and reproduce this on? You may want to try to increase the amount of memory that the plugin is using. Directions to do this are available at http://wo.360works.com/cgi-bin/support/productsupport.cgi/Heapspace_Out_of_Memory_Error Link to comment Share on other sites More sharing options...
Court Bowman Posted April 8, 2011 Author Share Posted April 8, 2011 For what it's worth, we did try an increased memory allocation and it is still crashing... Court Link to comment Share on other sites More sharing options...
Court Bowman Posted April 9, 2011 Author Share Posted April 9, 2011 I didn't hear back so I found your email address and sent you a link to download the file. Let me know if you have any solutions. Court Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 4766 days old. Please don't post here. Open a new topic instead.
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 accountSign in
Already have an account? Sign in here.
Sign In Now