Skip to main content
Solved

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

  • February 28, 2018
  • 2 replies
  • 70 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"
View original
Did this help you find an answer to your question?

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
lottegis wrote:

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


Helpful Members This Week

Community Stats

31,183
Posts
118,190
Replies
38,794
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.