Select to view content in your preferred language

Non-spatial table replication

1193
6
12-28-2011 02:05 PM
JacksonTrappett
Frequent Contributor
SDE 10.0 SP2:

We have one-way replication set up between two SDE 10.0 SP2 geodatabases, and it is working fine, no errors.  All of the spatial tables replicate correctly.  We have one non-spatial table, that also replicates, but on the child database, it is always blank, even though the parent has rows.  Has anyone else seen this, or know how to fix it?

The non-spatial table is versioned and has global IDs on the parent side.
0 Kudos
6 Replies
JakeSkinner
Esri Esteemed Contributor
By default, when replicating tables the 'Check Out' for the table is set to Schema Only rather than 'All Records'.  You will need to go into the advanced options when creating the replica (screen1.png).  Then you can set the 'Check Out' to 'All Records' (screen2.png).
JakeSkinner
Esri Esteemed Contributor
By default, when replicating tables the 'Check Out' for the table is set to Schema Only rather than 'All Records'.  You will need to go into the advanced options when creating the replica (screen1.png).  Then you can set the 'Check Out' to 'All Records' (screen2.png).
0 Kudos
JacksonTrappett
Frequent Contributor
Good to know, thanks!
0 Kudos
JamalNUMAN
Legendary Contributor
By default, when replicating tables the 'Check Out' for the table is set to Schema Only rather than 'All Records'.  You will need to go into the advanced options when creating the replica (screen1.png).  Then you can set the 'Check Out' to 'All Records' (screen2.png).


Hi Jake,

I�??m experiencing the same problem. May you please have a look on the thread below:

http://forums.arcgis.com/threads/86754-Tables-participating-in-a-replica-generated-empty?p=306636&po...

Best

Jamal
----------------------------------------
Jamal Numan
Geomolg Geoportal for Spatial Information
Ramallah, West Bank, Palestine
0 Kudos
AsrujitSengupta
Deactivated User
Jamal,

This is by design.

Please have a look at the below link for more details:
[ NIM040283 - Using GP tool (create replica) to create replica and set ALL_ROWS for expand feature classes and tables, the attribute table only has its schema replicated.]

http://support.esri.com/en/bugs/nimbus/TklNMDQwMjgz

You can also have a look at the below post for a good workaround:
http://forums.arcgis.com/threads/481...604#post166604 (look at the last post)

Hope this helps!

Regards,
JamalNUMAN
Legendary Contributor
Jamal,

This is by design.

Please have a look at the below link for more details:
[ NIM040283 - Using GP tool (create replica) to create replica and set ALL_ROWS for expand feature classes and tables, the attribute table only has its schema replicated.]

http://support.esri.com/en/bugs/nimbus/TklNMDQwMjgz

You can also have a look at the below post for a good workaround:
http://forums.arcgis.com/threads/481...604#post166604 (look at the last post)

Hope this helps!

Regards,


Thank you Asrujit for the help,

My non-spatial table is intended to be versioned and wanted to have same behaviour as for the spatial data when replica is created.

Is there a solution in 10.2 such that non-spatial data is replicated when �??create replica�?� is used?
----------------------------------------
Jamal Numan
Geomolg Geoportal for Spatial Information
Ramallah, West Bank, Palestine
0 Kudos