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.
Question
Provider error `(-2147217865) Invalid object name
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.
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.
+51- Celebrity
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
+25- 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
+51- Celebrity
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!