Latest Contributions by MichaelVolz

Felix: I had a similar problem when I performed an SDE conversion from 9.1 to 9.3 using VBA.  In this case, we created another SDE database on a new server with ArcGIS v9.3.  After running this conversion, some layers were still looking for the 9.1 connections which caused the mxd to hang when opening because the 9.1 database and server was now retired.  I was unable to locate the old connections, so I added a dummy domain name to route the connections with the old server name to the new server name.  This solved the problem, but the mxd still contains references to the old server.  The only way to fix this is to recreate the entire mxd (time consuming and we have hundreds of files like this). It seems that the newly saved mxd might still have references to the old server which causes it to hang.  I guess saving it again outside of python removes these references as you are then able to open the mxd in a normal amount of time. Do you have any 3rd party software that is used in this mxd?  This could be a cause of your problems. Also, I would contact tech support and log an incident with them to see if the SaveACopy is supposed to flush out references to old servers.  I would be interested in the results as I will need to perform this operation on thousands of mxds when my organization migrates from Oracle Client 10g to either 11 or 12 depending upon when my organization is ready for this upgrade. ... View more

I have never had to perform this operation before, but maybe you should save the layer to disk in the new projected coordinate system.  Then try calculating the area on the new layer instead of the reprojected original layer. ... View more

Thanks for your reply with code Ben.  I believe that might work, but I think the following Post has a better solution: replaceDataSource not working in the same python forum The method that appears to work best is the UpdateLayer method.  This incorporates RemoveLayer and AddLayer in the same method and the task of tracking the index of the layer is bundled up for free with this method. ... View more

Thanks Jeff. The UpdateLayer method with the False parameter for symbology appears to do exactly what I need.  Preliminary testing worked perfectly and now I need to test with more complex mxds where there are multiple dataframes and layers in a Group Layer that need to be replaced. ... View more

Thank you Mathew, but this solution does not solve my problem.  But you did point me to an area in the Help documentation where the InsertLayer method is found.  I believe the InsertLayer method might work for me as it works with Group Layers, according to the Help documentation, and you can insert it before or after a target layer anywhere in the Group, not just at the top or bottom.  In my scenario I can have a group layer with 5 layers in it and I want to replace either the 2nd, 3rd, or 4th layer. ... View more

Jake: Besides a Mosaic Dataset, what do you think would be the best way to store raster images outside of SDE to get excellent performance in ArcMap, where I would be able to use the replaceDataSource in python to get an automated solution that can be performed during non-business hours? In response to your last post, many of the the current SDE image layers can be found in group layers and not necessarily at the bottom of the TOC, so your approach would by no means be the universal solution for my organization.  In the past I had resourced these same images from IMS to SDE using a programmatic approach in VBA, but group layers also presented a problem.  I had to resource these layers manually after getting an inventory of how often this occurred on my network.  I was hoping the replaceDataSource in python for ArcMap v10.0 would make this task easier, but it appears that this option was not accounted for at this point in python. ... View more

Jake: Do you know if it will be a capability of python scripting in ArcGIS v10.1 to convert SDE raster images to a mosaic dataset?  I would need to perform this task on 10s of thousands of layers so a manual approach is extremely impractical.  Thanks. ... View more

Jake: In the original post, the posting person was trying to convert rasters from one SDE database to another.  In your response, you said it would be better to use a mosaic dataset to store the raster data.  As such, I would want to convert raster data from SDE to a mosaic dataset for layers that I have saved in many mxds.  I thought you were indicating that this can be done, but your last post said this is not possible with replaceDataSource. Is there any other python method that could be used to make this conversion?  Your feedback is greatly appreciated.  Thanks. ... View more

