Latest Contributions by Brian_McLeer

When exporting a feature dataset from one DB to another, the schema, features, and domains transfer over. However, attribute rules do not transfer over. Enabling attribute rules to be exported to XML schema and imported would be beneficial when migrating a schema.  ... View more

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  ... View more

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 ... View more

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.  ... View more

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];‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

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.  ... View more

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: ... View more