Latest Contributions by George_Thompson

I am not sure how to specifically make it faster, but can say that if it takes 20-26 seconds in pgAdmin, then it would take around that long in a service. I would also think that 2,000,000 points would return faster than 20+ seconds, but that is not knowing all the complexities. How long does it take to run a "select *" from the table with no filter / group by? ... View more

I would add Utility Network, Updated Annotation (I think) to the list ... View more

I would work directly with your Esri account manager or distributor to potentially obtain any more information on this. ... View more

Is it all tables in PostgreSQL that are slow or only certain tables? How many records? Do the records cover a large geographic area? What is the geometry of the table? Can you provide the version of ArcGIS Enterprise & PostgreSQL being used? ... View more

Is the SQL Server running on a custom port? Can you install SSMS on the ArcMap machine and make a connection with SQL Server? What specific ODBC driver is installed: https://desktop.arcgis.com/en/system-requirements/latest/database-requirements-sqlserver.htm#ESRI_SECTION1_B75DB4BEF4BF40348621F378FB8F9FD8 Have you rebooted the machine since the install of the ODBC driver? ... View more

What version of ArcMap are you using? What is the RDBMS and version being used? Does ArcMap have the correct version of the client drivers installed? ... View more

I am not sure what would be next, since it seems that the layer is already part of the geodatabase so trying to register it is not a path forward. Are you sure that the database is already enabled as an Enterprise Geodatabase?  Based on the screenshot at the top, it looks like this is a view? How was the SDE user created? ... View more

Based on the screenshot, it looks like SDE is the data owner. You would need to connect as the SDE user to make the changes. It is also not recommended to have data owned by SDE. Can you provide some more info if SDE is not the data owner? Even connecting as SA does not allow you to make some changes within the Pro client. ... View more

For Pro & Server, try the ODBC 17.x client, that may work better. That is what I have on my machine with Pro 3.2.2 / SQL 2022. I also recommend trying to connect from SSMS on that same machine. That. ... View more

Can you provide the following information: - Version of Enterprise installed? - Version of SQL Server being used? - ODBC Driver installed on the Enterprise server machine? Any other supporting information. Thanks! ... View more

I would recommend contacting the hosting agency: https://www.stancounty.com/itc/ I just searched based on the domain name and looked for GIS. ... View more

Here is a great site that provides some guidance on these topics: https://doc.arcgis.com/en/imagery/workflows/ ... View more

I would recommend upgrading to 10.8.2 at least. 10.6.x was retired earlier this year and is no longer supported: https://support.esri.com/en-us/products/arcmap/life-cycle ... View more

do you have any tables in an SDE schema within that database? I usually only see that message when there is an EGDB that has an expired license. I noticed that you mentioned it was "not created with SDE privileges", but could be an SDE schema. If there is an SDE schema, look at the SDE.Server_Config table and the AUTHKEY (I think) field. ... View more

What version of Oracle are you connecting to? Is the Oracle DB an Enterprise Geodatabase? Can you verify that you are using Pro 3.2.x to make the connection to the Oracle DB? The error indicates that it is looking for a geodatabase, but could be incorrect. ... View more