Skip to main content
Question

Provider error `(-2147217865) Invalid object name


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.

3 replies

danilo_fme
Evangelist
Forum|alt.badge.img+44
  • Evangelist
  • March 31, 2019

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

 


fgiron
Supporter
Forum|alt.badge.img+20
  • Supporter
  • March 31, 2019

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

danilo_fme
Evangelist
Forum|alt.badge.img+44
  • Evangelist
  • March 31, 2019
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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings