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; } } }

findAndReplaceWorkspacePaths is crashing Python script

WaiChan1

I am trying to change the layers data source in a map document, from the current SDE connection to the new SDE connection, using Python. I had used the example given in the ArcGIS Desktop Help 10.0 (http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//00s30000004p000000), but the script keep crashing when it gets to the mxd.findAndReplaceWorkspacePaths line.

Here is the code. Any suggestion will be greatly appreciated. Thank you.

import arcpy
mxd = arcpy.mapping.MapDocument(r"I:\RepointMXD.mxd")
mxd.findAndReplaceWorkspacePaths(r"I:\current_sde.sde", r"I:\new_sde.sde")
mxd.saveACopy(r"I:\RepointMXD_new.mxd")
del mxd

Finde mehr Beiträge mit dem Tag

Accepted answers

All comments

JoeFlannery

Mr. Chan: Good question. My sample for testing, described in earlier posts, was using two file geodatabases (SQL01 & SQL02). Sorry for the confusion. I have not tried it against real SQL geodatabases, yet.

WaiChan1

jrflannery,

For the oldSDE and newSDE parameters, I thought they were supposed to be sde connection files (*.sde). What connection files are SQL01 and SQL02?

Thank you!

JoeFlannery

I can confirm that findAndReplaceWorkspacePaths script does run with image/background services in the map TOC in ArcGIS for Desktop version 10.1.
See: http://forums.arcgis.com/threads/60553-Find-and-Replace-Workspace-Path-not-working?highlight=findAndReplaceWorkspacePaths

However, I am getting the same results as Wai Chan. The script completes, but does NOT change the file paths to geodatabases.

import arcpy, os

# Local variables
oldSDE = r"M:\Clients\M-O\ABC\_ArcGIS\2012\06\TestingRepath\SQL01\\"
newSDE = r"M:\Clients\M-O\ABC\_ArcGIS\2012\06\TestingRepath\SQL02\\"
mapDoc = r"M:\Clients\M-O\ABC\_ArcGIS\2012\06\TestingRepath\_Map02_wBackgrounds.mxd"

print "Define MapDocument Parameter"
mxd = arcpy.mapping.MapDocument(mapDoc)

print "Start FindAndReplace Process"
mxd.findAndReplaceWorkspacePaths(oldSDE, newSDE)

print "Start saveAcopy Process"
mxd.saveACopy(r"M:\Clients\M-O\ABC\_ArcGIS\2012\06\TestingRepath\_Map02_NEW_TenOne.mxd")

print "Done"

del arcpy, oldSDE, newSDE, mapDoc, mxd

UPDATE - found the problem
I removed the "\\" at the ends of the oldSDE and newSDE variable file paths and now the repath script works.

WaiChan1

Thank you for pointing that out. I took out the image service, and the script ran with no problem. However, it did not replace the SDE workspace in the layer files, like it's supposed to do. The layers in the new MXD still points to the current SDE.

RyanForbes1

What service pack are you using? If you're still pre 4 you could try updating.

Do you have an image service layer? I found evidence that findAndReplaceWorkspacePath will crash if there is an image service layer -- ( http://support.esri.com/en/bugs/nimbus/TklNMDYwMzE1 ) not sure if it is related or if it was ever fix't.

WaiChan1

I am using Windows 7 64-bit. After running the code, all it gives is a standard "PyWin 32 has stopped working." message, with the options to close the program or debug the program. Either option will make Python closes itself.

RyanForbes1

Does it hard crash or does it provide you with some kind of error?

Nimm an der Unterhaltung teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Anmelden
Registrieren

Schnellzugriffe

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