Latest Contributions by Brian_McLeer

‎06-11-2020

I had this same issue. I was developing the schema in an FGDB, and I assumed you could simply copy and paste the feature class over to SDE and the domains would transfer over as this way would work with ArcMap. For a workaround, I did the following steps: - Export new schema to XML workspace document with data included - Import XML workspace document into SDE, this will also transfer over the domains - If you are trying to get a new schema into a feature dataset, you will need to copy and paste the source feature class as a standalone FC into SDE, then again copy and paste that FC into the feature dataset, it will have a name like _1 at the end. Delete the standalone feature class, then rename the feature class in the feature dataset by removing the _1.

‎05-11-2020

We are using branch versioning for the first time in an SDE database (SQL Server 2016). For our existing traditional versioning DBs, we use the recommended compress, rebuild indexes, and analyze datasets in our nightly routines similar to ESRI documentation below. This methodology is not recommended with branch versioning, however. Is anyone using certain GP tools on a regular basis for database maintenance for an SDE database that uses branch versioning? If so, what methods are you using? Do branch versioned DBs require daily maintenance as traditional versioned DBs require? Enterprise geodatabase maintenance tasks—Manage geodatabases in SQL Server | Documentation

‎01-08-2020

Trying to start/stop specific services. Using the article at How To: Stop GIS services using ArcGIS API for Python, I tried using the code but keep receiving an error message below posted code. I am running this script in IDLE (ArcGIS Pro). Using just IDLE for ArcGIS Desktop did not have the necessary modules. from arcgis.gis import GIS import arcgis.gis.admin gis = GIS("https://url.to.com/portal", "Username", "Password", verify_cert=False) services = gis_servers.services.list() #To stop specific service(s) for service in services: for service in server.services.list(): if service.properties.serviceName == "SampleWorldCities": service.stop()‍‍‍‍‍‍‍‍‍ Error Message: Traceback (most recent call last): File "Z:\Temp\Brian\test.py", line 5, in <module> services = gis_servers.services.list() NameError: name 'gis_servers' is not defined

arcpy Disconnect Users randomly fails · ‎11-13-2019

We have a routine that uses the SDE admin connection to disconnect users from several databases nightly. Randomly, this python routine will occasionally fail with the error message below. Connection information provided was for a non-administrative user There is not any more information provided by the reports. My first guess was a permission issue like this post https://community.esri.com/thread/89448 . We are using a general SQL service account to run routines, but permissions should not explain why it fails randomly and is successful at other times.

‎08-28-2019

Thanks, Xander, For the exact feature class name, is that the entire connection string, or feature class name itself? Also, the tax lot feature class resides in a separate database than the address points.

‎08-28-2019

Being new to Arcade and Attribute rules, I am trying to put in place a rule that populates a tax lot ID number on an address point upon insert or update. The error I receive comes from line 6 at the bottom of the thread. ERROR 002717: Invalid Arcade expression, Arcade error: Table not found WC Tax Lots What I am having trouble connecting the dots is how to grab the TLNO from the tax lot polygon and assign it to the TLNO GIS field in the address point feature class. In my Contents, the tax lot layer is titled as WC Tax Lots as it is in the code below. I received the code sample from GitHub - Esri/arcade-expressions: ArcGIS Arcade expression templates for all supported profiles in the ArcGIS platform. // Value to copy from the intersected feature var intersecting_field = "TLNO GIS"; //Field rule is assigned to in the Attribute Rule var feature_field = "TLNO"; // Create feature set to the intersecting class using the GDB Name var intersecting_featset = FeatureSetByName($datastore, "WC Tax Lots", [intersecting_field], true); // Intersect the edited feature with the feature set and retrieve the first feature var intersected_feature = First(Intersects(intersecting_featset, $feature)); // Check to make sure there was an intersected feature, if not, return the original value if (intersected_feature == null) { return $feature[feature_field]; } // If the intersected feature is null, return the original value if (IsEmpty(intersected_feature.valueToCopy)) { return $feature[feature_field]; } // Return the intersected features value return intersected_feature[intersecting_field];‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

‎07-24-2019

