-
Weird files in a File Geodatabase (FGDB) that crash custom python script
We have GIS data in users folders going back a couple of decades. I've been running a custom python script that inventories all files and identifies gis file types. It sort of works, but is crashing on a handful of old file geodatabases from 2009 that contain a bunch of weird files I've never seen before. File geodatabases…
-
Question about AD Groups in SQL & permissions
Not sure if this is the right place to ask this, was curious if anyone could point me in the right direction. We created a new AD group, added it to our SQL server. The users in this group, when they connect through SSMS, they are able to create tables with "dbo" as the data owner. In ArcGIS pro... they can connect to the…
-
Error Connecting to Enterprise Geodatabase (SQL Server)
Good afternoon. Our organisation runs Enterprise 11.3. Our data is held in an Enterprise Geodatabase hosted in an Azure SQL Logical Server. For many years we have accessed the data in the SQL database using SDE connections in ArcGIS Pro from various Azure VDIs without any significant issues. We are now looking to enable…
-
Excessive archive growth from duplicate/no-op history records — has anyone dealt with archive bloat?
I'm investigating a performance issue in an ArcGIS Enterprise geodatabase on SQL Server and wanted to see whether others have run into similar archive growth problems. Environment: * ArcGIS Enterprise 11.3 * Traditional versioning with archiving enabled * SQL Server backend * Feature class has approximately 118.5K active…
-
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…
-
Unable to move feature class from one dataset to another in Enterprise Geodatabase
I'm having trouble moving feature classes from one dataset to another in an Enterprise Geodatabase, despite the fact that we are not currently using versioning, the Enterprise geodatabase has been compressed, and the feature datasets have the same spatial reference. I have to move the feature class to a file geodatabase,…
-
Can't see change reflected from specific time and date - from historical moments archiving
Hi all, i cannot see the change reflected when I go to a specific date and time. The total records should say 3247, not 3246. I noticed in the feature class source, it states archiving is disabled..could that be it? Any ideas? thanks!
-
Database Driven Feature Binning
I have enabled binning on a SQL server database table that I have and am using database compute to handle the binning without using cache bins. When enabling binning a couple fields are added to the table. The geo_fhexstr_4326 filed is the only one with data and the bins render great. My challenge is we have a process to…
-
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…
-
Can't get rid of attribute rule
Update: This has been resolved - I have created attribute rules for calculating values within a feature class. I needed to correct the logic, but it still runs the old rule. I deleted the rule, and yet, the calculation is still performed. This is happening in both file geodatabase and enterprise geodatabase. I found the…
-
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
-
SAP Hana Copy/Paste Issues
We’re in the middle of our utility network transformation and running into a persistent issue that we haven’t been able to resolve. We’re moving our gas system data into SAP HANA (HANA in the cloud, but not RISE). Our architecture is cloud‑based end‑to‑end: an Azure VM running ArcGIS Pro connecting to HANA in the cloud.…
-
Field calculating 4500 records that is in a branch versioned feature service takes an hour. Is that normal?
If I export the same feature class to my local PC and run the same calculation there, it takes less than 30 seconds. Surely this can't be the expected behavior for ESRI's chosen versioning architecture going forward?
-
st_shapelib.dll on Windows
Hello Geodatabase, has anyone had any success, or failure, using a recent st_shapelib.dll with an Oracle 19c Geodatabase running on Windows? If I place a 3.4 or 3.6 st_shapelib.dll in the relevant folder and run a simple test, I see this error. SQL> select sde.ST_AsText(SDE.ST_Geometry('POINT (10 10)', 0)) from dual;…
-
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?
-
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…
-
Feature class requests timing out and consuming 100% of CPU on database machine
We have already resolved the issue, but I'm posting because we're still trying to understand why this happened and I wanted to see if anyone has encountered this issue before and has any ideas on what might have caused it. Three days ago, after nothing changed that we could determine, our parcels feature classes which are…
-
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…
-
branch versioning historical moment
Hello, I'm trying to create a historical marker in my enterprise geodatabase on a dataset containing branch-versioned feature classes (from a Utility Network). However, I can't find any documentation regarding the availability of this functionality with branch versioning. When I access the data directly from the .sde file,…
-
Prune Branch History not deleting records.
Hello everyone! The tool in question: Prune Branch History (Data Management) Versions: Pro - 3.5.3 Server - 11.5.0 Trying to use the Prune Branch History tool to remove test data from a dataset. This inspections table is related to a feature that is part of a Utility Network dataset. The inspection table and the Utility…
-
Does historical data persist when unregistering and then re-registering a feature class?
Hello, When I temporarily unregister a feature class as versioned in ArcGIS Pro and then later re-register it as versioned, do I still have access to all of its historical data after re-registering? Best regards
