Skip to main content

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.

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

 


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 @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