topic Re: Does the SDE.GDB_REPLICA table exist in 10.1? in Data Management Questions

Does the SDE.GDB_REPLICA table exist in 10.1?

MattSimmons — Mon, 07 Jan 2013 12:57:47 GMT

In my old 9.2 instance there is an SDE.GDB_REPLICA table which holds the names of each replica. In my 10.1 instance this table is not present, even though I have replicas and they are all sync'ing fine. Is this a change in the 10.1 architecture or is my database screwy? If this is normal, how do I go about identifying orphaned replicas? (In my old database I'd compare replica ID's in the SDE.GDB_REPLICA vs. SDE.VERSIONS to identify any orphaned replicas)

Re: Does the SDE.GDB_REPLICA table exist in 10.1?

AsrujitSengupta — Mon, 07 Jan 2013 13:54:38 GMT

Matt,

You can look at the following links for the system tables information in 10.1:

Oracle: http://resources.arcgis.com/en/help/main/10.1/index.html#//002n0000008m000000
SQL Server: http://resources.arcgis.com/en/help/main/10.1/index.html#//002q00000080000000

I guess the GDB_Replicalog table should provide you with the necessary informations.

Regards,

Re: Does the SDE.GDB_REPLICA table exist in 10.1?

MandarPurohit — Sat, 11 Dec 2021 16:40:54 GMT

In my 10.1 instance this table is not present, even though I have replicas and they are all sync'ing fine. Is this a change in the 10.1 architecture or is my database screwy? If this is normal, how do I go about identifying orphaned replicas?

Hi Matt,

The geodatabase schema has been restructured at ArcGIS 10.0 (and forward), consolidating the information from 'GDB_xxx' tables into six tables (and making use of XML columns), hence there is no GDB_Replica table after upgrading the geodatabase to 10.0 or 10.1.

The webhelp link XML column queries illustrates querying the XML columns.

The following sample could be used to query replica info (ID, Replica_Name, Replica_Version and Date_creation) in SQL Server:

SELECT  
ITEMS.Definition.value('(/GPReplica/ID)[1]', 'nvarchar(max)') AS "ID",
ITEMS.Definition.value('(/GPReplica/Name)[1]', 'nvarchar(max)') AS "Replica Name",
ITEMS.Definition.value('(/GPReplica/ReplicaVersion)[1]', 'nvarchar(max)') AS "Replica Version",
ITEMS.Definition.value('(/GPReplica/CreationDate)[1]', 'nvarchar(max)') AS "Creation Date"
from 
 dbo.GDB_ITEMS AS ITEMS INNER JOIN dbo.GDB_ITEMTYPES AS ITEMTYPES
 ON ITEMS.Type = ITEMTYPES.UUID
WHERE 
 ITEMTYPES.Name = 'Replica';

Regards,
Mandar