topic Re: updateConnectionProperties() is not working in Python Questions

updateConnectionProperties() is not working

NSamu — Thu, 28 Sep 2023 16:40:20 GMT

Hello,

I am trying to update connection properties for all layers in a Pro project map that are connected to our admin database to a read-only version of that database. When I run the following script, it runs but the database connections do not get updated.

import arcpy
aprx = arcpy.mp.ArcGISProject("CURRENT")
for m in aprx.listMaps("Mobile_Map"):
for lyr in m.listLayers():
if not(lyr.isGroupLayer or lyr.isBasemapLayer):
try:
lyr.updateConnectionProperties(current_connection_info="A:\DBConnection\admin.sde", new_connection_info="A:\DBConnection\dr.sde")
except:
print("Not an sde database or the database connection does not need to be updated.")

Re: updateConnectionProperties() is not working

BlakeTerhune — Thu, 28 Sep 2023 17:25:03 GMT

I think you need to save the project when you're done.

Updating and fixing data sources—ArcGIS Pro | Documentation

Re: updateConnectionProperties() is not working

NSamu — Thu, 28 Sep 2023 18:12:41 GMT

Thank you for the suggestion. I just tried it but it still does not work.

Re: updateConnectionProperties() is not working

SorenPeterson — Thu, 28 Sep 2023 18:50:55 GMT

I use something similar to this.

proj_gdb = #SDE Source for lyr in m.listLayers(): lyr_update = lyr.connectionProperties lyr_update['connection_info']['database'] = proj_gdb lyr_update['dataset'] = #SDE layer name lyr.updateConnectionProperties(lyr.connectionProperties, lyr_update)

Edit: In this example, I'd probably get the source feature class name and, assuming that the target has the same name as the source, use that variable to get the correct target feature class name.

Re: updateConnectionProperties() is not working

NSamu — Fri, 29 Sep 2023 12:22:05 GMT

Thank you for this--it makes sense to me. I just tried something similar (see code in .txt doc) and it runs but still doesn't work properly. I had to modify the code some since I'm moving the connection from between different users of the same SDE database--the only difference that I can see when printing the database properties of the dr vs. admin database is the user and password. So, I tried to just update those in the code this time...

Re: updateConnectionProperties() is not working

SorenPeterson — Mon, 02 Oct 2023 13:34:10 GMT

I could see some issues with that code if you change the user/password and the user doesn't have access to the relevant layer. Also if the table has a different name than the current layer, since it'll be looking for the same table name, but with a different connection. I'd recommend taking a look at the source tab in the properties for both the original and the new tables and see if there's any differences that will need to be updated to match beyond the database login. For example if the table name is different such as DBO.layername and User.layername_1, different feature dataset name, different instance name, server ip/hostname.

Re: updateConnectionProperties() is not working

NSamu — Tue, 03 Oct 2023 12:38:48 GMT

Thanks for this suggestion but everything is the exact same aside from the un/pw and permissions set on each. Same database version and everything--just one user has admin permissions and the other user was created for viewing only.

Re: updateConnectionProperties() is not working

BlakeTerhune — Tue, 03 Oct 2023 14:19:44 GMT

I would recommend using the supports() method on layer to check if it has the property "connectionProperties"

for lyr in m.listLayers(): if lyr.supports("connectionProperties"): print(lyr.connectionProperties["connection_info"]) lyr_update = lyr.connectionProperties lyr_update['connection_info']['password']='<password>' lyr_update['connection_info']['user']='dr' lyr.updateConnectionProperties(lyr.connectionProperties, lyr_update)

Re: updateConnectionProperties() is not working

NSamu — Tue, 03 Oct 2023 15:36:40 GMT

Thanks, Blake. I tried your method using the code below--it ran but did not change the database connection. Please let me know if you have another suggestion or see any issues with my code.

import arcpy aprx = arcpy.mp.ArcGISProject("CURRENT") for m in aprx.listMaps("Mobile_Map"): for lyr in m.listLayers(): if lyr.supports("connectionProperties"): try: print(lyr.connectionProperties["connection_info"]) lyr_update = lyr.connectionProperties lyr_update['connection_info']['password']='<password>' lyr_update['connection_info']['user']='dr' lyr.updateConnectionProperties(lyr.connectionProperties, lyr_update) except: print("Not an sde database or the database connection does not need to be updated.") aprx.save() del aprx

Re: updateConnectionProperties() is not working

NSamu — Tue, 03 Oct 2023 15:58:53 GMT

Edit: the code above works when I change '<password>' to 'password'. Thanks @BlakeTerhune ! Much appreciated.

Re: updateConnectionProperties() is not working

BlakeTerhune — Tue, 03 Oct 2023 16:45:59 GMT

Oh, glad you got it working!

As another suggestion, consider handling your exceptions a more specific, targeted manner. With your snippet, you will never know if there was some other problem with updateConnectionProperties() because you're printing a generic message for all exceptions. You need to know if something unexpected is happening, which your error handling will not show. I've started doing this as a pattern to add more information/context to errors.

import arcpy aprx = arcpy.mp.ArcGISProject("CURRENT") for m in aprx.listMaps("Mobile_Map"): for lyr in m.listLayers(): if lyr.supports("connectionProperties"): try: print(lyr.connectionProperties["connection_info"]) lyr_update = lyr.connectionProperties lyr_update['connection_info']['password']='<password>' lyr_update['connection_info']['user']='dr' lyr.updateConnectionProperties(lyr.connectionProperties, lyr_update) except Exception as e: raise Exception("Not an sde database or the database connection does not need to be updated.") from e aprx.save() del aprx

If you really want to pass on some specific error, you can handle that specifically. In this example, all arcpy errors will get passed and the code will continue running, but it will stop if the exception is not from arcpy (unhandled).

except arcpy.ExecuteError as arcpy_e: print(arcpy_e) print("Not an sde database or the database connection does not need to be updated.") pass

Re: updateConnectionProperties() is not working

NSamu — Tue, 03 Oct 2023 16:51:03 GMT

Thank you for this advice. Very helpful and much appreciated.

Re: updateConnectionProperties() is not working

RogerDunnGIS — Mon, 27 Jan 2025 23:06:36 GMT

I have to write two Python scripts, one for ArcMap and one for ArcGIS Pro, in order to fix all the geodatabase connections in map documents and Pro projects after we change 30+ passwords at a future date. It's unfortunate that the Pro script will have to access a file (or have hard-coded) all the new passwords in order for this to work! The ArcMap script will have no such problems, with all the testing I've done (the biggest hang-up there is that the "Database" key does not appear in the serviceProperties dictionary when the connection can't be established). No combination of arguments for the updateConnectionProperties method seems to work other than the one marked in this thread as the solution. I would have preferred to just reference a new .sde file, but that just doesn't work.