Latest Contributions by MarceloMarques

@ChristopherBowering - glad to know that you have resolved the problem. : )

@ahagopian_coj - The recommendation is to have all ArcGIS Software ( ArcGIS Pro, ArcGIS Enterprise: Portal, ArcGIS Server) and the ArcSDE Geodatabase Repository at the same version. Client and geoClient and geodatabase compatibility—ArcGIS Server | Documentation for ArcGIS Enterprise database compatibility—ArcGIS Pro | Documentation

@KikSiops If it is a PostgreSQL vulnerability, then install the latest PostgreSQL update. PostgreSQL: CVE-2024-0985: PostgreSQL non-owner REFRESH MATERIALIZED VIEW CONCURRENTLY executes arbitrary SQL I explain how to patch PostgreSQL in the white papers below. How to Upgrade the PostgreSQL and PostGIS version for the Enterprise Geodatabase on Windows How to Upgrade the PostgreSQL and PostGIS version for the Enterprise Geodatabase on Linux I hope this clarifies.

@AndreaB_ - if possible, it might just be easier if you create a new empty SQL Server Geodatabase with ArcGIS Pro 3.2.2, and then reload the data from the old 10.0 geodatabase into the new geodatabase.

My 2 cents to contribute to this discussion. SQL Server - need to buy licenses, do not go with standard edition, you need enterprise edition because it has nice features like rebuild indexes online, parallelism, etc., backup and recovery is easier, can do point in time recovery really easy, Esri uses the native SQL Server Spatial data types to store the spatial data, there is no esri st_geometry spatial type in SQL Server, also get the SQL Server security updates and technical support. SQL Server supports Windows Authentication, very easy to setup. SQL Server can run on Windows and Linux as well. PostgreSQL: free open source, but backup recovery not as easy, point in time recovery difficult, need to install PG updates and if using PostGIS then install the PostGIS updates as well, Esri has st_geometry spatial type for PostgreSQL, decision to use esri st_geometry or PostGIS is up to the customer to decide, many customers pay for the EnterpriseDB solutions on top of PostgreSQL for their deployments, and EnterpriseDB can help with paid technical support. How to Upgrade the PostgreSQL and PostGIS version for the Enterprise Geodatabase on Windows How to Upgrade the PostgreSQL and PostGIS version for the Enterprise Geodatabase on Linux How to Configure Windows Authentication for the PostgreSQL Enterprise Geodatabase I hope this helps. Enterprise Geodatabases Best Practices visit my community.esri.com blog. Mapping and Charting Solutions (MCS) Enterprise Da... - Esri Community

@OmarF93 - please open a ticket with Esri Technical Support to investigate the problem further, if you learn anything new then share in this thread to help other people. Thank you. : )

@AndreaB_ - You cannot have both ODBC 18 and 17 installed on the same machine, the workaround is to uninstall ODBC 18 and keep only ODBC 17, then both ArcMap and ArcGIS Pro will be able to connect. I mention this issue in my community.esri.com white paper below. How to Install the SQL Server Client for ArcGIS?

@wgreen90 Introduction to attribute rules—ArcGIS Pro | Documentation

@KiwiGISmapster - you might also consider. Replication and geodata services—ArcGIS Pro | Documentation ArcGIS Server allows you to configure geodata services using ArcGIS Pro. A geodata service provides access to a geodatabase remotely using ArcGIS Server. Beginning with the ArcGIS Pro 3.0 release, you can share a geodata service to ArcGIS Enterprise 10.9.1 or higher. If you have a stand-alone ArcGIS Server, you can save an offline service definition and then publish it to your stand-alone ArcGIS Server. If you have existing legacy geodata services created via ArcCatalog or ArcMap, you can use them in ArcGIS Pro to create and synchronize replicas. If you upgrade your ArcGIS Server, with legacy geodata services, to version 11, you must change the service runtime to ArcGIS Pro. See migrating to the ArcGIS Pro service runtime for more details. The geodatabase replication tools support local geodatabases through geodatabase connections and remote geodatabases through geodata services. Wherever a geodatabase connection is required, you can supply your geodata service instead. The geodata services are accessed via server connections in ArcGIS Pro.

@KiwiGISmapster 1. AWS Workspaces - ArcGIS Pro installed 2. AWS EC2 Instance - ArcGIS Pro installed Windows Server Remote Desktop Role to allow multiple users to remote connect. 3. ArcGIS Server Map Service 4. ArcGIS Server Geodata Service Geodata service—ArcGIS Server | Documentation for ArcGIS Enterprise 5. ArcGIS Geodatabase Replication Geodatabase replication fundamentals—ArcGIS Pro | Documentation 6. Replication and geodata services—ArcGIS Pro | Documentation I hope this helps.

