topic Re: findAndReplaceWorkspacePaths is crashing Python script in Python Questions

findAndReplaceWorkspacePaths is crashing Python script

WaiChan1 — Wed, 18 Apr 2012 16:46:24 GMT

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

Re: findAndReplaceWorkspacePaths is crashing Python script

RyanForbes1 — Wed, 18 Apr 2012 16:50:30 GMT

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

Re: findAndReplaceWorkspacePaths is crashing Python script

WaiChan1 — Wed, 18 Apr 2012 17:41:09 GMT

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.

Re: findAndReplaceWorkspacePaths is crashing Python script

RyanForbes1 — Wed, 18 Apr 2012 17:53:50 GMT

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.

Re: findAndReplaceWorkspacePaths is crashing Python script

WaiChan1 — Wed, 18 Apr 2012 18:09:58 GMT

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.

Re: findAndReplaceWorkspacePaths is crashing Python script

JoeFlannery — Sat, 11 Dec 2021 06:05:29 GMT

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.

Re: findAndReplaceWorkspacePaths is crashing Python script

WaiChan1 — Mon, 10 Sep 2012 18:24:29 GMT

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!

Re: findAndReplaceWorkspacePaths is crashing Python script

JoeFlannery — Mon, 10 Sep 2012 19:22:29 GMT

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.