-
Failure to Access the DBMS Server on ArcCatalog 10.8.2
I have installed ArcGIS Desktop 10.8.2 on Win 11 but later re-installed. After re-install, I cannot connect to the geodatabase in SQL Server. The error "Failure to access the DBMS server" is shown. But I can connect to the geodatabase by SQL management studio. I have installed SQL Server native client, SQL Server ODBC…
-
Migrating from file geodatabases to enterprise geodatabase
Hi. My organization is currently relying heavily on filegeodatabases distributed on several network drives, which has been working fine for years. We're considering migrating to a new enterprise solution (ArcGIS Server + Portal and SQL Server). Each year we start approximatly 1000 new projects (and closes other ones) and…
-
Replication: Best Practice for multiple on-prem and one cloud DB
Hello Everyone, I am looking for some best practice and gotchas to get replication working effectively between two different on-prem databases and one cloud. On-prem DatabaseA needs to two way replicate with on-CLOUD DatabaseB and DatabaseB replicate(2-way) with a completely different on-prem DatabaseC. This is to make…
-
Recommended Backup/Storage Practices for Small GIS Teams
Hi! I’m looking for some advice/recommendations on practical ArcGIS Pro project storage and backup workflows for a smaller planning/GIS environment. I'm part of a smaller planning firm using ArcGIS Pro with mostly sequential workflows rather than a large multi-editor enterprise GIS setup. I’m currently trying to balance a…
-
ETL Process for SQL Tables
My DB Admins are not familiar with ArcSDE so I am trying to find guidance on proper ways to load data into SQL server tables that are registered with SDE. The data are geocoded points from another non SDE database and have a geometry filed for location data. After I register the table it is adding a new column…
-
Solutions for Creating Schema Diagrams
We need to share diagrams of our Geometric Network Schema and the Utility Network Schema we are moving to. Does anyone have a program they recommend that can help with this. All that Esri seems to have is the Schema Report, which is useful, but is not a diagram.
-
Using database backups to upgrade to 11.5
We are moving off of SQL Server 2016 to SQL Server 2022. These are two different servers. My plan is do database backups from SQL Server 2016 and restore them on SQL Server 2022. Then in some cases upgrade the geodatabase to 11.5 and others we will leave it at 10.9 until the calling applications can be updated. We will…
-
editor tracking field "locked" preventing re-enable
Hello, I turned off editor tracking on a feature class to run a massive field calculation. Now I am trying to re-enable editor tracking, using the same fields that were originally set, however I get "Error 001217: Invalid editor Tracking field in dataset...". When I open Fields View, I see that one of the previously used…
-
AlloyDB for PostgreSQL Support
Given that Esri already certifies Amazon Aurora PostgreSQL (AWS) and Cloud SQL for PostgreSQL (GCP) as managed database backends for ArcGIS Enterprise, is there any roadmap or plan to extend that support to Google Cloud’s AlloyDB for PostgreSQL?
-
Duplicate Global IDs in Separate Feature Classes Using Export/Import XML Workspace Document
We have a geodatabase with two schema owners. We will call them DBO and TN. We want to consolidate all of our feature classes to TN. The DBO feature classes have attachments and relationship classes setup. We are able to use the Export to XML Workspace Document from the DBO connection and then Import from XML Workspace…
-
Creating unique ID based on count of three attributes
I am trying to create an unique ID for a dataset based on the count of three variables. The three variables are county (55 total), district (10 total), and type (9 total). The unique ID would preferred to be structured as so: county number + district number + "-" + count of asset with a unique county/district/type +…
-
Unable to Add Spatial Reference to Database View
I'm trying to create a 1:M database view of land parcels to owners. My goal is to publish the result as a registered feature layer in Portal. I am running Pro 3.6, accessing data from a SQL database, and publishing to Enterprise 11.5. In short, here was my original workflow. 1. Run the Create Database Tool. Here's a…
-
Inspections Data Management - looking for suggestions
Hello all! I'm hoping to gather input and suggestions about best practices and data management when it comes to mapping inspections - such as outfall inspections and evaluations, stormwater inspections, etc. Here are two options in mind, with examples: 1. A feature layer for storm drains/outfalls/etc. AND an unrelated…
-
Branch Versioning Error
I'm testing out branch versioning in a new Azure based enterprise system. I have branch versioning set up with several branches and several accounts able to access them via groups on Portal. There were no red flags or issues during the setup, but now that I'm testing it I'm getting an intermittent error when I try to edit.…
-
SQL Registered Server via Database Connection in ArcPro
I have a group of Registered Servers in SQL Server Management System with over 20 servers that I can query at once. I would like to be able to connect to those servers from ArcPro. I am able to connect to the servers individually in Pro using Database Connection and Connection Properties. Is there a way to connect this…
-
Enable COGO Tool Doesn't Enable COGO
Hello, We're trying to enable COGO for a feature class so we can view the bearing and distances of each line in a stormwater pipe feature class. Running the Enable COGO tool adds the new fields but doesn't actually enable COGO. I'm using ArcGIS Pro 3.4.0, for reference. I did check this support article for the Enable COGO…
-
Interacting with data from multiple SQL DB servers
Afternoon, I have an Enterprise environment within my organization with multiple SQL server instances established for our GIS purposes. I am attempting to setup a process where we pull data from multiple other DBs on other servers (from other depts.). Seems fairly straightforward, I can run simple GP tools, run a script,…
-
What is the best way to do a mass field calculate on branch versioned data?
I added a new field to a dataset and needed to field calculate about 20k features. I started the calculation about 30 minutes ago and it is still going. Any way to speed this up?
-
Getting DBMS error on connection to database (ArcCatalog/SQL server)
Hi, after recovery our database server and pc for arcgis server/desktop etc I am getting at crating new database connection in ArcCatalog: "Unable to connect to database server to retrieve database list; please verify your server name, user name and password info and try again. Failure to access the DBMS server" Steps…
-
Data management
i am new back to GIS i used to be able select records from an existing database layer to create a new layer - but struggle to see how I do this in my student version - publisher ArcGIS - am I missing something really simple as this is a routine task and should be easy to do
-
Utility data and Homeland Security recommendations
I've heard people say that "Homeland Security" recommends separating your utility data for water and wastewater treatment plants from the rest of your system's model. (I put DHS in quotes because I cannot find a source for this claim.) A cursory Google search isn't turning up anything useful, so I thought I'd ask how…
-
Nightly batch reconcile corrupts geometric network features
We have had for years, no decades, an ArcObjects-based .NET process that reconciles outstanding versions. When reconciles are complete, a compress is initiated. This (at least until now) has run like clockwork. A few weeks ago users discovered that versions not reconciled and posted during the day, which most are, were…
-
Geodatabase in ApsaraDB RDS for SQL Server
Hello everyone, I am wondering if Geodatabase is supported in ApsaraDB RDS for SQL Server or ApsaraDB RDS for Postgres (Alibaba Cloud)? Any piece of information is highly appreciated Thanks Regards
-
Feature Class table reporting - value occurrence reporting
anyone know of a simple way to report the following on an attribute table? * Field Names* List of values in the field* Number of occurrences of each value Example: * Field Name: Phase Configuration* Yellow: 1764 * Red: 851 * Blue: 289
-
Referenced Distributed Collaboration with Branch Versioning
I am trying to set up an Enterprise to Enterprise Distributed Collaboration to allow another agency to edit my data, but it doesn't seem to work, and I'm not sure if it is a software limitation, or if it is a setup issue. Scenario Enterprise A has published feature layers with Branch Versioning enabled that are stored in…
