Skip to main content
Solved

Unable to update values in ArcSDE Geodatabase

  • June 13, 2024
  • 1 reply
  • 98 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

View original
Did this help you find an answer to your question?

1 reply

hkingsbury
Celebrity
Forum|alt.badge.img+53
  • 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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings