Latest Contributions by DonMorrison1

ArcPro crashes every time I try to run the very trivial program below. I've tried it in the ArcPro python pane (both 2.4.2 and 2.4.3) and under Spyder IDE - and using many variations to the code below.  It does throw an error (as expected) if I feed it a bogus table datasource. The table doesn't appear corrupt since I can open it from the catalog pane. Is anybody else using this API call?  import arcpy arcpy.env.workspace = r'C:\Users\dmorri28\Documents\ArcGIS\Projects\MyProject\CC-SQL2k16-ERC-SDE.sde' arcpy.mp.Table('FieldShareLevel') I'm running this with arcpy that got installed with ArcPro (currently at 2.4.3 but also failed on 2.4.2)  and Python 3.6.8 and Advanced license. ... View more

I have a very simple python tool that returns results of a query on our enterprise geodatabase. When I publish that tool to our ArcGIS Server (not federated), the enterprise geodatabase gets copied to a file geodatabase, which is not what I want. I've read through the help on this many times and still can't figure out what I'm doing wrong. When I dump out the database path I can see the published code is accessing the file geodatabase copy instead of the SQL Server. I checked Server Manager and the database is listed as a registered Data Store, although it is not obvious how the literal string in my code gets matched to the name of the registered data store ("ROW_Habitat").   I'm running this with arcpy that got installed with ArcPro (currently at 2.4.2)  and Python 3.6.8 and Advanced license. Here is the python tool: class SummaryStatsA(object):     def __init__(self):         self.label = "Summary StatsA"         self.description = ""         self.canRunInBackground = False     def getParameterInfo(self):         num_acres = arcpy.Parameter(             displayName="Acres",             name="num_acres",             datatype="GPDouble",             parameterType="Derived",             direction="Output")         num_orgs = arcpy.Parameter(             displayName="Organizations",             name="num_orgs",             datatype="GPLong",             parameterType="Derived",             direction="Output")         return [num_acres, num_orgs]             def isLicensed(self):         return True     def updateParameters(self, parameters):         return     def updateMessages(self, parameters):         return     def execute(self, parameters, messages):         db_table_path = r'C:\Users\dmorri28\Documents\ArcGIS\Projects\MyProject\CC-SQL2k16-ERC.sde\ROW_Habitat.sde.summary_stats_TEST'         arcpy.AddMessage("DB Path: %s" % db_table_path)         with arcpy.da.SearchCursor(db_table_path, ['num_acres', 'num_orgs'], None) as cursor:               num_acres, num_orgs = cursor.next()             parameters[0].value =  num_acres             parameters[1].value =  num_orgs         return   Here is how I do the publish, which I run from the Spyder IDE:   arcpy.CreateGPSDDraft(results,                           sddraft_file,                           service_name,                           server_type='FROM_CONNECTION_FILE',                           connection_file_path=AppInfo.ags_connect_connection_file,                           copy_data_to_server=False,                           folder_name=AppInfo.ags_service_folder,                           summary=service_summary,                           tags=service_tags,                           executionType='Synchronous',                           showMessages='Info',                           minInstances=0,                           maxInstances=2)         arcpy.StageService_server(sddraft_file, sd_file)     arcpy.UploadServiceDefinition_server(sd_file, AppInfo.ags_connect_connection_file) ... View more

I have a python program does does a series of updates on a group of feature classes that it accesses via an ArcGIS online REST endpoint that proxies the request to my ArcGIS server. I want to be able to back out the updates if something goes wrong but I can't get it to work. I reduced the code as shown below. The code sets an initial value , performs 3 updates (each with a new cursor, since in my real code I have to make multiple passes over the data), then aborts the edit session. If I run this against a file geodatabase it works as expected where at the end the records have the "original value". However if I run it against the ArcGIS Online REST endpoint it ends up with the 2nd update ('Edited -2') - as if only the data updated by the last cursor was backed off. I'm running this with arcpy that got installed with ArcPro (currently at 2.4.2)  and Python 3.6.8 and Advanced license. import arcpy workspace = 'https://utility.arcgis.com/usrsvcs/servers/383d3cf85e8a41e9b7e8a5e9e8bb90b9/rest/services/ROW_testing/ERC/FeatureServer' fc = workspace + '/0' # Set initial values with arcpy.da.UpdateCursor(fc, ['LineName']) as cursor:     for row in cursor:         cursor.updateRow(['Original value']) edit = arcpy.da.Editor(workspace) edit.startEditing(True, False) edit.startOperation() with arcpy.da.UpdateCursor(fc, ['LineName']) as cursor:     for row in cursor:         cursor.updateRow(['Edited - 1'])         with arcpy.da.UpdateCursor(fc, ['LineName']) as cursor:     for row in cursor:         cursor.updateRow(['Edited - 2'])                 with arcpy.da.UpdateCursor(fc, ['LineName']) as cursor:     for row in cursor:         cursor.updateRow(['Edited - 3'])                 edit.abortOperation() edit.stopEditing(False) ... View more