SQL Server 2022 Compatibility Level and ArcGIS Enterprise We are migrating from our old SQL Server 2016 to a new SQL Server 2022, with plans to upgrade ArcGIS Enterprise from 10.9.1 to either 11.1 or 11.3. As part of the migration, we noticed that the database on SQL Server 2022 is currently set to the SQL Server 2016 (130) compatibility level. I am not ve...

#DatabaseAccess #Geodatabase

Wrong column type error with Oracle Spatial 19c Hi there, Having problems with getting spatial data out of an Oracle 19c database.  Reading the data in with the Check Geometry tool outputs the following errors;Start Time: 29 July 2025 15:24:48 ERROR 999999: Something unexpected caused the tool to fail. Contact Esri Technical Support (http://esriu...

#DatabaseAccess #Geodatabase

Process to migrating the SQL Authentication admin user to AD Authenticated User and it's limitations HI Team, We are using ArcGIS Enterprise Base deployment of 11.3v with SQL Server 2019v in the Azure cloud. From the inception we are using the SQL authenticated admin user to manage the GDB management activities. Many of the ArcGIS Web services are published with this SQL auth credentials. These GI...

#DatabaseAccess #GeodatabaseAdministration

SDE Files: show specific tables per file but NOT based on permissions? This is another question that's hard to articulate, but does anyone know a way to make it so specific SDE files filter down what tables are shown, without having to sign in as a specific user? Example: I have an Enterprise GDB with like 100 items in it. They're more or less organized into feature da...

#DatabaseAccess #Enterprisegeodatabase

"Tag" geodatabase items to filter what you see when you open the connection? This is kind of hard to articulate but. I'm wondering if anyone knows a way to throw everything into a geodatabase, then only show tables that you designate as like, "active"? For example, for one of my file systems, each project, as we get it, has the original files stored in a dated folder, and th...

#DatabaseAccess #Databases

Much Broader Support for PostgreSQL and PostGIS ArcGIS has two(?) methods of connecting to an external database. One is https://pro.arcgis.com/en/pro-app/3.3/help/data/databases/database-connections-in-arcgis-pro.htm  This doesn't work with any tools in ArcGIS.   Another is query layer: https://pro.arcgis.com/en/pro-app/latest/help/mapping/layer...

#DatabaseAccess #postgresql

Try to delete Reference registered data which published from ArcGIS Pro to Portal I have published some feature classes from an SDE Geodatabase to Portal using ArcGIS Pro as reference registered data. These datasets need to be overwritten daily using FME. However, when I try to delete the data through FME, I get an error saying the data is locked. Has anyone experienced this issu...

#DatabaseAccess #Databases

Illinois Supreme Court ruling limits public access to government database structures
mchap.io/losing-a-5yr-long-illino...
#foialitigation #dataprivacy #governmenttransparency #databaseaccess #publicrecords