Skip to main content
  • EN
  • Home
  • Forums
  • FME Form
  • Data
  • Unable to insert data into an existing file geodatabase table with "Truncate Existing" setting

I am trying to create a workflow that would update an existing table in a file geodatabase. It works when i have feature operation set to "Insert" and Table Handling set to "Create If needed" under Format Parameters. When I try to change the Table Handling setting to "Truncate Existing", the workflows fails and errors out

Error:

"Geodatabase Error (-2147220987): The user does not have permission to execute the operation.

FileGDB Writer: A feature could not be written"

I vaguely recall encountering the same issue. I had to work around it. Try either of these methods.

  • Set Table Handling to "Drop and Create" instead
  • Use a FeatureWriter to perform delete then a second writer to perform the insert with "Create If Needed" or "Use Existing"

I vaguely recall encountering the same issue. I had to work around it. Try either of these methods.

  • Set Table Handling to "Drop and Create" instead
  • Use a FeatureWriter to perform delete then a second writer to perform the insert with "Create If Needed" or "Use Existing"
The second option didn't work for me. I ended up changing my setting to drop and create, although thats not what I wanted to do. My output table is related to another table through a relationship class. Drop and create breaks this relationship class.

 

 

Reply


Community Stats

30,108
Posts
114,283
Replies
37,742
Members
Terms & ConditionsCookie 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.