Skip to main content
Solved

Update of database deletes values of other fields

  • May 10, 2017
  • 8 replies
  • 29 views
clemensb
Contributor
Forum|alt.badge.img+5

Hi,

i have a workspace which reads a featureclass from ArcSDE with MSSQL Server 2012 with many fields, where one field is named “Post_Processing_Status”. I validate and check the data, do some calculations and create a csv from the data. Is the data from the feature class not valid I update the field “Post_Processing_Status” with the value “mangelhaft” or when it’s OK with “MNA” (originally “erfasst” is in Post_Processing_Status) and write it to the featureclass in the SQL Server.

However when I check the data, the value for Post_Processing_Status is written, but in some rows other field values are now missing, they are filled with blanks. In the original all fields were filled with values.

My procedure is I delete with an AttributeManager all other Attributes, except the OBJECTID and the Post_Processing_Status assign the value “mangelhaft” or “MNA” and link it to an Esri Geodatabase (ArcSDE Geodb) writer with the configuration “UPDATE”, the Transaction Type is set to “Transactions”.I cannot reproduce this error, sometimes it happens, sometimes not. 99% of all data is correct, but some values are deleted.

Anybody knows something, why are some fields now filled with blanks?

Thanks for your help

I use FME Desktop 2016.1.3.0 to create the workspace and is executed by FME Server 2016.1.3.1

Best answer by david_r

It does seem like you have configured your output feature type correctly, so it should work as it is. But since it doesn't give you the results you expect, there is a slight chance that it's a bug somewhere. I'd still try to use a DatabaseUpdater and see if the problem is still there, if so it's probably something else. If the problem disappears it might be time for opening a ticket with Safe.

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.

8 replies

david_r
Celebrity
  • david_rCelebrity
  • May 10, 2017

All the attributes defined on the output feature type will be updated, missing attributes will be interpreted as NULL.

I recommend using either the DatabaseUpdater or the SQLExecutor transformer for your scenario.

itay
Supporter
Forum|alt.badge.img+18
  • itaySupporter
  • Supporter
  • May 10, 2017

Beside deleting the attributes going INTO the writer feature type try removing them FROM the writer feature type to make sure that no other attributes are affected, than the ones you want to update

clemensb
Contributor
Forum|alt.badge.img+5
  • clemensbContributor
  • Author
  • Contributor
  • May 11, 2017

@itay @david_r Thanks for your Input but in my writer only OBJECTID and Post_Processing_Status is defined. So the other attributes shouldnt be affected or am I miss interpreting something?

david_r
Celebrity
  • david_rCelebrity
  • Best Answer
  • May 11, 2017

It does seem like you have configured your output feature type correctly, so it should work as it is. But since it doesn't give you the results you expect, there is a slight chance that it's a bug somewhere. I'd still try to use a DatabaseUpdater and see if the problem is still there, if so it's probably something else. If the problem disappears it might be time for opening a ticket with Safe.

clemensb
Contributor
Forum|alt.badge.img+5
  • clemensbContributor
  • Author
  • Contributor
  • May 11, 2017

It does seem like you have configured your output feature type correctly, so it should work as it is. But since it doesn't give you the results you expect, there is a slight chance that it's a bug somewhere. I'd still try to use a DatabaseUpdater and see if the problem is still there, if so it's probably something else. If the problem disappears it might be time for opening a ticket with Safe.

I also think it's kind of a bug. This was driving me nuts. I will try the DatabaseUpdater, thank you David

 

 

 

david_r
Celebrity
  • david_rCelebrity
  • May 11, 2017
I also think it's kind of a bug. This was driving me nuts. I will try the DatabaseUpdater, thank you David

 

 

 

I can't for the life of me remember the details right now, but I'm pretty sure I've seen some buggy behavior that was very similar to your case. Might be worth contacting Safe support for confirmation, though.
itay
Supporter
Forum|alt.badge.img+18
  • itaySupporter
  • Supporter
  • May 11, 2017

@itay @david_r Thanks for your Input but in my writer only OBJECTID and Post_Processing_Status is defined. So the other attributes shouldnt be affected or am I miss interpreting something?

No, I would contact Safe about this or use the DatabaseUpdater or a SQL statement as advised.

 

 

fmelizard
Safer
Forum|alt.badge.img+21
  • fmelizardSafer
  • Safer
  • May 12, 2017

We are currently investigating this. I'll be sure to post an update once we have more information or a resolution.

Community Stats

32,154
Posts
122,047
Replies
39,812
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.