AnsweredAssumed Answered

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

Question asked by amy14 on Apr 29, 2016
Latest reply on Sep 29, 2016 by roemhildtg

Like • Show 0 Likes0
Comment • 3

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

No one else has this question

Outcomes

amy14 May 10, 2016 9:28 AM

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

1 person found this helpful

Actions

Supriya_Khadke-esristaff

May 12, 2016 8:36 AM

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

1 person found this helpful

Actions

roemhildtg @ Supriya_Khadke-esristaff on Sep 29, 2016 8:27 AM

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?

Actions

3 Replies

amy14 May 10, 2016 9:28 AM
Mark Correct
Correct Answer
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
1 person found this helpful
Like • Show 0 Likes0
Actions
Supriya_Khadke-esristaff May 12, 2016 8:36 AM
Mark Correct
Correct Answer
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):
1. Open the Replica Manger
2. Right click the replica>Properties
3. 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
1 person found this helpful
Like • Show 0 Likes0
Actions
- roemhildtg @ Supriya_Khadke-esristaff on Sep 29, 2016 8:27 AM
  Mark Correct
  Correct Answer
  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?
  Like • Show 0 Likes0
  Actions

GeoNet

The Esri Community

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

Outcomes

Related Content

Recommended Content