I am updating a SQL Server database in FME Desktop 2015. My process runs successfully without error messages but nothing is actually written to the database (the log shows 125 features written). I am using fme_db_operation as the feature operation and the ID field as the match column. I don't know a whole lot about SQL, what am I missing here?
Question
Can't write to SQL server
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.
What is the value of fme_db_operation? If it is INSERT, the feature is always written, but if it is UPDATE or DELETE it will all depend on if the value of the ID field is found in the existing data. If no value of that particular ID is found, nothing happens.
+6- Contributor
False alarm, the table is being updated but due to extra rows, it didn't seem like it.
Login to the community
No account yet? Create an account
An FME Account is required to contribute
LoginEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.