UPDATE: This woks fine for updating the source to Shapefiles but not for SDE feature classes! I am trying to use replaceDataSource by iterating through multiple map documents. My script updates the first map document but always fails on the second. So if I have map1.mxd, map2.mxd and map3.mxd it updates dataSources in map1 and fails on map2. Even if I put map2 through first (map1 2nd and map3 3rd) it will still fail on the 2nd iteration, so map1 fails in this instance. I am updating the source to SDE. The input csv is the output from another script that gets unique broken datasources. I then add a second column that matches the broken datasource to a new one import arcpy , csv , os import arcpy . mapping as m def updateDataSource ( datapath , broken_lyr ) : if datapath . endswith ( ".shp" ) : workspace_path = datapath . rsplit ( "\\" , 1 ) [ 0 ] workspace_type = "SHAPEFILE_WORKSPACE" dataset_name = datapath . rsplit ( "\\" , 1 ) [ - 1 ] [ 0 : - 4 ] elif datapath . find ( ".sde" ) != - 1 : workspace_path = datapath . rsplit ( ".sde" , 1 ) [ 0 ] + ".sde" workspace_type = "SDE_WORKSPACE" dataset_name = datapath . rsplit ( "\\" ) [ - 1 ] elif datapath . find ( ".gdb" ) != - 1 : workspace_path = datapath . rsplit ( ".gdb" , 1 ) [ 0 ] + ".gdb" workspace_type = "FILEGDB_WORKSPACE" dataset_name = datapath . rsplit ( ".gdb\\" ) [ - 1 ] print "\n" print workspace_path print workspace_type print dataset_name print "\n" if workspace_path : broken_lyr . replaceDataSource ( workspace_path , workspace_type , dataset_name , True ) else : print "Failed for {0} \n workspace is not FILEGDB, SDE, or SHAPEFILE" . format ( broken_lyr . name ) input_csv = r "C:\Users\glen.bambrick\Documents\csv\broken_links_20180523.csv" input_folder = r "C:\Users\glen.bambrick\Documents\mxd" broken_dict = { } broken_mxd_list = [ ] with open ( input_csv , 'rb' ) as read_csv : reader = csv . reader ( read_csv ) next ( reader , None ) for row in reader : if row : broken_dict [ row [ 0 ] ] = row [ 1 ] broken_mxd_list . append ( row [ 3 ] ) mxd_set = set ( [ ] ) for value in broken_mxd_list : for item in value . split ( ", " ) : mxd_set . add ( "{0}\\{1}" . format ( input_folder , item ) ) for key , value in broken_dict . iteritems ( ) : print key , value print "\n" print mxd_set for mapdoc in mxd_set : print "\n" print mapdoc mxd = m . MapDocument ( mapdoc ) list_broken = m . ListBrokenDataSources ( mxd ) if len ( list_broken ) == 0 : continue else : for broken in list_broken : if broken . supports ( "DATASOURCE" ) and broken_dict [ broken . dataSource ] : print "Updating: {0}" . format ( broken . dataSource ) print "\tTo: {0}" . format ( broken_dict [ broken . dataSource ] ) updateDataSource ( broken_dict [ broken . dataSource ] , broken ) mxd . save ( ) del mxd The output and the error. As you can see the same parameters are going in but it always fails on the first replaceDataSource() of the second iteration no matter what map document it is. If there is one mxd in the list it will do it just fine, but I want to loop through hundreds eventually. C : \Users\user1\AppData\Roaming\ESRI\Desktop10 .4 \ArcCatalog\N6 . sde\JN233985_GCOB . DBO . GCOB_03391_Beneficial_Deposition_1 Database Connections\Connection to GALSQL01 . sde\JN233985_GCOB . DBO . GCOB_03_Environmental\JN233985_GCOB . DBO . GCOB_03391_Beneficial_Deposition C : \Users\user2\AppData\Roaming\ESRI\Desktop10 .4 \ArcCatalog\Connection to GALSQL01 . sde\JN233985_GCOB . DBO . GCOB_03391_Beneficial_Deposition_1 Database Connections\Connection to GALSQL01 . sde\JN233985_GCOB . DBO . GCOB_03_Environmental\JN233985_GCOB . DBO . GCOB_03391_Beneficial_Deposition set ( [ 'C:\\Users\\glen.bambrick\\Documents\\mxd\\map2.mxd' , 'C:\\Users\\glen.bambrick\\Documents\\mxd\\map1.mxd' ] ) C : \Users\glen . bambrick\Documents\mxd\map2 . mxd Updating : C : \Users\user1\AppData\Roaming\ESRI\Desktop10 .4 \ArcCatalog\N6 . sde\JN233985_GCOB . DBO . GCOB_03391_Beneficial_Deposition_1 To : Database Connections\Connection to GALSQL01 . sde\JN233985_GCOB . DBO . GCOB_03_Environmental\JN233985_GCOB . DBO . GCOB_03391_Beneficial_Deposition Database Connections\Connection to GALSQL01 . sde SDE_WORKSPACE JN233985_GCOB . DBO . GCOB_03391_Beneficial_Deposition Updating : C : \Users\user2\AppData\Roaming\ESRI\Desktop10 .4 \ArcCatalog\Connection to GALSQL01 . sde\JN233985_GCOB . DBO . GCOB_03391_Beneficial_Deposition_1 To : Database Connections\Connection to GALSQL01 . sde\JN233985_GCOB . DBO . GCOB_03_Environmental\JN233985_GCOB . DBO . GCOB_03391_Beneficial_Deposition Database Connections\Connection to GALSQL01 . sde SDE_WORKSPACE JN233985_GCOB . DBO . GCOB_03391_Beneficial_Deposition C : \Users\glen . bambrick\Documents\mxd\map1 . mxd Updating : C : \Users\user1\AppData\Roaming\ESRI\Desktop10 .4 \ArcCatalog\N6 . sde\JN233985_GCOB . DBO . GCOB_03391_Beneficial_Deposition_1 To : Database Connections\Connection to GALSQL01 . sde\JN233985_GCOB . DBO . GCOB_03_Environmental\JN233985_GCOB . DBO . GCOB_03391_Beneficial_Deposition Database Connections\Connection to GALSQL01 . sde SDE_WORKSPACE JN233985_GCOB . DBO . GCOB_03391_Beneficial_Deposition Traceback ( most recent call last ) : File "C:\Users\glen.bambrick\Desktop\test.py" , line 65 , in module > updateDataSource ( broken_dict [ broken . dataSource ] , broken ) File "C:\Users\glen.bambrick\Desktop\test.py" , line 23 , in updateDataSource broken_lyr . replaceDataSource ( workspace_path , workspace_type , dataset_name , True ) File "C:\Program Files (x86)\ArcGIS\Desktop10.5\ArcPy\arcpy\utils.py" , line 182 , in fn_ return fn ( * args , ** kw ) File "C:\Program Files (x86)\ArcGIS\Desktop10.5\ArcPy\arcpy\_mapping.py" , line 682 , in replaceDataSource return convertArcObjectToPythonObject ( self . _arc_object . replaceDataSource ( * gp_fixargs ( ( workspace_path , workspace_type , dataset_name , validate ) , True ) ) ) ValueError : Layer : Unexpected error

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

