FMP9 crashes on ODBC import performed in script
Operating system version
Windows XP Pro
Description of the issue
Importing from an Oracle db into a Filemaker9 db on FMServer 9 as a step in a script can cause FileMaker to crash with the standard Windows termination message (details in error section).
The same crash can occur when editing the script step that does the import: clicking on the "specify" will precipitate the crash.
The problem is somewhat intermittent: across a number of databases, there are some when it happens most of the time and some where it does not appear to occur at all. The longer FMP has been open, the more likey it is to occur: restarting after a crash and doing the import immediately sometimes works.
It may be that the database size is a factor: importing from a table of 10k or more records into a mostly populated table of the same size seems more likely to crash.
Steps to reproduce the problem
Run a script with an import step.
Records imported successfully from external db to FileMaker.
FileMaker crashes without importing anything.
Exact text of any error message(s) that appear
FileMaker Pro Advanced.exe has encountered a problem and needs to close. We are sorry for the inconvenience. If you were in the middle of something, the information you were working on might be lost. For more information about this error, click here.
AppName filemaker pro advanced.exe AppVer: 188.8.131.52 ModName oraldapclnt9.dll ModVer 9.2.06 Offset: 00002cc8.
THe dialog appears a second time with the following error signature.
AppName: filemaker pro advanced.exe AppVer: 184.108.40.206 ModName: ntdll.dll ModVer: 5.1.2600.5512 Offset: 00042b9f
Import from an Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi via Oracle ODBC driver in OraHome92 version 9.02.00.65
Try again until it works.