I have one FME workbench running on application server to export all the GIS sql tables into MapInfo tab files. It was running fine before but recently failed a couple times, its failed to export tab files after running 50 minutes or so, and each time its failed at export different sql table. I checked disk space and sql tables and they are fine to me. Any suggestions are greatly appreciated, the log file is attached.
Question
overnight FME workbench export SQL to TAB files failed
+30- Safer
Hi
I believe the workaround for this in the past has been to change the Writer from MAPINFO format to MapInfo TAB (MITAB) or Precisely MapInfo Extended TAB (MAPINFO_EXTENDED).
Let me know if this works for you.
Crystal
+4- Contributor
Hi
Thanks for your help.
The issue got resolved after I updated the writer as MITAB in stead of MAPINFO.
It seems took a bit longer to export MITAB files, and the .MAP size get smaller.
Can you please explain whats the main difference between MITAB format versus MAPINFO format.
Thanks,
Jay
+30- Safer
Hi
I’m glad to hear that this solved the issue!
It is generally recommended to use MITAB over MAPINFO as it is more maintained and may be more efficient.
While the smaller size is not usually an issue unless it’s significantly smaller, I would inspect some sample records of the output and also check the total number of features to make sure everything is being written out properly.
Login to the community
No account yet? Create an account
An FME Account is required to contribute
LoginEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.