Skip to main content
Question

Smallworld to MS SQL Spatial (JDBC) fails to write any features

  • July 27, 2020
  • 1 reply
  • 15 views
N

I am trying to write from Smallworld 4.3, using FME 2018 build 18301 and the MS SQL Spatial (JDBC) writer. The writer creates the new table ok, but when it tries to write the features I get the following error: “C:\\apps\\FME2018\\metafile\\mssql_jdbc_spatial_.fmi could not be opened”. If I look in this directory there are 3 .fmi files that start with mssql_jdbc_spatial_, ie Destination, geommap, & Source. I presume FME is looking for some sort of parameter value, and trying to make some decision on which of these 3 files to use, however I can’t see any missing parameters in my mapping file. Can anyone point me in the right direction please?

Thanks Neal

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

N

Since posting this question, I have since found inserting a "generalizer" between the reader and writer seems to fix the issue.

Community Stats

32,207
Posts
122,305
Replies
39,891
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.