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

Question

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"

icon

Best answer by lottegis 28 February 2018, 21:06

View original

lottegis · Accepted Answer

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" insteadUse a FeatureWriter to perform delete then a second writer to perform the insert with "Create If Needed" or "Use Existing"

dilipsebastian · Answer

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.

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

2 replies

Reply

Community Stats

Reply

Community Stats

Sign up

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute

Scanning file for viruses.

This file cannot be downloaded