Skip to main content
Solved

Error writing to Geodatabase with a Relationship ATTACHMENT table

  • December 2, 2015
  • 8 replies
  • 469 views
R
Forum|alt.badge.img

I'm have the following error:

An error occurred while attempting to open an insert cursor on the table 'SurveyedGeneralLawn'. The error number from ArcObjects is: '-2147216556'. The error message from ArcObjects is: {Objects in this class cannot be updated outside an edit session [GisGeoDbMaint.ASSET.SurveyedGeneralLawn]}

It seems to be with a relationship class with attachment TABLE. When i remove the relationship it work fine. I only want to insert records into the feature class and the attachment table. I using an Arcpy truncate function as a startup script.

I've looked at previous post regarding this matter, but it don't seem to work for me.

Using FME 2014 - SP4

Rudy

Best answer by rudy_v

This is now solved with the new transaction type on the writer Non-versioned Edit Session

using 2016.1

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

8 replies

pratap
Contributor
Forum|alt.badge.img+11
  • pratapContributor
  • Contributor
  • December 3, 2015

Hi,

In the parameters of the writer in navigator, select 'Edit session" instead of "Transactions" in "Transaction Type" as shown in the screenshot below...

Please check whether geodatabase is locked by other application or not as well if so then close that application as well.

Pratap

R
Forum|alt.badge.img
  • rudy_u2
  • Author
  • December 3, 2015

That option is not available in my version of FME desktop.

I've over 100 scripts that truncate and append Geodatabases(none of them are versioned), everything works fine, it is only with Relationship class with ATTTACHMENTS, FME Fails

I've tried - VERSIONING option - also doe s not work, because the dataset is not versioned, and don't need to be, because a few other Feature Classes in this dataset works fine (with truncate and insert)

pratap
Contributor
Forum|alt.badge.img+11
  • pratapContributor
  • Contributor
  • December 3, 2015

Which version are you using?

blueinc
Contributor
Forum|alt.badge.img+6
  • blueincContributor
  • Contributor
  • December 4, 2015

I have also experienced this when the feature class I am trying to insert records to participates in a topology. Even when I set the Transaction Type to 'Edit Session', ArcObject throws the error in question BUT if I remove the topology and then run the script: presto! The data loads fine. I re-add the topology with the same rules afterward and validate it.

It seems that ArcObjects objects to (ha! I mean 'complains about') any kind of relationship, not just relationship tables.

rudy_v
Contributor
Forum|alt.badge.img+6
  • rudy_vContributor
  • Contributor
  • Best Answer
  • June 10, 2016

This is now solved with the new transaction type on the writer Non-versioned Edit Session

using 2016.1

A
  • Anonymous
  • December 7, 2016
pratap wrote:

Which version are you using?

I am having this problem, even though I set the Transaction Type to both non-version edit session and versioned edit session (it is not a versioned database, however).

 

 

My FME is 20161.2, build 16664 and my geodatabase is SQL Server 2016. The feature class participates in a geometric network, and when I removed it from the network I was able to insert with Transaction Type: Transactions. However, eventually it needs to be part of the geometric network.

 

 

Has there been any more work done on this issue by Safe?

 

 

boerss
Contributor
Forum|alt.badge.img+3
  • boerssContributor
  • Contributor
  • December 13, 2023

Same problem here. Ik want to update features in a fgdb and have opted for 'edit session'on the writer, but still get the message that data cannot be updated outside an edit session. Once I remove the relationship in ArcGIS pro, writing does work suddenly.

rudy_v
Contributor
Forum|alt.badge.img+6
  • rudy_vContributor
  • Contributor
  • December 14, 2023
boerss wrote:

Same problem here. Ik want to update features in a fgdb and have opted for 'edit session'on the writer, but still get the message that data cannot be updated outside an edit session. Once I remove the relationship in ArcGIS pro, writing does work suddenly.

Hi @boerss​ 

 

I write a lot to GeoDatabase with attachment, you cannot select edit session, if the Dataset is not versioned. Use non-versioned edit session. But I will it a check into FileGeoDb - as we don't use that a lot - maybe a few times a year. Only GeoDatabase

 

Rudy

Reply


Helpful Members This Week

Community Stats

30,907
Posts
117,109
Replies
38,708
Members

Latest FME

Terms & ConditionsCookie settings

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