Edits will not synchronize

831
12
10-05-2013 10:38 PM
TeresaSmithson2
New Contributor III
Replication: One way parent-child with archiving
Parent Database: ArcGIS 10.1 SDE geodatabase on SQL Express on a dedicated server
Child Database: File geodatabase on network server

Feature class structure (simplified):
   Feature class of buildings - contains attribute for building number and polygons
   Feature class for building data - featureless (no geometry) attribute table containing all of the information regarding the building.
   Feature classes for other information - featureless attribute tables for plumbing, electrical, etc.
The "featureless" feature classes are not "tables", they are feature classes.  I found the search ability to be more robust this way, but I also had synchronizing problems when this data was just tables.

Relationships: all of the various tables are linked via the building number or other common attributes between tables (e.g. building data has a code for plumbing that links to the plumbing table.  Many of the links become circular, which works well for complete coverage of the data.

Problem:
If I edit any of the cells in the buildings feature class, the changes will synchronize.  If I edit any of the cells in the featureless feature classes (data only attribute tables), none of the changes will synchronize.  Is there something in the way that the tables or database is setup that would cause this problem.  It's a good thing I have short hair - harder to pull out:-)

Any suggestion is wlcome, I have tried even things that seemed silly; all to no avail, but I am something of a newbie to this stuff.
Teresa
0 Kudos
12 Replies
847396730
Occasional Contributor III
Is it a "full model" or "simple model" replica?
0 Kudos
TeresaSmithson2
New Contributor III
Is it a "full model" or "simple model" replica?


It's a Full model, using advanced to include everything.
0 Kudos
847396730
Occasional Contributor III
What's a "featureless feature class?"  You explicitly state it is not a gdb table--what is it, or how did you create it?
0 Kudos
TeresaSmithson2
New Contributor III
It is a feature class but has no geometry associated with it.  The attribute table is loaded with data from the excel spreadsheet.
0 Kudos
TeresaSmithson2
New Contributor III
To be more specific, I created a new feature class in the SDE database, in the same dataset as the buildings.  I then loaded the table with data from Excel and created a relationship between the new feature class and the building feature class that has geometry,
Hope that helps.
0 Kudos
JoeBorgione
MVP Esteemed Contributor
To be more specific, I created a new feature class in the SDE database, in the same dataset as the buildings.  I then loaded the table with data from Excel and created a relationship between the new feature class and the building feature class that has geometry,
Hope that helps.


Using a feature dataset in SDE could be the root of your problems.  I've been been able to replicate through a feature dataset, but I prefer not to.

Also, and please don't take offense, but I fail to see the reasoning in a feature-less feature class.  You should simply use a table to store your related data.  That may be part of the problem too.
can't wait to retire....
0 Kudos
TeresaSmithson2
New Contributor III
The tables were a major problem.  I spent hours and hours with ESRI because the tables would not replicate to the remote servers.  I also did not like the tables for the lack of search functionality.  I hear that tables are just like feature classes, yet you can not access them with the Find tool.  I am working in a transitory environment with trade people accessing table without the benefit of a designed user interface - everything is temporary, yet we have to keep track of over 100,000 assets including air conditioning units that move daily and are associated with the buildings.  So not being able to use Find to search tables, and then identify and link to the building was a major issue.

So back to datasets.  Everything i read placed an emphasis on datasets.  Are you saying that you find a problem with them for replication?  I could easily re-structure without them.
0 Kudos
JoeBorgione
MVP Esteemed Contributor
The tables were a major problem.  I spent hours and hours with ESRI because the tables would not replicate to the remote servers.  I also did not like the tables for the lack of search functionality.  I hear that tables are just like feature classes, yet you can not access them with the Find tool.  I am working in a transitory environment with trade people accessing table without the benefit of a designed user interface - everything is temporary, yet we have to keep track of over 100,000 assets including air conditioning units that move daily and are associated with the buildings.  So not being able to use Find to search tables, and then identify and link to the building was a major issue.

So back to datasets.  Everything i read placed an emphasis on datasets.  Are you saying that you find a problem with them for replication?  I could easily re-structure without them.


I replicate SDE tables to standalone File GDBs almost every day, so it's hard saying what the issue is.  But I use SQl Server 2008 r2...

As far as feature datasets go, I'm saying they can create problems in SDE databases.
can't wait to retire....
0 Kudos
TeresaSmithson2
New Contributor III
Hi Joe,
I appreciate your responses.  I am certain that this should be doable and that the problem is with my setup, I am just stuck as to what the problem is.  As stated, when I was just using tables the replication would fail.  I sent the files to ESRI and we worked over a period of several weeks trying to figure out why - to no avail.  That is when I switched to using the data in feature classes instead and found that I, and more importantly the users, really like the increased search function using Find so I have stuck with this design, but still cannot get the edits in the tables to replicate.

I don't know if it is a product of our strange server configuration (as stated the parent is on a stand alone not accessible to anyone else except the 2 person GIS team and IT that has no GIS experience) or with the remote servers on a different network from the parent, or if it an indication of a problem with my database structure.

I am new to this game and this really is my first big rodeo.  Unfortunately, I am also extremely isolated in Afghanistan and do not have access to many resources or other GIS peers - therefore I am posting on this forum.  I will take a copy of the database home with me the end of this month and see if my graduate professor can find the problem.  If it works in another environment, then I know the problem is our server setup.  Maybe I'll just let it go and continue to just extract new databases to the user servers on a weekly basis and leave at that, but it drives me crazy when something doesn't work right!

Again, thanks for your feedback.
0 Kudos