Database view drops all field alias values Have a simple view that combines two layers using Union.  SQL server is the SDE backend. Both layers match exactly and have friendly alias field names with spaces. My view completely dropped the alias values on the view.  There is no way to edit them either. I see similar posts but nothing for exac...

#GeodatabaseAdministration #DataDesign

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

Insert/Update/Delete rows in a feature classes with Versioned and Archived We have been updating/inserting/deleting using append tool for the data on regular basis from non spatial database (weekly).  I have looked at different options to do,   1. Append tool : I tried this tool to update the data on regular basis ( which is taking longer time then expected), sometimes, Up...

#GeodatabaseAdministration #Enterprisegeodatabase

I need a tool or a process that does the reverse of the 'Enable Enterprise Geodatabase' tool. I have run the 'Enable Enterprise Geodatabase' tool from ArcGISPro 3.5.1 against a SQLServer database. This has created a number of SDE objects in the dbo schema. How do I cleanly remove these SDE tables, views, stored procedures etc and in doing so effectively remove the SDE geodatabase without de...

#Databases #GeodatabaseAdministration

I am the data owner, but am getting User is not the data owner message I'm using ArcGIS Pro 3.4.0. I need to re-version a feature dataset, and yesterday when I went to do this, I realized that I did not have the right server role to disconnect users, so I went into SSMS and changed myself to a sysadmin. I was already the database owner. Now, even though the option for ...

#GeodatabaseAdministration #Enterprisegeodatabase

Attribute Indexes in SQL geodatabase Hi all, How do I check on the attribute index of a feature class in a SQL geodatabase? What it is, if it's functioning as it should, etc? I see this: "If you're choosing an indexing strategy for an enterprise geodatabase, refer to your DBMS documentation for more detailed guidance." from https://pro...

#Databases #GeodatabaseAdministration

ArcSDE Feature class extent is in inconsistent spatial reference system. A feature class in our enterprise geodatabase seems to have an extent with inconsistent coordinates. See attached image.   It appears that the lower left bounding coordinates are in unprojected/lat long coordinates when the feature class should be stored in 26915 NAD 83 15N.   The upper right coordi...

#Databases #GeodatabaseAdministration

Upgraded Oracle 19c eGDB from 11.1 to 11.4 using ArcGIS Pro 3.4 - Invalid Indexes / dbms_utility.compile_schema Hello Everyone On our TEST system we upgraded Oracle 19c eGDB from 11.1 to 11.4 using ArcGIS Pro 3.4 After the upgrade we got a number of Invalid Indexes SELECT * FROM DBA_OBJECTS WHERE STATUS!= 'VALID' ORDER BY OWNER, OBJECT_TYPE, OBJECT_NAME; OWNER             OBJECT_NAME           OBJECT_TYPE STA...

#Databases #GeodatabaseAdministration

ArcGIS Enterprise Upgrade status Hi,  I recently upgraded our enterprise geodatabase in ArcGIS Pro after the sql database was upgraded.  All of the database had a status 11.0.0.3.0 except one and I am not sure if it's an issue  It says " This ArcGIS Pro 3.3.0 - 11.3.0.52636 geodatabase is up to date." Does anyone know why its diffe...

#GeodatabaseAdministration #Enterprisegeodatabase