Latest Contributions by George_Thompson

I have a few questions: Are you still planning on using ArcGIS Pro for editing the data if you move to PostgreSQL? Do you have multiple editors of the data at the same time? Are you publishing out the data to services of any kind? Is ArcGIS Enterprise (or Server) used at all? Generically, you will lose the true functionality of the geodatabase if you move to PostgreSQL. This means that things you list above, plus other advanced geodatabase functions like topology / networks / feature datasets / / etc. There are also some limitations if the data is in a database (with / without spatial type): https://pro.arcgis.com/en/pro-app/latest/help/data/databases/databases-and-arcgis.htm Editing: https://pro.arcgis.com/en/pro-app/latest/help/data/databases/databases-and-arcgis.htm#ESRI_SECTION1_A188C2B1C8C54C7DA3233892FC742552 Hope this helps! ... View more

Not an expert in this area, but I have seen people who automate do it in batches (of like 500 - 1000), which cuts down on the potential impact of a "limit". This is mainly using Python or something like that. ... View more

There may be a timeout on the service side causing the error after a certain period. I have also seen machine resources cause issues when exporting data from a service. Do you own the WFS service? ... View more

The other thing would be to repoint your services to the new SQL Server instance. Here is some information and process to investigate: https://community.esri.com/t5/arcgis-enterprise-documents/update-arcgis-server-services-after-sql-server/ta-p/1181710   ... View more

Take a look at the notes here before you run the upgrade: https://pro.arcgis.com/en/pro-app/3.5/help/data/geodatabases/manage-sql-server/upgrade-geodatabase-sqlserver.htm Also, after the restore, you need to make sure that you re-sync any database logins (SDE, DATA, GIS, etc.): https://support.esri.com/en-us/knowledge-base/re-synch-sql-server-logins-or-users-after-restoring-a-d-000008079 before connecting to the EGDB in Pro. ... View more

Here is the documentation to support this: https://enterprise.arcgis.com/en/system-requirements/11.5/windows/database-requirements-sqlserver.htm ... View more

I would recommend reaching out to technical support to investigate if it is related to the release last night. ... View more

Steps on copying data to another schema? ... View more

Have you checked the spatial index? Does the layer render in Pro correctly, after you zoom in & out? Try rebuilding it. ... View more

@RiceAdam I do not have any updates and would recommend working with technical support on this. It is possible that these are logged but red herrings. ... View more

I would create a new thread for this issue....... if you are wanting to migrate your PostgreSQL EGDB to Pro, what version of Pro are you using? You will need to make sure that your version of PostgreSQL is supported with that version of Pro. Here is the doc for Pro 3.6.x: https://pro.arcgis.com/en/pro-app/latest/help/data/databases/database-requirements-postgresql.htm If it is not supported with your version of Pro, you will need to upgrade to a supported version first, then download the appropriate ST_Geometry library/ ... View more

Not a developer, but here is a post asking a similar question (converting a code base from  ArcObjects SDK for .NET into ArcGIS Pro SDK): https://community.esri.com/t5/arcgis-pro-sdk-questions/arcobjects-sdk-to-arcgis-pro-sdk-conversion-guide/td-p/1050958 see the accepted answer. I am guessing that is what you are asking, since you did not provide more on the 10.8.2 files. ... View more

Here is a technical article related to this: https://support.esri.com/en-us/knowledge-base/problem-transaction-logs-are-retained-in-the-walarchive-000024976 Here is some additional documentation: https://enterprise.arcgis.com/en/portal/11.5/administer/windows/common-problems-and-solutions.htm#anchor30 https://community.esri.com/t5/arcgis-enterprise-questions/manually-delete-files-in-walarchive-folder/td-p/1237418 Hope this helps! ... View more

I am not 100% sure, but do not think so. Based on the doc above, it does not appear to be needed. Just remember that it will NOT be a geodatabase if you add the ST_Geometry type. It will just add another spatial storage method. I am not sure why you would want to have both in the database without the GDB functions. What are you going to do with ST that you cannot do with PostGIS? ... View more