Latest Contributions by BrianSullivan

I ran into this too. My first solution was to split out the processing to a first script that walked the directories to find MXDs and then used subprocess.Popen to call second script that accepted the MXD path as an argument . This way the script doing the processing would only run one MXD and then close. The downside is that I had to wait for arcpy to import on every single one, and for 1100 MXDs that adds up. I'm not 100% sure why the error occurs when you run more than one MXD but I think that replaceDataSource() eats up the connection pool to the target SDE. After processing an MXD or two you can't connect to it any more. The solution is to reset the SDE connection with arcpy.ClearWorkspaceCache_management(). You also should delete the reference to your mxd object first. A simplified example of your code would look like: for dirName, subdirList, fileList in os.walk(source_dir):     for fname in fileList:         if fname.endswith(".mxd")                 mxd = arcpy.mapping.MapDocument(os.path.join(dirName,fname))                 for lyr in arcpy.mapping.ListLayers(mxd):                         if not lyr.supports("DATASOURCE"):                            continue                         if "\GIS Data\Arc Layers\Example.shp" in lyr.dataSource:                              newPath = r"Database Connections\SDEConnection.sde"                              newSource = "Example"                              try:                                  print "Replacing data source of " + lyr.name                                  lyr.replaceDataSource(newPath,'SDE_WORKSPACE', newSource)                              except Exception, e:                                  print e                 del mxd                 arcpy.ClearWorkspaceCache_management(r"Database Connections\SDEConnection.sde") ... View more