topic Re: FileGDBException: The user does not have permission to execute the operation. in File Geodatabase API Questions

FileGDBException: The user does not have permission to execute the operation.

PrzemyslawTyrtania — Mon, 17 Nov 2014 13:08:08 GMT

I'm getting this error when trying to execute table.Delete(row), the error is thrown on the first row. There are many tables in this file geodatabase so I've tried with different ones for some tables it works and for others it doesn't. These are all standalone tables, no relationships, editor tracking is not on. File geodatabase is generated from a 10.2.2 geodatabase. This table has a few fields and the only field that stands out is Settings which is defined as nvarchar(max) in geodatabase.

Fields:

ObjectID

Name: text 255

Settings: text 1073741822

ModifiedTime: date

Version: Text 255

SettingsType: Text 255

RowCollection rowCollection = table.Search("*", whereClause, RowInstance.Unique);

foreach (Row row in rowCollection)

{

table.Delete(row);

}

Re: FileGDBException: The user does not have permission to execute the operation.

VinceAngelo — Mon, 17 Nov 2014 16:25:18 GMT

So the obvious question is: What is different about the tables on which Delete is permitted from those on which it is not? Are there filesystem permission issues? Are you sure there isn't any non-simple aspect to the tables? What does Table::IsEditable report?

- V

Re: FileGDBException: The user does not have permission to execute the operation.

PrzemyslawTyrtania — Mon, 17 Nov 2014 16:41:55 GMT

Thanks for quick reply. So to answer your questions, I've been looking at different tables and i don't see anything different, of course i maybe overlooking something or not looking in the right places, BUT IsEditable is returning FALSE, so that is big hint, can you tell me what controls that flag? Code that generates this file geodatabase is a python script, it connects to geodatabase with account that has owner permissions and does this for each table:

source_db = "\\\\" + hostname + "\\Deployment\\Connection.sde"

arcpy.env.workspace = source_db

items = arcpy.ListTables()

for sourceItem in items:

targetItem = string.split(sourceItem, ".")[len(string.split(sourceItem, "."))-1]

target = target_db + "\\" + targetItem

source = source_db + "\\" + sourceItem

arcpy.Copy_management(source, target, "Table")

I can add screenshots from ArcCatalog if you think its helpful

Re: FileGDBException: The user does not have permission to execute the operation.

LanceShipman — Mon, 17 Nov 2014 17:06:34 GMT

The API will not allow the edit of table or feature classes involved in Annotation and Dimension feature classes, Relationship Classes, Networks (GN and ND), Topologies, Terrains, Representations, Parcel Fabrics and Edit Tracked tables/feature classes.

Screen shots showing the content of the file geodatabase would be helpful.

Regards,

Lance Shipman

Re: FileGDBException: The user does not have permission to execute the operation.

PrzemyslawTyrtania — Mon, 17 Nov 2014 18:20:07 GMT

If there is something else i can look at please let me know.

Re: FileGDBException: The user does not have permission to execute the operation.

PrzemyslawTyrtania — Mon, 17 Nov 2014 18:20:55 GMT

I don't think this table is involved in any of these, I've posted some screenshots.

Re: FileGDBException: The user does not have permission to execute the operation.

VinceAngelo — Mon, 17 Nov 2014 18:28:11 GMT

It's hard to tell, but it seems those screenshots are from the enterprise geodatabase, not from the FGDB itself.

- V

Re: FileGDBException: The user does not have permission to execute the operation.

PrzemyslawTyrtania — Mon, 17 Nov 2014 18:33:09 GMT

Screenshots from fgdb are pretty much the same:

Re: FileGDBException: The user does not have permission to execute the operation.

LanceShipman — Mon, 17 Nov 2014 19:01:21 GMT

Can you post screen shots of the contents of the file geodatabase.

Re: FileGDBException: The user does not have permission to execute the operation.

PrzemyslawTyrtania — Mon, 17 Nov 2014 19:03:41 GMT

its a lot of stuff

Re: FileGDBException: The user does not have permission to execute the operation.

LanceShipman — Mon, 17 Nov 2014 19:11:02 GMT

1) Create a new file geodatabase with ArcGIS Desktop.

2) Copy/Paste the table to the new file geodatabase.

3) Examine the results.

Re: FileGDBException: The user does not have permission to execute the operation.

VinceAngelo — Mon, 17 Nov 2014 19:11:26 GMT

Better to get a portion of that screenshot which is legible than to get everything. It's the icons associated with objects that Lance is trying to see.

- V

Re: FileGDBException: The user does not have permission to execute the operation.

PrzemyslawTyrtania — Mon, 17 Nov 2014 19:21:19 GMT

Yea, that works, we deleted the table from FGDB, copy paste from geodatabase and it worked fine, but this FGDB is created daily by our py script so its not a solution.

Re: FileGDBException: The user does not have permission to execute the operation.

PrzemyslawTyrtania — Mon, 17 Nov 2014 19:25:17 GMT

if all you're trying to see is if there is a relationship to the table then i can tell you that there is not, otherwise you'd see that in relationships tab, but below is a screenshot that is sorted by type that shows all relationships and another one showing the table

Re: FileGDBException: The user does not have permission to execute the operation.

LanceShipman — Mon, 17 Nov 2014 20:27:14 GMT

It's not being proposed as a solution. At this point we are still trying to understand what is happening. Without having a local reproducible case it is hard to diagnose isuse like this. Copy/Paste is very good at finding relationships.

Was the table previously part of relationship class or network or topology? If you copy/paste from the original non-file geodatabase to a new file geodatabase what do you get?

Re: FileGDBException: The user does not have permission to execute the operation.

VinceAngelo — Tue, 18 Nov 2014 03:34:39 GMT

When you work out how to get IsEditable to return true, you might want to try to truncate the table using Geodatabase::ExecuteSQL with "DELETE FROM tablename" without a WHERE clause or spatial constraint. It will likely be much faster than iterating the rows in an unbounded query and deleting each.

- V

Re: FileGDBException: The user does not have permission to execute the operation.

PrzemyslawTyrtania — Wed, 19 Nov 2014 12:59:38 GMT

So we deleted everything from the sde database except the table in question and created fgdb from it and it still failed with same error, then we created new PGDB and exported the table to that database, then delete futura_settings table from sde then copied it from pgdb to sde and then exported to fgdb then it worked fine.

Re: FileGDBException: The user does not have permission to execute the operation.

VinceAngelo — Wed, 19 Nov 2014 13:50:49 GMT

So it sounds like your enterprise geodatabase metadata was corrupt, and that was passed through to the FGDB by Copy_management, so the API was seeing the table as non-simple. Once the table really was simple, then IsEditable returned true, and you were able to delete. If you have a copy of the data in its corrupt state, I expect Tech Support would want to look at it.

- V

Re: FileGDBException: The user does not have permission to execute the operation.

PrzemyslawTyrtania — Wed, 19 Nov 2014 14:09:00 GMT

I was going to attach the databases to the message but I'd prefer something more secure so if you can email me and provide me with a way to upload then i'll do that, total size of the files is about 12 mb so I don't think I can attach to the email: przemyslawt@futuragis.com

Re: FileGDBException: The user does not have permission to execute the operation.

PrzemyslawTyrtania — Wed, 19 Nov 2014 14:10:13 GMT

thanks for your help!