-
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…
-
Underlying dbms error ora-00001 unique constraint violated
Dear all, Please help me with this error : Underlying dbms error ora-00001 unique constraint (RETEAD.BT_NODIRIGIDI_PK) violated . I work with ArcMap 10.8 with other users. When starting editing, each user creates their own version, which reconciles with the default when finished. For several months, we've been receiving…
-
PostgreSQL - EGDB - Branch Versioned Data Migration
Has anyone had success in migrating Branch Versioned Datasets to a new database instance while maintaining branch history? We are working through a migration from a Windows Server 2019 hosted PostgreSQL 15 instance into a PostgreSQL 15 RDS instance in AWS and have had some trouble maintaining branch history with…
-
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.
-
Post to default queue
I was wondering if somebody has more information on how ArcGIS handles queues of versions posting to sde.default. Is there a limit on how many versions ArcGIS can handle? Will there be a time out? Is there a possibility that some posts won’t go through (with the exception of conflicts of course)? I tried to check the…
-
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?
-
PostgreSQL Logical replication of Geodatabase
Hi All, Has anyone attempted to use PostgreSQL database replications to mirror an ArcSDE Geodatabase instance from one place to another? Cheers, Mark
-
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…
-
How to find a field in all FC inside a FGDB
Good afternoon, Is there a way to identity all the feature classes that use a specific field in a FGDB?
-
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…
-
Personal geodatabases: How were annotation reference scales determined?
Note: I know that Personal Geodatabases are deprecated. Please do not inform me of that here, I am well aware. That being said, I'm working on a project involving them here and could use some help. ArcMap is not an option for me. How were annotation reference scales in personal geodatabases determined? For example, I have…
-
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,…
-
Cant access data through Scheme Lock
I created several .GDBs months ago, I use them daily and I've never had an issue opening them. Suddenly there is a schema lock and I cant acquire the data. I can open and edit the data that already loaded in the maps I work with but I cant open the .GDB in catalogue or add new data from the GDB to my map. I am the only one…
-
Attribute Validation / Calculation using Arcade or Database Trigger
I am just wondering if Attribute Validation is better with Database Trigger or Arcade. Suppose I want to do Attribute Validation about the value of one coloumn that depends on the value of another coloumn OR maybe I want to limit the data entry of a coloumn OR maybe I want to populate a date coloumn automatically. In a…
-
Query Layer (Oracle) using SDO_BUFFER does not show(draw) geometry
Hello everyone, I am facing some issues with the Query Layer and would appreciate it if someone could assist me in resolving this problem. I am working with an Oracle 19c database that includes the Spatial Data Module, and it contains a view displaying real-time mobile positions. My goal is to represent a security area on…
-
SQL database (2022) Collation for UN
We are setting up a new SQL database (2022) for the UN (Portal 11.5 / Pro 3.5) and I would like some help picking the new collation. My research is suggesting sql_latin1_general_cp1_ci_as, but I also see some post suggesting it is a legacy collation and that modern apps should use a Unicode-compliant collation. We only…
-
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…
-
Support for PostgreSQL TSVector usage with Full Text Search
Add EGDB support for using PostgreSQL tsvector usage with Full Text Search. Add Full-Text Index (Data Management)—ArcGIS Pro | Documentation
-
FeatureClass registered but not visible
Hi all... I'm trying to create a new FeatureClass on a DB Postgresql 11.12 via ArcgisPro 3.0.6 but the geoprocessing says that the name already exists. In the catalog pane I cannot see it but if I query the sde_table_registry table, that name is present. It's present also in sde_layers and sde_geometry_columns but not…
-
How to use Python to report version changes
I am running ArcGIS Pro 3.4.3, with its Python 3.11 interpreter. I have created a tool written in Python that takes a SDE file as input and loops through the child versions listed within that SDE file, trying to gather and report the version differences (inserts, updates, deletes) for each of those child versions. The code…
