topic Re: mapDoc.save() fails after mapDoc.replaceWorkspaces() in MXD with ArcGIS Image Ser in Python Questions

mapDoc.save() fails after mapDoc.replaceWorkspaces() in MXD with ArcGIS Image Service

CarlBeyerhelm — Thu, 16 Jan 2014 15:48:10 GMT

Our organization is migrating from SDE 9.3.1 to SDE 10.1 which entails new SDE connection files.

I've developed a script tool that walks a directory tree looking for MXD files that have an old SDE connection, and then replaces the old SDE connection(s) with the new SDE connection(s) using the .replaceWorkspaces() method.

The script works totally as expeted except for MXDs that contain an ArcGIS Image Service raster layer. In these situations, the SDE connection to the vector data is successfully replaced but, somehow, that process strips all of the properties from the Image Service layers!

In the attached image below, notice that the SDE connection has been updated to gdb01a as it should, but the Image Service layers are stripped of their source properties. That causes the MXD to be un-savable when I apply the .save() method.

This seems quite bizarre to me. Any explanations or remedies would be appreciated. Thank you...

[ATTACH=CONFIG]30573[/ATTACH]

Re: mapDoc.save() fails after mapDoc.replaceWorkspaces() in MXD with ArcGIS Image Ser

JeffBarrette — Fri, 17 Jan 2014 13:11:00 GMT

Can you please open an incident with technical support so we can evaluate the situtation.

Jeff

Re: mapDoc.save() fails after mapDoc.replaceWorkspaces() in MXD with ArcGIS Image Ser

CarlBeyerhelm — Fri, 17 Jan 2014 20:37:20 GMT

I'd be happy to but, I have to confess, I'm not sure how to do that.

Can you point me in the right direction, please?

Thanks...

Re: mapDoc.save() fails after mapDoc.replaceWorkspaces() in MXD with ArcGIS Image Ser

JeffBarrette — Tue, 21 Jan 2014 14:52:22 GMT

Go to:

http://support.esri.com/en/

Then you have an option to contact via email or by phone.

Jeff

Re: mapDoc.save() fails after mapDoc.replaceWorkspaces() in MXD with ArcGIS Image Ser

JoshuaBixby — Wed, 22 Jan 2014 18:49:48 GMT

Incident has been created with Esri Support with the same subject/name as this forum posting.

Re: mapDoc.save() fails after mapDoc.replaceWorkspaces() in MXD with ArcGIS Image Ser

CarlBeyerhelm — Fri, 24 Jan 2014 14:56:13 GMT

For reference, the incident ID is:

Esri Incident #1234321 (Thomas J) mapDoc.save() fails after mapDoc.replaceWorkspaces() in MXD with ArcGIS Image Service

Re: mapDoc.save() fails after mapDoc.replaceWorkspaces() in MXD with ArcGIS Image Ser

MichaelVolz — Fri, 24 Jan 2014 15:15:18 GMT

How about trying to use the UpdateLayer method on your ArcGIS Image Service layers? You could pre-process the ArcGIS Image Service lyr files for your upgraded environment and then run this method using these new lyr files to replace the old layers. This is how I accomplished something similar to you where I had to convert image layers originating in SDE with raster mosaic datasets. I found there to be no other conversion method that would work with this type of scenario.

Re: mapDoc.save() fails after mapDoc.replaceWorkspaces() in MXD with ArcGIS Image Ser

CarlBeyerhelm — Sun, 26 Jan 2014 16:46:35 GMT

Your suggestion would be a good approach in a situation where we needed to update the Image Service layer sources. In this situation, however, I only need to update the SDE connections to accommodate the upgraded SDE environment. The Image Service environment is not changing, so there is no need or desire to update Image Server layers.

To illustrate this issue further, the 3 attached images document the step-by-step results at crucial points in the replaceWorkspaces() process using the ArcMap Python interactive window.

The first image is from just after the layers have been interrogated for their workspacePath and a TOC refresh. No signs of any trouble yet. All is well.

The second image is from just 2 commands later�?�the replaceWorkspaces() and the TOC refresh commands. Here, the targeted SDE workspace has indeed been replaced successfully, but the replaceWorkspaces() method has also caused the non-target Image Sever Source properties to be deleted or corrupted. Clearly, something in the replaceWorkspaces() method has stepped on the Image Server content even though replaceWorkspaces() did not pertain to any Image Service layers.

The third image follows mapDoc.save(), and illustrates that the broken doc cannot be saved.

The bottom line is that replaceWorkspaces() successfully updates the intended target SDE connections, but it also has the unintended consequence of deleting or corrupting non-target Image Service source properties.

If I've missed your point, please reply back...

Re: mapDoc.save() fails after mapDoc.replaceWorkspaces() in MXD with ArcGIS Image Ser

MichaelVolz — Mon, 27 Jan 2014 11:32:34 GMT

Carl:

It seems as though you might have encountered a bug with the replaceWorkspaces() method and I would not be confident in a timely fix of a bug. The replaceWorkspaces() method seems like a more universal resourcing method where all the data originates in the same database. I had to resource data from multiple databases with multiple user connections to the databases.

I would suggest using the replaceDataSource method where you could interrogate each connection and then build a new connection file (.sde). If a new .sde connection file has already been built then just use the new .sde file (This is what I did).

I used the .sde file with replaceDataSource and I handled my imagery with the UpdateLayer method since I was no longer storing the imagery in SDE.

This would be a workaround to the errors you are getting with the replaceWorkspaces() method.

Re: mapDoc.save() fails after mapDoc.replaceWorkspaces() in MXD with ArcGIS Image Ser

CarlBeyerhelm — Mon, 27 Jan 2014 16:39:36 GMT

Yes, the replaceDataSource() method does seem like the only ArcPy work-around at this point.

Thank you.

Re: mapDoc.save() fails after mapDoc.replaceWorkspaces() in MXD with ArcGIS Image Ser

CarlBeyerhelm — Tue, 28 Jan 2014 17:39:03 GMT

For information, this issue has now been registered as a bug with this reference:

NIM098396: arcpy.mapping.replaceWorkspaces will break the data source connection to an Image Service Layer when replacing a workspace in a map document. Occurs with SDE workspaces, file geodatabases, and shapefiles.

Re: mapDoc.save() fails after mapDoc.replaceWorkspaces() in MXD with ArcGIS Image Ser

MichaelVolz — Tue, 28 Jan 2014 18:01:12 GMT

Did ESRI give an estimate on when they might be able to fix this bug?

Are you going to us the alternate ReplaceDataSource method to process your SDE layers?

Re: mapDoc.save() fails after mapDoc.replaceWorkspaces() in MXD with ArcGIS Image Ser

CarlBeyerhelm — Wed, 29 Jan 2014 01:12:57 GMT

Hi Micheal.

No specific time frame was given for fixing the issue, but ESRI did confirm that the bug persists through versions 10.2 and 10.2.1, and that a member of their development team has taken the issue on.

Although lyr.replaceDataSource() would work, I elected to use mapDoc.findAndReplaceWorkspaces() as it is faster than iterating through each TOC layer.