I have a spatial data set that contains line data that I need to write to a MSSQL table. Unfortunately at the moment the table is being created but no data is being written to it despite FME saying it is successful. I have my writer set up and it can be seen in the attached screenshot. I'm wondering how I can force the data into the table?
Question
Writing spatial data to an MSSQL table results in no data written
+2- Contributor
nielsgerrits wrote:
Anything in the log?
There are warnings but no errors and it says translation was successful. The number of features I expect to be written are written according to FME
+52- VIP
emerson_styles wrote:
There are warnings but no errors and it says translation was successful. The number of features I expect to be written are written according to FME
I believe the translation is always succesful unless it get terminated, so translation succesful might be a bit misleading.
How do you check the result? Can you try and use another workspace to read the written table? My MSSQL knowledge / experience is zero. This is what I would try to check if the resulting table has any feature.
I would also try to fix the warnings in the log. Got quite focussed on blue text in the years using FME.
+2- Contributor
emerson_styles wrote:
There are warnings but no errors and it says translation was successful. The number of features I expect to be written are written according to FME
I've checked the resulting table in MSSQL studio and it is blank; the column headings are there but there is no data in the table.
+52- VIP
emerson_styles wrote:
There are warnings but no errors and it says translation was successful. The number of features I expect to be written are written according to FME
Are you sure it is not a cache issue? This is the reason why I would check reading the table using another tool, FME, to be sure.
Reply
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.