nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Tables participating in a replica generated empty,

JamalNUMAN

Tables participating in a replica generated empty,

I wanted to create a replica from an ArcSDE geodatabase (parent) to a file geodatabase (child) but sounds that the tables replicated on the child geodatabase are found to be empty. Other features classes are replicated successfully.

[ATTACH=CONFIG]25292[/ATTACH], [ATTACH=CONFIG]25293[/ATTACH]

What might be the issue here?

Why tables participating in replica are found to be empty on the child geodatabase?

Thank you

Best

Jamal

Clip_304.jpg

Clip_303.jpg

STORYMAP Solar Rooftop Potential for Industrial Decarbonization.pdf

FM_res_problem.jpg

EirikHagtvedt_0-1622064149820.png

FranklinAlexander_2-1761671675699.png

Find more posts tagged with

Accepted answers

AsrujitSengupta

Jamal,

As mentioned in the link: http://support.esri.com/en/bugs/nimbus/TklNMDQwMjgz

"This is a expected behaviour", so I don't think there will a fix out for this.

The Direct method that you are looking for is as follows:

Use distributed geodatabase toolbar in ArcMap to create the replica

The above method will replicate the records too.

Regards,

All comments

Anonymous User

Original User: Jamal432@gmail.com

Jamal,

As mentioned in the link: http://support.esri.com/en/bugs/nimbus/TklNMDQwMjgz

"This is a expected behaviour", so I don't think there will a fix out for this.

The Direct method that you are looking for is as follows:

Use distributed geodatabase toolbar in ArcMap to create the replica

The above method will replicate the records too.

Regards,

Many thanks Asrujit for the prompt help,

As you have already recommended, I used the �??distributed geodatabase�?� toolbar to create the replica and it worked fine

[ATTACH=CONFIG]25315[/ATTACH], [ATTACH=CONFIG]25316[/ATTACH], [ATTACH=CONFIG]25317[/ATTACH]

Hope that they will fix the behaviour of the geoprocessing tool in 10.2.

All the best

Jamal

Original User: Jamal432@gmail.com

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/48195-Create-Replica-on-SDE-Table?p=166604#post166604 (look at the last post)

Hope this helps!

Regards,

Thank you very much Marco and Asrujit for the help,

Sounds that there is no direct way to have the non-spatial data replicated the same way as for the spatial data.

Does this behavior continue in 10.2?

This is the second challenging issue I got regarding the ArcSDE geodatabase. The first one was how feature classes can be added to an existing replica. In this case, no direct solution is available neither.

Best

Jamal

Anonymous User

Original User: asrujit

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/48195-Create-Replica-on-SDE-Table?p=166604#post166604 (look at the last post)

Hope this helps!

Regards,

MarcoBoeringa

Jamal,

I haven't yet had time to test the replication of a table myself, but this Help page says:

"For tables the default filter is Schema Only; only the schema for the table will be replicated. To apply a filter to a table you must first create a table view setting desired filters. You can then use this as input into the Create Replica tool. See the Make Table View for more information. For more information on filters and replication see Preparing data for replication."

It seems you may need to make a Table View first, and use that as input for the Create Replica tool.

I don't know the reason for this, except maybe that most (or some) stand-alone non-spatial tables part of geodatabases, may actually be very big and actively maintained tables from business systems, for which it is better to only replicate a selection of the data really necessary in the child replica, to avoid excessive data traffic between parent and child.

Anonymous User

Original User: Jamal432@gmail.com

Jamal,

I think Jake Skinner (ESRI) described the issue and solution in this thread:

http://forums.arcgis.com/threads/46668-Non-spatial-table-replication

The screenshots in that thread are no longer there, but the setting Jake is referring to is the one under:

Expand Feature Classes and Tables (optional)

in the Create Replica dialog. You need to choose "ALL_ROWS" instead of "USE_DEFAULTS" to add all records in case of tables.

Thank you Marco for the help,

Unfortunately, I tried it but sounds not to work. The resulted table in the replica is still empty.

[ATTACH=CONFIG]25295[/ATTACH], [ATTACH=CONFIG]25296[/ATTACH]

Just in case it works, do we need two replicas (one for feature classes and one for tables) to replicate all the data from the ArcSDE geodatabase to the file geodatabase?

Best

Jamal

Clip_306.jpg

Clip_305.jpg

PSC Monthly Inspection Form.xlsx

Subducts_addin_v3.py.zip

MarcoBoeringa

Why tables participating in replica are found to be empty on the child geodatabase?

Jamal,

I think Jake Skinner (ESRI) described the issue and solution in this thread:

http://forums.arcgis.com/threads/46668-Non-spatial-table-replication

The screenshots in that thread are no longer there, but the setting Jake is referring to is the one under:

Expand Feature Classes and Tables (optional)

in the Create Replica dialog. You need to choose "ALL_ROWS" instead of "USE_DEFAULTS" to add all records in case of tables.

SushilPradhan_0-1634572222537.png

SushilPradhan_1-1634572348900.png

IMG_5917.PNG

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.