Skip to main content
Solved

Unable to update values in ArcSDE Geodatabase

  • June 13, 2024
  • 1 reply
  • 166 views
spalkar
Contributor
Forum|alt.badge.img

Hi All,

I am updating few values in ArcSDE Geodatabase (in flat table) using FME workbench but its giving an below error

error : Error while retrieving an ArcObjects update cursor for the table/feature class 'gis.xxx'. The error number from ArcObjects is: '-2147220652'. The error message from ArcObjects is: {}

  • Stack  : FME workbench 2021.1 , ArcSDE Geodatabase, Flat table ,MS Sql Server
  • Workbench screenshot : 
  • Error message : 

     

  • Feature writer properties
  • Till now tried below :
    • Using SQL query its possible to update values in SQL management studio with sde use
    • SDE user has privilege to insert/modify/delete 
    • Workbench has proper permissions to run it
    • Using ArcPro Standard licenses 
    • If we truncate then its truncate the table 
    • Since we are using flat table still use geometry remover to remove additional geometry 
    • Flat table has valid primary key 
       

Any help/inputs/suggestions would be great !!!
thanks in advance !!

Best answer by hkingsbury

Can you update/add rows to that table via ArcGIS?

If its just a flat table and doesn’t have versioning or archiving on it, it will be much faster to write directly to SQL rather than via SDE

danilo_fme
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.

1 reply

hkingsbury
Celebrity
Forum|alt.badge.img+65
  • hkingsburyCelebrity
  • Celebrity
  • Best Answer
  • June 13, 2024

Can you update/add rows to that table via ArcGIS?

If its just a flat table and doesn’t have versioning or archiving on it, it will be much faster to write directly to SQL rather than via SDE

spalkar

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.