Latest Contributions by George_Thompson

Correct, you can have both Traditional and Branch versioned data in the same EGDB. Once you version (either way) a dataset, you cannot make it the other one. It is the connection files (.sde) that allows you to be Branch or Traditional for editing. ... View more

This is a tool that will report lots of information on your Enterprise Geodatabase: https://arcgismonitor.maps.arcgis.com/home/item.html?id=f343f6b2bbcf434386f6dde1e468e7ab Use the SQL below at your own risk............................... Here is some SQL that will provide size on disk. DECLARE @TblNames Table ( COUNTER INT IDENTITY(1,1), tbl_name nvarchar(100) NULL ) DECLARE @TableSizes AS TABLE ( [TblName] VARCHAR(255), [NumRows] INT, [Reserved_Size] VARCHAR(10), [Data_Size] VARCHAR(10), [Index_Size] VARCHAR(10), [Used] VARCHAR(10) ​) DECLARE @ROWCOUNT INT DECLARE @I INT DECLARE @str nvarchar(100) SET @I = 1 INSERT INTO @TblNames(tbl_name) SELECT s.NAME +'.'+t.name FROM sys.Tables t JOIN sys.Schemas s ON s.SCHEMA_ID = t.schema_id SET @ROWCOUNT = @@ROWCOUNT WHILE @I <= @ROWCOUNT BEGIN SELECT @str = tbl_name FROM @TblNames WHERE COUNTER = @I INSERT INTO @TableSizes EXEC sp_spaceused @str SET @I = @I +1 END SELECT * FROM @TableSizes ORDER BY numrows DESC   Here is some SQL with more data than above: SELECT t.NAME AS TableName, s.Name AS SchemaName, p.rows AS RowCounts, SUM(a.total_pages) * 8 AS TotalSpaceKB, CAST(ROUND(((SUM(a.total_pages) * 8) / 1024.00), 2) AS NUMERIC(36, 2)) AS TotalSpaceMB, SUM(a.used_pages) * 8 AS UsedSpaceKB, CAST(ROUND(((SUM(a.used_pages) * 8) / 1024.00), 2) AS NUMERIC(36, 2)) AS UsedSpaceMB, (SUM(a.total_pages) - SUM(a.used_pages)) * 8 AS UnusedSpaceKB, CAST(ROUND(((SUM(a.total_pages) - SUM(a.used_pages)) * 8) / 1024.00, 2) AS NUMERIC(36, 2)) AS UnusedSpaceMB FROM sys.tables t INNER JOIN sys.indexes i ON t.OBJECT_ID = i.object_id INNER JOIN sys.partitions p ON i.object_id = p.OBJECT_ID AND i.index_id = p.index_id INNER JOIN sys.allocation_units a ON p.partition_id = a.container_id LEFT OUTER JOIN sys.schemas s ON t.schema_id = s.schema_id WHERE t.NAME NOT LIKE 'dt%' AND t.is_ms_shipped = 0 AND i.OBJECT_ID > 255 GROUP BY t.Name, s.Name, p.Rows ORDER BY t.Name   ... View more

Looks like you can do this with either of these tools: https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/split-raster.htm https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/create-raster-dataset.htm Look at the options for each tool. ... View more

Is this machine the same one that you posted about the tile package crashing? https://community.esri.com/t5/arcgis-enterprise-portal-questions/portal-suddenly-down-in-the-middle-of-publishing/m-p/1638720   ... View more

It looks like those tables / files are used by users on the Enterprise Geodatabase. I am not sure I would truncate those table, unless all connections are not active and closed. ... View more

So are portal and hosting server on the same machine? What is the CPU / RAM of the machine look like during this issue? ... View more

You may want to reach out to technical support about this and work with a geodata analyst. ... View more

Usually not directly. You have "publish" something from the PostgreSQL database that is accessible to Online, like a map / feature service. This can be done with ArcGIS Server or ArcGIS Enterprise. Is the "goal" to connect your local PostgreSQL DB to Online? I looked at Data Pipelines and Velocity (both hosted in ArcGIS Online), but direct connection to PostgreSQL is not supported: Velocity: https://doc.arcgis.com/en/velocity/ingest/what-is-a-data-source-.htm Pipe Lines: https://doc.arcgis.com/en/data-pipelines/latest/connect/connect-to-your-data.htm ... View more

Here is a good blog from @MarceloMarques : https://community.esri.com/t5/mapping-and-charting-enterprise-databases/how-to-upgrade-the-postgresql-and-postgis-version/ba-p/1307075 ... View more

Have you tried a different browser or cleared the cache from your current browser? I would think if you can see them in Pro, that the data is still there but something in the UI. ... View more

There are a few things to unpack in your questions........ If you have to migrate to from SQL authenticated data owner to AD data owner, you will have copy over the data to the new owner. You cannot just "update" the owner from user1 to AD\user1. If data is owned by "AD\user1" and they leave the organization (and their account is turned off), no one else would be able manage the feature class. This can be a huge pain.......... I would recommend that you just have a specific data owner, then use AD groups for editing and viewing the feature classes. There maybe some geodatabase functionality, like Parcel Fabric, require the data to be owned by SQL data owner. Here is some related documentation: https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-sql-server/user-accounts-groups.htm https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-sql-server/add-users-sqlserver.htm     ... View more

Here is another post related to those log file entries: https://community.esri.com/t5/arcgis-enterprise-portal-questions/datastore-missing-table-sde-logfiles/m-p/1613615 ... View more

This is important to understand when designing the data and storage. I have seen people have both in a single EGDB and it works well. One of the biggest things that I see is related to lack of administration and maintenance of the EGDB that cause the most issues. ... View more