Create Replica from Server Fails with Error 000775

RobertChaney — Tue, 30 Jul 2013 18:02:24 GMT

I'm receiving an error message when running the Create Replica From Server Geoprocessing tool. The Error message is ERROR 000775: Replica with the same name already exists. I keep getting this error message even when I use a different name for the replica. I've also gone into SQL server and removed any orphaned replica versions. The replica I'm trying to create is a two-way replica using 10.1 sp1. I've been able to create other two-way replica's using this geoprocessing tool. What is ArcCatalog or SQL server holding onto that thinks this replica already exists. It's not showing up in the Manage replica window.

Robert.

Re: Create Replica from Server Fails with Error 000775

JonPeck — Fri, 02 Aug 2013 19:53:45 GMT

A couple ideas for you to try:

Esri told me this once:

If you think you have an orphaned replica version then the way to find
out which one it is is to synchronize all replicas and then delete them
in ArcCatalog, then compress.

Next check the SDE.Versions table in SQL Server. If there are any
versions called something like sync_send_xxx then these are orphans. To
delete these orphans change the status flag from 16777216 to 33554433.
This will make the version visible in ArcCatalog version manager. From there you can delete it and run a compress again.

Also here is a sql script to find replicas:

-- put in database name
use databasename ;
select i.objectid, i.name from sde.GDB_ITEMS i join dbo.GDB_ITEMTYPES it on it.uuid = i.type where it.name = 'Replica' order by 1 ;

-- compare results above with the following

select v.name, v.state_id from sde.sde_versions v order by v.name ;

--

Hope this leads you in the right direction.

topic Create Replica from Server Fails with Error 000775 in Data Management Questions

Create Replica from Server Fails with Error 000775

Re: Create Replica from Server Fails with Error 000775