Geoprocessing tool eror

Question

Hello.

When I run the append tool on a versioned SDE GDB, I get the error:

"The user must be the table owner".

Anyone have an idea what that means and how to fix it?

PaulDelaney2 · Answer

The Append tool needs to be run as the table owner from what I understand. This is because by default it recreates the spatial index. I found you can get around this by ticking the "Maintain Spatial Index" setting in Environment Settings (under Geodatabase Advanced in 10.2.2).

In .NET:

Geoprocessor gp = new Geoprocessor();
gp.SetEnvironmentValue("maintainSpatialIndex", "TRUE");

You can then run the tool using OSA or any other authorised user that is not the table owner, and you don't need an exclusive lock.

BrianBehling · Answer

Looks like it was a problem with the user account I was logging in with. The SDE DBA advised me to login as a different user, which is a super user type of account, and the append tool works now.

T__WayneWhitley · Answer

One more thing that may help, there is a Desktop webhelp topic depending on the DBMS 'flavor' you're using - this one's for SQL Server:

http://resources.arcgis.com/en/help/main/10.1/index.html#/Granting_and_revoking_privileges_on_datasets/002q0000002z000000/