Skip to main content

Hello ,

I need a help 

I successfully updated a point geometry in the ArcSDE writer within a specific version.

 

I encountered an issue.

When I select "Update Mode" and set "Row selection - Columns " to ObjectID, I get an error translation  running  . But if I leave "Row seletion - Columns" empty, the translation runs successfully.

 

The "Row selection - Columns " field turns red when left empty, and I’m unable to click "OK." To work around this, I temporarily set "Row Selection - Columns" to ObjectID, click "OK," and then use a Remover transformer before the writer to remove ObjectID—and when I run the workspace ,it  works great and translation is successfully .

 

But ’m unclear on how FME identifies the correct point to modify it ,how to resolve my issue ?

 

Update Spatial columns : Should be yes or no ?

FME version: 2021, 64-bit.

Thanks in advance

Transaltion successful when I remove all attributes before writer ,even writer has red field 

 

but if I let objectid or other unique id , I got error running translation .

how to fix it ?

 

 


Hi, @jokerfme.

Thanks for posting your question.

Reading your question here, we have a few suggestions.

  1. If you are wanting to update the geometry, the Update Spatial Columns should be set to Yes
  2. If the Match Columns parameter is the issue, a quick solution could be to try using the WHERE clause option. You could use the ObjectID there ("ObjectID" = @Value(OBJECTID))
  3. If you want to stick with just the Match Columns parameter, ensure the case matches.

If these don’t work out, we would like to request your workspace. It’ll assist problem solving the issue. Hope this helps!

Thanks!


Reply