Hi, im trying to convert shapefiles to Sql Server. Yesterday, FME made a succesful conversion with one of my shapefiles, but today i have a loop error with all my conversions, even using the same shp as i used yesterday.
+44- Evangelist
Hi @miguelbmahillo
How are the results in SQL Server ( without FME )?
Is your Workspace on the Writer by Dynamic?
Could you share us the print your Workspace?
Thanks,
Danilo
+20- Supporter
Hi @miguelbmahillo,
As @danilo_fme suggests, it looks like you're using a Dynamic Writer and pressing the Inspect shortcut from the Feature Type object:
Don't get confused by this error in FME Data Inspector, it just means the query is malformed, it doesn't mean your data is necessarily not written properly. FME Data Inspector is not able to process the query because the Writer doesn't specify the table name. If you open the dataset manually (File > Open Dataset) and set up the table you are writing to instead of using the shortcut you should be able to see whether FME has written it properly.
I hope this helps,
Francisco
+44- Evangelist
fgiron wrote:
Hi @miguelbmahillo,
As @danilo_fme suggests, it looks like you're using a Dynamic Writer and pressing the Inspect shortcut from the Feature Type object:
Don't get confused by this error in FME Data Inspector, it just means the query is malformed, it doesn't mean your data is necessarily not written properly. FME Data Inspector is not able to process the query because the Writer doesn't specify the table name. If you open the dataset manually (File > Open Dataset) and set up the table you are writing to instead of using the shortcut you should be able to see whether FME has written it properly.
I hope this helps,
Francisco
Hi @fgiron Thanks for endorsing!
Reply
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.