Hi Rachel, The data frame coordinate system in both MXDs and coordinate system of the geometric network both match after looking at the properties.

‎07-24-2019

We are having an issue for one of our users editing in a geometric network. Several geometric network editing toolbar buttons are not available for use. This error does not occur when I open the same MXD. Both the user and I are on ArcGIS Desktop 10.6.1 Advanced License on Windows 10. When I open the MXD, all tools are available: When the user opens the MXD, all buttons besides connect and disconnect are greyed out: We have verified that the only 1 feature (the one intended to be edited) was selected on both computers.

‎06-28-2019

After troubleshooting with: - a series of compresses, rebuild indexes and analyze datasets ran manually - Two nights of automated compress, rebuild and analyze Python routines - Recreate replicas with a different ID I still have lingering SDE states in the SDE_States table. When running a query for all records in the table, I receive:

‎06-24-2019

I have had this problem as well. I make a feature layer without a definition query, then use the feature layer and use the Select by Attributes tool is where I put in the date query, then calculate field.

‎06-20-2019

Thanks Jake, You saved me a bunch of time!

‎06-20-2019

I should say if the first database connection does not contain the layer to reference to, but the layer is in the next database.

‎06-20-2019

Thanks, Jake, That worked for one data source, unfortunately, I have 3 databases referenced in the MXDs. Is there an 'if else' statement to point it towards the next database if the first one does not work?

‎06-20-2019

We are changing our production server to have a prefix of 'HV'. I have a folder of MXDs I would like to update to the new server, but I am missing something from my code below. I got my start from https://gist.github.com/davehorsey/d8892b150e61d2e03617. import arcpy, os path = r"C:\layouts" for fileName in os.listdir (path): basename, extension = os.path.splitext(fileName) # select MXD files that do NOT begin with "Copy_of_" - this # prevents the script from updating files that have already been updated if (extension == ".mxd") and (fileName[:8] != "Copy_of_"): fullPath = os.path.join(path, fileName) mxd = arcpy.mapping.MapDocument(fullPath) print fullPath # update data sources mxd.findAndReplaceWorkspacePaths("Database Connections\\Server Database NT Auth.sde", "Database Connections\\HV_Server Database NT Auth.sde") print "\tUpdated: SDE data sources" # check for broken links brknList = arcpy.mapping.ListBrokenDataSources(mxd) for brknItem in brknList: print "\tCheck: " + brknItem.name + " data source broken" if not brknList: print "\tCheck: no broken data sources" # save a copy of the MXD saveACopy_filename = "Copy_of_" + fileName saveACopy_fullpath = os.path.join(path, saveACopy_filename) mxd.saveACopy(saveACopy_fullpath) print "\tSaved: " + saveACopy_filename del mxd # delete the original MXD arcpy.Delete_management(fullPath) print "\tDeleted: " + fullPath‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

‎05-22-2019

When using the Apply Symbology From Layer file in Pro via Model Builder, it will revert the labels back prior to any changes I have made. I have updated the layer file (.lyrx) that it references too, but does not seem to stick as it does in ArcMap with a Layer (.lyr) file.

Online Status	Online
Date Last Visited	5 hours ago

My Ideas

Latest Contributions by Brian_McLeer

Re: Copying domains from one GDB to another

Recommended SDE database maintenance in branch versioning environment

Stopping and Starting Services in Portal via Python

arcpy Disconnect Users randomly fails

Re: Calculate field based on common geometry using Attribute Rules

Calculate field based on common geometry using Attribute Rules

Re: Geometric Network Editing Buttons Greyed Out

Geometric Network Editing Buttons Greyed Out

Lingering SDE States in in Child replicated database

Re: Make feature layer based off last edited date

Re: Loop through folder of MXD and change server name

Re: Loop through folder of MXD and change server name

Re: Loop through folder of MXD and change server name

Loop through folder of MXD and change server name

Labels not sticking when applying Apply Symbology From Layer in Pro

Zone Lookup

CSV Geocoder Widget

Re: ArcGIS Security and Privacy Advisor does nothi...

Search Custom

Map Layers Custom

Experience Builder Custom Widgets

Experience Builder Tips and Tricks