|
POST
|
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
08-14-2025
07:36 AM
|
0
|
0
|
2549
|
|
POST
|
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
08-14-2025
04:20 AM
|
4
|
0
|
1268
|
|
POST
|
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
08-05-2025
03:41 AM
|
1
|
0
|
407
|
|
POST
|
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
08-04-2025
03:49 AM
|
0
|
0
|
1076
|
|
POST
|
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
08-04-2025
03:48 AM
|
1
|
0
|
533
|
|
POST
|
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
08-04-2025
03:45 AM
|
0
|
1
|
1079
|
|
POST
|
You may want to reach out to technical support about this and work with a geodata analyst.
... View more
07-29-2025
09:23 AM
|
0
|
0
|
2202
|
|
POST
|
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
07-22-2025
03:36 AM
|
0
|
0
|
460
|
|
POST
|
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
07-21-2025
12:50 PM
|
1
|
0
|
3356
|
|
POST
|
Most people using Oracle create the database in Oracle, then you can run either tool (Create / Enable - if you have the SDE user already). Here is the doc on this: https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-oracle/setup-geodatabase-oracle.htm
... View more
07-17-2025
06:08 AM
|
1
|
1
|
1409
|
|
POST
|
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
07-10-2025
03:40 AM
|
0
|
0
|
893
|
|
POST
|
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
07-09-2025
10:12 AM
|
0
|
1
|
712
|
|
POST
|
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
07-02-2025
04:49 AM
|
0
|
0
|
2050
|
|
POST
|
I have seen many people upgrade to 10.9.1 first. Then verify that everything is good and all the items that are not in 11.x are taken care of. Then upgrade to 11.3 / 11.5 from 10.9.1. The important part is to make sure you have a verified backup before the upgrades and reviewed all the relevant documentation for the version that you are moving to.
... View more
06-25-2025
10:37 AM
|
1
|
0
|
1360
|
|
POST
|
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
06-25-2025
09:10 AM
|
0
|
0
|
1660
|
| Title | Kudos | Posted |
|---|---|---|
| 1 | 2 weeks ago | |
| 1 | 3 weeks ago | |
| 1 | 04-09-2026 12:08 PM | |
| 1 | 04-07-2026 07:52 AM | |
| 1 | 03-30-2026 03:50 AM |
| Online Status |
Offline
|
| Date Last Visited |
yesterday
|