@ChristopherBowering - You mentioned that you have recently upgraded several EGDBs from 10.8.1 directly to 11.1 and that was when you started to experience issues with the ArcGIS Server 11.1 services. This might be relevant to your problem, please read. What's new in ArcGIS Pro 3.0—ArcGIS Pro | Documentation Restoring SQL Server databases with a new name (esri.com) You might want to mention this in your esri support ticket #03601725.

@ChristopherBowering - please share the esri support case number, if I learn anything new about your problem, I let you know.

@ChristopherBowering Question: Have you heard of any user/connection specific problems after performing a EGDB upgrade in regards to publishing? Answer: I did not hear of any issues. You can trace the service request using Fiddler, that might help diagnose further. Monitoring web service requests using Fiddler - Esri Community How To: Use Fiddler to Capture Https Connections and Decrypt Https Traffic (esri.com) You shall open a ticket with Esri Technical Support to investigate the issue as well.

@ChristopherBowering - if all services were published with Pro, then check the SQL Server machine cpu and memory utilization, in SQL Server Activity Monitor you can see things like waits and active expensive queries, something might show up there, you can also enable SQL Server Query Store on the database to help diagnose database performance further, see SQL Server documentation, next you can bring each featureclass into ArcGIS Pro and make sure the performance to draw is acceptable, make sure the geodatabase maintenance is executed often, e.g., sde compress (if working with traditional version), gather new statistics, rebuild indexes (attribute columns and spatial). If this test passes, then the issue is not with the SQL Server Instance nor with the SQL Server Database nor with the Geodatabase. It must be something in ArcGIS Server Services, next I would try to reboot the ArcGIS Server machine to see if things clear up, and monitor, for the services affected, I would check the cpu/memory utilization in the ArcGIS Server machine, and then tune the min/max number of SOC processes of each ArcGIS Server service according to the workload, I would also look into the ArcGIS Server Logs in debug mode to see if any useful info show up. I hope this helps.

@ChristopherBowering - You might have to republish your services using ArcGIS Pro, see the documentation below. What's new in ArcGIS Enterprise 11.0—ArcGIS Enterprise | Documentation for ArcGIS Enterprise Migrating services to the ArcGIS Pro service runtime—ArcGIS Server | Documentation for ArcGIS Enterprise Client and geodatabase compatibility—ArcGIS Server | Documentation for ArcGIS Enterprise You do not have to keep your geodatabase and ArcGIS clients at the same release, but it is recommended that you do so. Geodatabases and client software are designed to work together, and if you let one get too many releases away from the other, you risk encountering problems or unexpected behavior. This is especially true when you use a mix of client versions at your site. A newer client can create newer dataset types in the geodatabase that older clients cannot access. For enterprise geodatabases, waiting too long between geodatabase upgrades may mean you have to upgrade the underlying database more than once before you can upgrade the geodatabase. I hope this helps.

Online Status	Offline
Date Last Visited	Tuesday

My Ideas

Latest Contributions by MarceloMarques

Re: Upgrade Enterprise Geodatabase from 10.8.1

Re: Upgrade Enterprise Geodatabase from 10.8.1

Re: CVE-2024-0985 - PostgreSQL security bypass vulnerability

Re: Upgrading Enterprise Geodatabase from 10

Re: Differences and benefits between SQL Server corporate geodatabase and PostgreSQL with PostGIS extension

Re: group managed service account for arcgis server

Re: version of Microsoft ODBC driver for SQL Server 2022 but with SQL set to 2019 compatibility mode to work with ArcMap?

Re: Auto apply Shape.STLength measurements to new Shape_Len field

Re: Is AWS Workspace the only solution to give users access to SDE DB on AWS?

Re: Is AWS Workspace the only solution to give users access to SDE DB on AWS?

Re: Upgrade Enterprise Geodatabase from 10.8.1

Re: Upgrade Enterprise Geodatabase from 10.8.1

Re: Upgrade Enterprise Geodatabase from 10.8.1

Re: Upgrade Enterprise Geodatabase from 10.8.1

Re: Upgrade Enterprise Geodatabase from 10.8.1

Re: CVE-2024-0985 - PostgreSQL security bypass vul...

Re: Upgrading Enterprise Geodatabase from 10

Re: Differences and benefits between SQL Server co...

Re: version of Microsoft ODBC driver for SQL Serve...

Re: Auto apply Shape.STLength measurements to new ...

Mapping and Charting Enterprise Databases

Group Owners Group