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

Importing Schema Changes (merged threads)

AlvaroMoreno

Hi guys,
I am having the following problem with the tool Importing Schema Changes (or Compare Schema Changes i dont know ).
When I add a field to a feature class the tool works well and the Schema update works perfectly
But when I add a domain or a subtype Importing Schema Changes tool tells me
"No schema changes found for this replica pair"
Thanks
Gonzalo

Finde mehr Beiträge mit dem Tag

Accepted answers

All comments

baohuachu3

Here my steps for import schema changes:

GDB A schema changes, we want B will change either.

In GDB A, to export schema xml file.
In GDB B, load one layer of the schema, compare schema , whose input is in the step 1 generated xml file and to generate schema differences xml file.
In GDB B, import schma changes , whose input is the step 2 's generated xml file.

I am in ArcSDE 10.2, and have an attribute domain subtype change in parent geodatabase, and wanted to pass that change to the child geodatabase. I first used the compare schema change tool created a xml file, and then tried to import that file to the child gdb, but got the similar message "No schema changes found for this replica pair."

I found the bug report NIM070970 and this post here. I just reported this to the ESRI support. However I need a solution now, and wondering if anybody have figured out a work around for this?

I am using Oracle 11.2.0.2.0, OS is RHEL6.1, SDE is 10.2. It is a one-way replication with simple features only.

Thanks a lot.
Rong

BenLin

Hi Gonzalo,

I would second to Robert's comment, please contact with Esri Support Services (Geodata) to test the scenario. We might need to reproduce the issue in-house to find out the actual causes of this issue.

Thanks,
Ben

AlvaroMoreno

Hi Ben,
Mistakenly posted in this forum rather than in that of geoprocessing.
I went back to post on the forum geoprocessing.
Here's the link http://forums.arcgis.com/threads/40589-Importing-Schema-Changes

thanks
Gonzalo

BenLin

Hi Gonzalo,

The tools are used in a two-step process that involves first running the Compare Replica Schema tool to generate an XML file containing the schema changes, then importing these changes with the Import Replica Schema tool.

According to this web help, the domain changes should be able to be carried over between the replicated geodatabases.

http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/Working_with_schema_changes/00270000003w000000/

Please provide a more detailed workflow if you are still encountering the same issue.

Ben L.

Robert LeClair

Gonzalo - with regard to NIM070970, it's been assigned to a Development staff member but nothing listed as far as resolution date. Since you're experiencing this same issue with two replication, I would recommend contacting Esri Support Services (Geodata) to test the scenario and possibly create a new NIM for this behavior.

-Robert

AlvaroMoreno

Hi Robert,
Yes my RDBMS is ORacle 11gR2 but the replica is two way.
It would seem that the bug also occurs with two-way replicas
have an estimate of when there will be a fix?

Thanks
Gonzalo

Robert LeClair

Gonzalo -

By chance are you using one-way replication on an Oracle RDBMS? If so, NIM070970 - "Changes in subtypes and domains are not synchronized between parent and child in a one-way replica through the compare replica schema" may be the culprit.

You can read a little bit about it at the following URL: http://support.esri.com/en/bugs/nimbus/TklNMDcwOTcw

Good luck!

Robert LeClair
Esri-Denver

AlvaroMoreno

Nimm an der Unterhaltung teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

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