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
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