replaceDataSource failing when iterating through multiple MXDs

Anonymous User

UPDATE: This woks fine for updating the source to Shapefiles but not for SDE feature classes!

I am trying to use replaceDataSource by iterating through multiple map documents. My script updates the first map document but always fails on the second. So if I have map1.mxd, map2.mxd and map3.mxd it updates dataSources in map1 and fails on map2. Even if I put map2 through first (map1 2nd and map3 3rd) it will still fail on the 2nd iteration, so map1 fails in this instance.

I am updating the source to SDE. The input csv is the output from another script that gets unique broken datasources. I then add a second column that matches the broken datasource to a new one

<SPAN class="keyword token">import</SPAN> arcpy<SPAN class="punctuation token">,</SPAN> csv<SPAN class="punctuation token">,</SPAN> os
<SPAN class="keyword token">import</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>mapping <SPAN class="keyword token">as</SPAN> m

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">updateDataSource</SPAN><SPAN class="punctuation token">(</SPAN>datapath<SPAN class="punctuation token">,</SPAN> broken_lyr<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> datapath<SPAN class="punctuation token">.</SPAN>endswith<SPAN class="punctuation token">(</SPAN><SPAN class="string token">".shp"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; workspace_path <SPAN class="operator token">=</SPAN> datapath<SPAN class="punctuation token">.</SPAN>rsplit<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"\\"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; workspace_type <SPAN class="operator token">=</SPAN> <SPAN class="string token">"SHAPEFILE_WORKSPACE"</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; dataset_name <SPAN class="operator token">=</SPAN> datapath<SPAN class="punctuation token">.</SPAN>rsplit<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"\\"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">elif</SPAN> datapath<SPAN class="punctuation token">.</SPAN>find<SPAN class="punctuation token">(</SPAN><SPAN class="string token">".sde"</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">!=</SPAN> <SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; workspace_path <SPAN class="operator token">=</SPAN> datapath<SPAN class="punctuation token">.</SPAN>rsplit<SPAN class="punctuation token">(</SPAN><SPAN class="string token">".sde"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">".sde"</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; workspace_type <SPAN class="operator token">=</SPAN> <SPAN class="string token">"SDE_WORKSPACE"</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; dataset_name <SPAN class="operator token">=</SPAN> datapath<SPAN class="punctuation token">.</SPAN>rsplit<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"\\"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">elif</SPAN> datapath<SPAN class="punctuation token">.</SPAN>find<SPAN class="punctuation token">(</SPAN><SPAN class="string token">".gdb"</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">!=</SPAN> <SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; workspace_path <SPAN class="operator token">=</SPAN> datapath<SPAN class="punctuation token">.</SPAN>rsplit<SPAN class="punctuation token">(</SPAN><SPAN class="string token">".gdb"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">".gdb"</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; workspace_type <SPAN class="operator token">=</SPAN> <SPAN class="string token">"FILEGDB_WORKSPACE"</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; dataset_name <SPAN class="operator token">=</SPAN> datapath<SPAN class="punctuation token">.</SPAN>rsplit<SPAN class="punctuation token">(</SPAN><SPAN class="string token">".gdb\\"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"\n"</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> workspace_path
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> workspace_type
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> dataset_name
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"\n"</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> workspace_path<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; broken_lyr<SPAN class="punctuation token">.</SPAN>replaceDataSource<SPAN class="punctuation token">(</SPAN>workspace_path<SPAN class="punctuation token">,</SPAN> workspace_type<SPAN class="punctuation token">,</SPAN> dataset_name<SPAN class="punctuation token">,</SPAN> <SPAN class="token boolean">True</SPAN><SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"Failed for {0} \n workspace is not FILEGDB, SDE, or SHAPEFILE"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>broken_lyr<SPAN class="punctuation token">.</SPAN>name<SPAN class="punctuation token">)</SPAN>

input_csv <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"C:\Users\glen.bambrick\Documents\csv\broken_links_20180523.csv"</SPAN>
input_folder <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"C:\Users\glen.bambrick\Documents\mxd"</SPAN>

broken_dict <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="punctuation token">}</SPAN>
broken_mxd_list <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>

<SPAN class="keyword token">with</SPAN> open<SPAN class="punctuation token">(</SPAN>input_csv<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'rb'</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> read_csv<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; reader <SPAN class="operator token">=</SPAN> csv<SPAN class="punctuation token">.</SPAN>reader<SPAN class="punctuation token">(</SPAN>read_csv<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; next<SPAN class="punctuation token">(</SPAN>reader<SPAN class="punctuation token">,</SPAN> None<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> reader<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> row<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; broken_dict<SPAN class="punctuation token">[</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; broken_mxd_list<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">3</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>

mxd_set <SPAN class="operator token">=</SPAN> set<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">for</SPAN> value <SPAN class="keyword token">in</SPAN> broken_mxd_list<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> item <SPAN class="keyword token">in</SPAN> value<SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="string token">", "</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; mxd_set<SPAN class="punctuation token">.</SPAN>add<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"{0}\\{1}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>input_folder<SPAN class="punctuation token">,</SPAN> item<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">for</SPAN> key<SPAN class="punctuation token">,</SPAN> value <SPAN class="keyword token">in</SPAN> broken_dict<SPAN class="punctuation token">.</SPAN>iteritems<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> key<SPAN class="punctuation token">,</SPAN> value

<SPAN class="keyword token">print</SPAN> <SPAN class="string token">"\n"</SPAN>
<SPAN class="keyword token">print</SPAN> mxd_set

<SPAN class="keyword token">for</SPAN> mapdoc <SPAN class="keyword token">in</SPAN> mxd_set<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"\n"</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> mapdoc
&nbsp;&nbsp;&nbsp; mxd <SPAN class="operator token">=</SPAN> m<SPAN class="punctuation token">.</SPAN>MapDocument<SPAN class="punctuation token">(</SPAN>mapdoc<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; list_broken <SPAN class="operator token">=</SPAN> m<SPAN class="punctuation token">.</SPAN>ListBrokenDataSources<SPAN class="punctuation token">(</SPAN>mxd<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> len<SPAN class="punctuation token">(</SPAN>list_broken<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">==</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">continue</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> broken <SPAN class="keyword token">in</SPAN> list_broken<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> broken<SPAN class="punctuation token">.</SPAN>supports<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"DATASOURCE"</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">and</SPAN> broken_dict<SPAN class="punctuation token">[</SPAN>broken<SPAN class="punctuation token">.</SPAN>dataSource<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"Updating: {0}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>broken<SPAN class="punctuation token">.</SPAN>dataSource<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"\tTo: {0}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>broken_dict<SPAN class="punctuation token">[</SPAN>broken<SPAN class="punctuation token">.</SPAN>dataSource<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; updateDataSource<SPAN class="punctuation token">(</SPAN>broken_dict<SPAN class="punctuation token">[</SPAN>broken<SPAN class="punctuation token">.</SPAN>dataSource<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> broken<SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp; mxd<SPAN class="punctuation token">.</SPAN>save<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">del</SPAN> mxd
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

The output and the error. As you can see the same parameters are going in but it always fails on the first replaceDataSource() of the second iteration no matter what map document it is. If there is one mxd in the list it will do it just fine, but I want to loop through hundreds eventually.

C<SPAN class="punctuation token">:</SPAN>\Users\user1\AppData\Roaming\ESRI\Desktop10<SPAN class="number token">.4</SPAN>\ArcCatalog\N6<SPAN class="punctuation token">.</SPAN>sde\JN233985_GCOB<SPAN class="punctuation token">.</SPAN>DBO<SPAN class="punctuation token">.</SPAN>GCOB_03391_Beneficial_Deposition_1 Database Connections\Connection to GALSQL01<SPAN class="punctuation token">.</SPAN>sde\JN233985_GCOB<SPAN class="punctuation token">.</SPAN>DBO<SPAN class="punctuation token">.</SPAN>GCOB_03_Environmental\JN233985_GCOB<SPAN class="punctuation token">.</SPAN>DBO<SPAN class="punctuation token">.</SPAN>GCOB_03391_Beneficial_Deposition
C<SPAN class="punctuation token">:</SPAN>\Users\user2\AppData\Roaming\ESRI\Desktop10<SPAN class="number token">.4</SPAN>\ArcCatalog\Connection to GALSQL01<SPAN class="punctuation token">.</SPAN>sde\JN233985_GCOB<SPAN class="punctuation token">.</SPAN>DBO<SPAN class="punctuation token">.</SPAN>GCOB_03391_Beneficial_Deposition_1 Database Connections\Connection to GALSQL01<SPAN class="punctuation token">.</SPAN>sde\JN233985_GCOB<SPAN class="punctuation token">.</SPAN>DBO<SPAN class="punctuation token">.</SPAN>GCOB_03_Environmental\JN233985_GCOB<SPAN class="punctuation token">.</SPAN>DBO<SPAN class="punctuation token">.</SPAN>GCOB_03391_Beneficial_Deposition


set<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'C:\\Users\\glen.bambrick\\Documents\\mxd\\map2.mxd'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'C:\\Users\\glen.bambrick\\Documents\\mxd\\map1.mxd'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>


C<SPAN class="punctuation token">:</SPAN>\Users\glen<SPAN class="punctuation token">.</SPAN>bambrick\Documents\mxd\map2<SPAN class="punctuation token">.</SPAN>mxd
Updating<SPAN class="punctuation token">:</SPAN> C<SPAN class="punctuation token">:</SPAN>\Users\user1\AppData\Roaming\ESRI\Desktop10<SPAN class="number token">.4</SPAN>\ArcCatalog\N6<SPAN class="punctuation token">.</SPAN>sde\JN233985_GCOB<SPAN class="punctuation token">.</SPAN>DBO<SPAN class="punctuation token">.</SPAN>GCOB_03391_Beneficial_Deposition_1
&nbsp;&nbsp;&nbsp;&nbsp; To<SPAN class="punctuation token">:</SPAN> Database Connections\Connection to GALSQL01<SPAN class="punctuation token">.</SPAN>sde\JN233985_GCOB<SPAN class="punctuation token">.</SPAN>DBO<SPAN class="punctuation token">.</SPAN>GCOB_03_Environmental\JN233985_GCOB<SPAN class="punctuation token">.</SPAN>DBO<SPAN class="punctuation token">.</SPAN>GCOB_03391_Beneficial_Deposition


Database Connections\Connection to GALSQL01<SPAN class="punctuation token">.</SPAN>sde
SDE_WORKSPACE
JN233985_GCOB<SPAN class="punctuation token">.</SPAN>DBO<SPAN class="punctuation token">.</SPAN>GCOB_03391_Beneficial_Deposition


Updating<SPAN class="punctuation token">:</SPAN> C<SPAN class="punctuation token">:</SPAN>\Users\user2\AppData\Roaming\ESRI\Desktop10<SPAN class="number token">.4</SPAN>\ArcCatalog\Connection to GALSQL01<SPAN class="punctuation token">.</SPAN>sde\JN233985_GCOB<SPAN class="punctuation token">.</SPAN>DBO<SPAN class="punctuation token">.</SPAN>GCOB_03391_Beneficial_Deposition_1
&nbsp;&nbsp;&nbsp;&nbsp; To<SPAN class="punctuation token">:</SPAN> Database Connections\Connection to GALSQL01<SPAN class="punctuation token">.</SPAN>sde\JN233985_GCOB<SPAN class="punctuation token">.</SPAN>DBO<SPAN class="punctuation token">.</SPAN>GCOB_03_Environmental\JN233985_GCOB<SPAN class="punctuation token">.</SPAN>DBO<SPAN class="punctuation token">.</SPAN>GCOB_03391_Beneficial_Deposition


Database Connections\Connection to GALSQL01<SPAN class="punctuation token">.</SPAN>sde
SDE_WORKSPACE
JN233985_GCOB<SPAN class="punctuation token">.</SPAN>DBO<SPAN class="punctuation token">.</SPAN>GCOB_03391_Beneficial_Deposition


C<SPAN class="punctuation token">:</SPAN>\Users\glen<SPAN class="punctuation token">.</SPAN>bambrick\Documents\mxd\map1<SPAN class="punctuation token">.</SPAN>mxd
Updating<SPAN class="punctuation token">:</SPAN> C<SPAN class="punctuation token">:</SPAN>\Users\user1\AppData\Roaming\ESRI\Desktop10<SPAN class="number token">.4</SPAN>\ArcCatalog\N6<SPAN class="punctuation token">.</SPAN>sde\JN233985_GCOB<SPAN class="punctuation token">.</SPAN>DBO<SPAN class="punctuation token">.</SPAN>GCOB_03391_Beneficial_Deposition_1
&nbsp;&nbsp;&nbsp;&nbsp; To<SPAN class="punctuation token">:</SPAN> Database Connections\Connection to GALSQL01<SPAN class="punctuation token">.</SPAN>sde\JN233985_GCOB<SPAN class="punctuation token">.</SPAN>DBO<SPAN class="punctuation token">.</SPAN>GCOB_03_Environmental\JN233985_GCOB<SPAN class="punctuation token">.</SPAN>DBO<SPAN class="punctuation token">.</SPAN>GCOB_03391_Beneficial_Deposition


Database Connections\Connection to GALSQL01<SPAN class="punctuation token">.</SPAN>sde
SDE_WORKSPACE
JN233985_GCOB<SPAN class="punctuation token">.</SPAN>DBO<SPAN class="punctuation token">.</SPAN>GCOB_03391_Beneficial_Deposition



Traceback <SPAN class="punctuation token">(</SPAN>most recent call last<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp; File <SPAN class="string token">"C:\Users\glen.bambrick\Desktop\test.py"</SPAN><SPAN class="punctuation token">,</SPAN> line <SPAN class="number token">65</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">in</SPAN> <SPAN class="operator token"><</SPAN>module<SPAN class="operator token">></SPAN>
&nbsp;&nbsp;&nbsp; updateDataSource<SPAN class="punctuation token">(</SPAN>broken_dict<SPAN class="punctuation token">[</SPAN>broken<SPAN class="punctuation token">.</SPAN>dataSource<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> broken<SPAN class="punctuation token">)</SPAN>
&nbsp; File <SPAN class="string token">"C:\Users\glen.bambrick\Desktop\test.py"</SPAN><SPAN class="punctuation token">,</SPAN> line <SPAN class="number token">23</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">in</SPAN> updateDataSource
&nbsp;&nbsp;&nbsp; broken_lyr<SPAN class="punctuation token">.</SPAN>replaceDataSource<SPAN class="punctuation token">(</SPAN>workspace_path<SPAN class="punctuation token">,</SPAN> workspace_type<SPAN class="punctuation token">,</SPAN> dataset_name<SPAN class="punctuation token">,</SPAN> <SPAN class="token boolean">True</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp; File <SPAN class="string token">"C:\Program Files (x86)\ArcGIS\Desktop10.5\ArcPy\arcpy\utils.py"</SPAN><SPAN class="punctuation token">,</SPAN> line <SPAN class="number token">182</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">in</SPAN> fn_
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> fn<SPAN class="punctuation token">(</SPAN><SPAN class="operator token">*</SPAN>args<SPAN class="punctuation token">,</SPAN> <SPAN class="operator token">**</SPAN>kw<SPAN class="punctuation token">)</SPAN>
&nbsp; File <SPAN class="string token">"C:\Program Files (x86)\ArcGIS\Desktop10.5\ArcPy\arcpy\_mapping.py"</SPAN><SPAN class="punctuation token">,</SPAN> line <SPAN class="number token">682</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">in</SPAN> replaceDataSource
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> convertArcObjectToPythonObject<SPAN class="punctuation token">(</SPAN>self<SPAN class="punctuation token">.</SPAN>_arc_object<SPAN class="punctuation token">.</SPAN>replaceDataSource<SPAN class="punctuation token">(</SPAN><SPAN class="operator token">*</SPAN>gp_fixargs<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">(</SPAN>workspace_path<SPAN class="punctuation token">,</SPAN> workspace_type<SPAN class="punctuation token">,</SPAN> dataset_name<SPAN class="punctuation token">,</SPAN> validate<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="token boolean">True</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
ValueError<SPAN class="punctuation token">:</SPAN> Layer<SPAN class="punctuation token">:</SPAN> Unexpected error‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Find more posts tagged with

Accepted answers

All comments

JosephJose

Yes you were correct, if it's open in Catalog or ArcMap, it creates the error

JosephJose

Anyone found a solution for this? I am facing the same problem

ThibautDelaere1

UPDATE (WORKAROUND FOUND😞 adding arcpy.ClearWorkspaceCache_management() before every replaceDatasource seems to solve the issue.

I'm having the same issue right now, so I was wondering if you ever solved it?

I run a Python Toolbox and noticed the error when rerunning the tool replacing datasources. So first run everything works fine, second run (and further) it fails on a certain SDE-connection with the ValueError mentioned.

Closing ArcCatalog and reopening makes the tool run again succesfully. But just once. Then the same error appears.

So, it seems related to certain SDE-connections and something in memory/cached/… of the Python environment.

Anonymous User

The mxd.save() is in the correct place, the mxds with broken links are already collected and used from the input_csv, within the nesting it is getting the broken layers and updating using the function updateDataSource(). The code works perfect for Shapefiles so SDE is the issue. I just need to find a workaround or is this a possible bug?

Anonymous User

I tried this and while it allows the looping to continue without failing and saving the mxd it does not update the sources after the first mxd

forestknutsen1

 broken_lyr<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">.</SPAN>replaceDataSource<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">(</SPAN>workspace_path<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">,</SPAN> workspace_type<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">,</SPAN> dataset_name<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">,</SPAN> <SPAN class="" style="color: #990000; border: 0px; font-weight: inherit;">True</SPAN>

You could try to set this validation to false. I have had some weird behavior around this and sde datasouces in the past.

DanPatterson_Retired

Glen with all the nesting it isn't clear to me if the mxd.save() is the right place.

I would suggest collecting all the mxds with broken links first, then process them separately, rather than nesting, then performing another check and finally doing something.

Anonymous User

Thanks for looking Dan, I was looking for the code formatting and in my haste missed it. I have updated the code and the output/error. Cheers

DanPatterson_Retired

Glenn Code Formatting .... would help and throw in a print statement before the line 45 since what going in to the first process doesn't seem like it was expected

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.