nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

ArcGIS desketop 10.3 breaks Python script...

vscott1

Argh! I use Python scripts to run my routine and adhoc SDE data updates that I get from our users. I made the mistake of upgrading to ArcGIS Desktop 10.3 before testing out my scripts. (Not to worry, I still have 10.2.1 on a virtual desktop!) When I went to run a script to perform routine SDE updates with the 10.3 version, the script crashed at my "change privileges" section

I found that I could modify the script and assign privileges "individually" instead of the existing "batch" mode. Wait . . . I have a poop-load of SDE Python data maintenance scripts! Now I have to go in and modify ALL my scripts! (see above profile picture)

After reporting this to ESRI support, it was reproduced on their end and a bug fix will be forthcoming. (I don't have the bug # or est. date of fix yet.) In the mean time instead of modifying ALL my scripts, I will use my virtual machine to perform the updates . . . under protest!

I don't know how many others out there use the Python script code - "Change Privileges", so I thought I'd pass this information along . . .

Broken code: arcpy.ChangePrivileges_management(GISADM_B_D, "SDESEL, GISAPP, WSDSEL", "GRANT", "")

Replaced w: arcpy.ChangePrivileges_management(GISADM_B_D, "SDESEL", "GRANT", "")

arcpy.ChangePrivileges_management(GISADM_B_D, "GISAPP", "GRANT", "")

arcpy.ChangePrivileges_management(GISADM_B_D, "WSDSEL", "GRANT", "")

Find more posts tagged with

Accepted answers

All comments

vscott1

Michael,

We use the connections from a network share as opposed to where the Arcxxx software is installed and individual users have unique connections. We have a very convoluted architecture that (surprisingly) actually works well for us.

The issue is in the "arcpy.ChangePrivileges_management" function. It only works for single assignment of users/roles and not batch assignment.

Thanx!

mvolz47

Venus:

Can you provide more of the code?

I think the issue might be the path to the SDE connection file that is being used in the script. I found that an mxd where I had paths to SDE had to include the full path to the SDE connection file at v10.2.x. In 10.3 when I performed the Set Data Source on an mxd in ArcCatalog, I changed the SDE connection to the full path, but when the connection was saved it just said "Database Connections\SDE_USER on SDE DEFAULT.sde" instead of "C:\Users\SDE_User\AppData\Roaming\ESRI\Desktop10.3\ArcCatalog\SDE_USER on SDE DEFAULT.sde". Prior to v10.2, SDE connection files could be sourced as "Database Connections\SDE_USER on SDE DEFAULT.sde", so it appears that ESRI is reverting back to that format.

vscott1

Thanks Susan! I'll check it out!

SusanJones

The path to Python Home variable has changed,

The existing environment variable is probably still looking at the last arcpy version.

RebeccaStrauch__GISP

Thanks for sharing. I haven't hit this problem yet, but most likely will.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.