Filemaker ODBC Memory Leak with LabView
Filemaker 12 vs 2,3,& 4
Every time I write a record from NI Labview rev 2012 to Filemaker using the Filemaker ODBC driver, the labview memory creeps up between 56-80kb (as observed in the Windows Task Manager). The NI people spend a bit of time investigating this and found that the filemaker ODBC driver was not telling Labview it was finished with the memory transaction. The Microsoft ODBC Driver for Access had a similar design flaw. However, it is unclear if Filemaker ODBC followed the same design constrains as Microsoft.
This isn't much of an issue when running programs for short periods of time (Up to 12 hours). However, when running Labview 24/7 for more than 24 hours, the computer crashes due to lack of system memory.
I have a simple filemaker database and Labview app which I sent to NI so that they could test this issue which is available to anyone interested in this issue.
1)Create a filemaker Database
2) Create a ODBC DSN link to the Database.
3) Create Labview app to write data repeatedly (Loop) to Filemaker.
4) run Labview and watch the memory creep in the Task Manager.
Memory should be released after each write to Database from Labview.
The Labview App memory creeps up by 64-80kb per each write to the Filemaker database.
you need to install and configure Filemaker ODBC for Labview to access the database.
So far the only work around is to halt the Labview program and wait for about one minute for the system to clear out the program and memory and restart Labview every 6-10 hours of runtime.
Sounds like the same issue I've struck. I've put a workaround in place of restarting the SAS session after 25,000 ODBC 'inserts', because otherwise the session runs out of memory. The version 12 FileMaker ODBC drivers are a bear... had stacks of probs with them since upgrading from v10.