Skip to main content
Solved

Unable to insert data into an existing file geodatabase table with "Truncate Existing" setting

  • February 28, 2018
  • 2 replies
  • 130 views
dilipsebastian
Forum|alt.badge.img

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"

Best answer by lottegis

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

2 replies

lottegis
Forum|alt.badge.img+1
  • lottegis
  • Best Answer
  • February 28, 2018

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"
dilipsebastian
Forum|alt.badge.img

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.

 

 

Community Stats

32,154
Posts
122,048
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.