Jake: What would be the replaceDataSource syntax if one was converting from a raster in SDE to a mosaic dataset in a file geodatabase? This is the syntax I am using, which follows the ArcGIS Help, but I am getting an error message: elif layr.datasetName == "ORTHO2005.ORTHOS2005":                 print("The dataset name in Resource_mxd is " + layr.datasetName)                 layr.replaceDataSource(r"\\gis\GIS\Work\arcmap\mosaic_2010.gdb", "FILEGDB_WORKSPACE", "orthos_2010")                 In this code, "orthos_2010" is the mosaic dataset that contains 2010 Orthophotos.  I am not specifying where the data originates in SDE, other than making sure that the focus layer to be converted has a datasetName =  ORTHO2005.ORTHOS2005, as I did not need to do this for vector datasets that I resourced from SDE to a file geodatabase. Your assistance is greatly appreciated.  Thanks. ... View more

Hi Christina: In your python script, maybe you can use the datasetname to get the full name of the SDE feature class so it differentiates between BULLITT.bg and PTD.bg.  You can then use If Then statements to make sure it gets resourced to the correct data. In addition, do you plan on running this script on many mxds at once in a loop?  I have been writing similar python scripts where I resource SDE data and it appears there is a memory leak as the memory usage for the script keeps going up until it locks up the computer.  I am currently working with ESRI Technical Support to resolve this particular issue. Please let me know if you need any clarification or additional information from my response.  Thank you. ... View more

Chris: I tried your approach to set lyrs equal to a variable and then delete the lyrs variable after using it in each mxd, but it did not help the memory issue.  I also tried to delete the servProp variable and that did not help the memory issue either. ... View more

Murray: I have had to deal with this problem in the past (used VBA which is going away) and I will need to deal with it again in the future which I am using python to automate the process. If you can provide a more detailed picture of your situation, I could provide a starter script that you could test to update your file paths. Where does the data originate from (e.g. shapefiles, personal geodatabases, file geodatabases)? Very important, what version of ArcView (ArcGIS Desktop) are you using?  Python in version 10 has a good deal more built-in functionality to get this job done. ... View more

Thanks Chris.  The script with the subprocess did exactly what you said it would and flooded the processor with parallel processes. Here is my code with just one python script where the memory usage keeps increasing until the python scripts freezes up.  The script is meant to loop through a selected directory, get the mxds and resource the SDE layers from the original SDE connection to a different SDE connection.  You can open up Task Manager while running this script and see how memory usage for the pythonw.exe process keeps increasing.  Please note that you will need to run this script on a directory with a good number of mxd files that have many SDE layers in order to see the performance hit. import os, sys, string, arcpy mxd_match = ".mxd" Directory_Search = r"\\server00\e$\restore5\Experiment\Test_10" new_connPrefix = r"C:\Documents and Settings\Application Data\ESRI\Desktop10.0\ArcCatalog" def Conn_Info(usr):     if usr == "user01":         new_connection = new_connPrefix + "\\" + usr + "_dir_conn@production.sde"         return new_connection     elif usr == "user02":         new_connection = new_connPrefix + "\\" + usr + "_dir_conn@development.sde"         return new_connection     elif usr == "user03":         new_connection = new_connPrefix + "\\" + usr + "_dir_conn@production.sde"         return new_connection     del new_connection         for root, dirs, files in os.walk(Directory_Search): # for root, dirs, files in os.walk(arcpy.GetParameterAsText(0)):     fListLength = len(files)     if (fListLength != 0):         n = 0         for f in files:             full_path = root + "\\" + str(f)             if f.endswith(mxd_match):                                 mxd = arcpy.mapping.MapDocument(full_path)                 for lyr in arcpy.mapping.ListLayers(mxd):                     try:                         if lyr.supports("DATASOURCE"):                                                         if lyr.supports("SERVICEPROPERTIES"):                                 servProp = lyr.serviceProperties                                 user = str(servProp.get('UserName', 'N/A'))                                                                 new_conn = Conn_Info(user)                                                                 lyr.replaceDataSource(new_conn, "SDE_WORKSPACE", lyr.datasetName)                     except:                         print arcpy.GetMessages(2)                     del lyr                                     try:                            # mxd.saveACopy(root + "\\" + f[:-4] + "_New.mxd", "9.3")                     mxd.save()                                     except:                     print arcpy.GetMessages(2)                 del mxd                         del full_path Thanks for all your help!! ... View more