Latest Contributions by George_Thompson

This could be accomplished by using an Enterprise Geodatabase; https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/overview/types-of-geodatabases.htm ... View more

I am wondering if the latest version of PostgreSQL is causing an issue with ArcMap 10.7.1. Here are the supported versions for 10.7.1: https://desktop.arcgis.com/en/system-requirements/10.7/database-requirements-postgresql.htm What is the specific version of PostgreSQL (version + patch level)? Is the PostgreSQL DB an Enterprise Geodatabase? Can you test with the latest version of ArcGIS Pro (3.3)? ... View more

What is the version of the RDBMS and geodatabase? What are the permissions of the user you are connecting as to load the data? ... View more

If the data is versioned, you would have to use the versioned view to query data in the DEFAULT version. I am not sure that you can change the version in the query layer window. This could be done in SQL Server as a view. You can reconcile / post all the edits to default, then compress and it should move the edits to the base table. ... View more

I would also ask if the data is versioned? ... View more

Can you provide some more information on this: What type of data are you appending (point / line / poly / etc.)? How many records are you appending? Is the target layer a hosted layer in Online or a reference layer? Any error messages? the more details that you can provide the more feedback you may get. Thanks! ... View more

Can you provide screenshots of the SDE user permissions / settings for the instance and the database? ... View more

Can you provide more information about the plug-in? Where does it come from?   Is this it: https://mhdhabboub.com/2018/03/10/ahp-for-arcgis/   ... View more

I am not aware of another way to drop the connections without the processadmin fixed server role. ... View more

@chriscothran1 the link works, but you must sign into the site first. Look in the upper right hand corner. ... View more

I would review the documentation here for the data owner: https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-sql-server/privileges-sqlserver.htm#ESRI_SECTION1_C1C15319C6AE40B8993FDB2E89482D5F Look at the Data Creator permissions for your 'gis" user and removed the db_datareader & db_datawriter roles. For the SDE user, here are the permissions: https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-sql-server/privileges-sqlserver.htm#ESRI_SECTION1_E5B409382753421284619F35ABF001A3 I also would remove the db_datareader, db_datawriter, db_ddladmin roles. Those are not needed, based on my experience. That should get you past the errors. ... View more

Not sure this meets all the needs but a start...... https://enterprise.arcgis.com/en/server/latest/manage-data/windows/client-geodatabase-compatibility.htm   ... View more

Not sure this meets all the needs but a start...... https://enterprise.arcgis.com/en/server/latest/manage-data/windows/client-geodatabase-compatibility.htm ... View more

Look at this link: https://desktop.arcgis.com/en/arcmap/latest/manage-data/geodatabases/geodatabase-functionality-basic.htm Pro version (not as robust): https://pro.arcgis.com/en/pro-app/latest/get-started/license-levels.htm https://pro.arcgis.com/en/pro-app/latest/help/data/databases/databases-and-arcgis.htm     ... View more

No, a file geodatabase is a not based on any RDBMS and cannot be added into any RDBMS as it is a file based construct that Esri clients can use. I would recommend reviewing this doc for more details: https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/overview/types-of-geodatabases.htm ... View more