topic Re: HELP: Connected Replica sync fails "No support for this geometry type." in Geodatabase Questions

HELP: Connected Replica sync fails "No support for this geometry type."

AmyRose — Fri, 29 Apr 2016 16:13:08 GMT

We use SQL Server 2012 and have ArcGIS.

I created a connected one way (Parent to child) replica from database A to database B.

It has been working fine, but the last sync gave me a "no support for this geometry type error".

I looked at the feature classes and didn't find any strange geometry issues. I compressed, rebuilt indexes and analyzed the database as well. It still would not work.

I kept the non-working replica and created a new replica (register exisitng data) and the new replica worked; however,

new changes in database A did not sync over (because I am registering exiting data).

What are my options in this scenario?

I would prefer not having to delete the existing data out of database B and then start over. Database B has data syncing from several other databases.

Any help appreciated,

Amy Rose

Re: HELP: Connected Replica sync fails "No support for this geometry type."

AmyRose — Tue, 10 May 2016 16:28:30 GMT

Well, I have figured this out. User error but with a helpful hint on correcting the issue.

I accidently added a feature class to the replica that did not exist in the child. The replica sync'd fine until there was actual changes in that feature class.

Instead of re-building the replica (which would have been painful), a GIS colleague recommended deleting the feature class out of the GDB_ITEMS table in SQL, making sure the path is correct.

I did back-up everything before trying this solution. I hope to ask ESRI at a meeting later this month to see if this is an "OK" practice or not, but it worked for us (so far).

I will try to remember to comment on what ESRI says.

Hope this helps someone,

Amy Rose

Re: HELP: Connected Replica sync fails "No support for this geometry type."

Anonymous User — Thu, 12 May 2016 15:35:20 GMT

Hi Amy,

Its not recommended to edit the database tables to remove information about a feature class Information on a feature class in the geodatabase is stored in many different tables in the geodatabase, not just the GDB_Items table.

The better method is to unregister that one feature class from the replica using the ArcMap/Catalog tools. Then you could create a new replica for that one feature class OR after successfully synchronizing the other data in the replica: unregister the replica, copy the new feature class to the child geodatabase, and then re-register the replica with existing data.

To unregister one feature class from the replica, you would use the Replica Manager (see the link below for more information):

Open the Replica Manger
Right click the replica>Properties
Under the description tab, locate the feature class, right click and click "UnRegister from Replica"

A quick tour of replica management—ArcGIS Help | ArcGIS for Desktop

Hope this helps!

Supriya

Re: HELP: Connected Replica sync fails "No support for this geometry type."

roemhildtg — Thu, 29 Sep 2016 15:27:10 GMT

I'm getting this error trying to create a replica. I am creating a replica from a sql server express geodatabase to a file geodatabase stored on the network drive.

The replica contains several datasets, tables, and feature classes.

Any advice?