Skip to main content
Question

ArcObject Error while inserting rows in a feature class


fme_can_do_it
Enthusiast
Forum|alt.badge.img+11

Hi, I am getting this error:

An error occurred while attempting to insert a row into the table ‘ABC’ using a cursor. The error number from ArcObjects is: '-2147217323'. The error message from ArcObjects is: {The cursor has been invalidated by an edit operation.}

 

I am experiencing an issue when trying to insert features into a feature class stored in an enterprise geodatabase. Specifically, I am both reading from and writing to the same dataset. I haven't encountered this problem before, but it began after I set the Feature Operations to "Upsert" while updating existing records and inserting new records that are not yet present in the database. I suspect that performing inserts and updates simultaneously may be causing a disruption with the cursor. I also attempted to use the Feature holder, but I received the same error. This disruption is affecting the automated process. Does anyone know what might be causing this error or how to fix it? I would greatly appreciate any assistance!

Thank you!

2 replies

j.botterill
Influencer
Forum|alt.badge.img+40
  • Influencer
  • May 16, 2025

The UPSERT is only supported in SDE Geodatabase after more recent versions. https://support.safe.com/hc/en-us/articles/25407724093837-Notes-on-FME-and-Esri-Versions-and-Compatibility Also ensure the FME version matches your ESRI install version

Does the SDE gdb version match the desktop version, that is compatible with the FME version! You can find this out by https://support.esri.com/en-us/knowledge-base/faq-how-to-locate-the-version-number-of-an-enterprise-g-000023208

Here is the upgrade process https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/upgrade-geodatabase.htm Before you upgrade an enterprise geodatabase, you must perform the preparatory steps needed for the database management system you are using, including creating a backup of the database

Lastly researching this error within FME context, some articles refer to: Corruption in the SDE Registry. Solution: Delete the faulted objects with ArcCatalog


fme_can_do_it
Enthusiast
Forum|alt.badge.img+11

@j.botterill Thank you for your response! The SDE GDB version matched the FME version, so the only thing I can think of is corruption in the SDE registry, which I am not sure how to check. 

Also, after encountering this error, I ran the workspace at the transformer where it failed, and it passed the features and inserted records this way. Every time, only the same feature class has this issue.


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