ArcGIS Pro Python Script for Update Connection Properties Not Working

TauhidulIslam1 — Tue, 05 Nov 2019 04:49:53 GMT

As we need to update the data source for more than 50 maps in ArcGIS Pro we need to run batch update. Previously I use the following code which worked for the Test database.

import arcpy
aprx = arcpy.mp.ArcGISProject(r'C:\Temp\Administrative Boundaries.aprx')
find_dict = {'connection_info': {'instance': 'sde:sqlserver:SERVER.name.com',
'server': 'SERVER.name.com'}}

replace_dict = {'connection_info': {'instance': 'sde:sqlserver:newSERVER.name.com',
'server': 'newSERVER.name.com', 'authentication_mode': 'OSA'}}
aprx.updateConnectionProperties(find_dict, replace_dict)
aprx.save()

but in the production database because we have the high availability we made the following changes in the code-

import arcpy
aprx = arcpy.mp.ArcGISProject(r'C:\Temp\Administrative Boundaries.aprx')
find_dict = {'connection_info': {'instance': 'sde:sqlserver:SERVER.name.com',
'server': 'SERVER.name.com'}}

replace_dict = {'connection_info': {'instance': 'sde:sqlserver:newSERVER.name.com;MULTISUBNETFAILOVER=YES',
'server': 'newSERVER.name.com', 'authentication_mode': 'OSA'}}
aprx.updateConnectionProperties(find_dict, replace_dict)
aprx.save()

Nothing seems wrong. Anyone have any idea?
Regards,Tauhid

topic ArcGIS Pro Python Script for Update Connection Properties Not Working in ArcGIS Pro Questions

ArcGIS Pro Python Script for Update Connection Properties Not Working