Thank you for your post.
There was an issue with FileMaker Pro 9.0v2 freezing when using an external data source. This was resolved in FileMaker Pro 9.0v3. Please see Knowledge Base Article #6749 to download the update and to also read the changes in FileMaker Pro 9.0v3.
thanks for the suggestion. I tried upgrading to 9.0v3 and it did not seem to help. So I'm still not sure what the problem is.
This sentence caught my eye: "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."
"A number of databases" A number of databases serving as the import source? The Target? Both?
"and some where it does not appear to occur at all" Does not occur at all when you import FROM certain databases or does not occur at when you import INTO certain databases?
We have about 30 filemaker databases to which we import data from about 30 corresponding Oracle databases. A couple of us have no problems, a couple see the error often: usually the second time we try to run an import, but with no apparent pattern with respect to which database. Which is tricky with scripts that have two "import records" steps.