__ATTACH tables break replication in ArcGIS 10?

1761
10
Jump to solution
08-06-2012 06:30 AM
MichaelWolfe
Emerging Contributor
I originally posted this question on gis.stackexchange.com.

I'm trying to get one-way replication working in ESRI ArcGIS 10. Here's a quick summary of the steps I followed:


  1. Open map in ArcMap with the relevant data layers I want to replicate

  2. Choose Create Replica from distribution toolbar

  3. Choose One-Way Replica, Parent-to-Child

  4. Use Simple Model (as opposed to Full Model)

This works for me with one problem. Several of the featuresets that the data layers are based off of have __ATTACH tables. When I perform the replication, the __ATTACH tables get replicated but the base tables do not.

For example, there is a layer based on a featureset called Parcels that may have attachments stored in a SQL Server table called Parcels_ATTACH. In the replicated copy of the geodatabase, there is a Parcels_ATTACH table but no Parcels table.

If it makes any difference, the Parent Geodatabase is stored in SQL Server 2008 R2 and the replicated child is stored in SQL Server Express 2008 R2.
0 Kudos
1 Solution

Accepted Solutions
JakeSkinner
Esri Esteemed Contributor
You can replicate between SQL Server and SQL Server Express.  I believe the problem is with the data.  As a test, try the following:

1.  Create a new feature class in SQL Server
2.  Register the feature class as versioned
3.  Add Global IDs
4.  Enable Attachments
5.  Add the feature class to ArcMap and create the replica to the SQL Server Express database using the Create Replica wizard
[INDENT]a.  Be sure to select Advanced and select Full Model
b.  Specify 'All records' for the attachments table
[/INDENT]
6.  Complete the wizard

Is the attachments table replicated successfully?

View solution in original post

0 Kudos
10 Replies
JakeSkinner
Esri Esteemed Contributor
I'm not sure why the feature class is being dropped, but is there a reason you are choosing 'Simple Model' rather than 'Full Model'?  For example, do you need the child replica not to be versioned in the SQL Server Express instance?

If you choose 'Full Model' both the feature class, attachments table, and the associated relationship class will be replicated.  Here is more information on feature information models for replicas.
0 Kudos
MichaelWolfe
Emerging Contributor
If I try to run the Full Model I receive the following error message:

---------------------------
Source Data Error
---------------------------
The application is not licensed to create or modify schema for this type of data
A network source with the specified name does not exist.
A network source with the specified name does not exist.
A network source with the specified name does not exist.
A network source with the specified name does not exist.
A network source with the specified name does not exist.
A network source with the specified name does not exist.
A network source with the specified name does not exist.
A network source with the specified name does not exist.
Version not found [DBO.AssessMap06_92]
---------------------------
OK  
---------------------------


I believe this is the relevant line from the above error message: "The application is not licensed to create or modify schema for this type of data "

The parent geodatabase is on a full SQL Server installation and it uses SDE schemas.  I assumed that a Full replica maintains the SDE schema, which is apparently incompatible with SQL Server Express.  I figured this meant the Simple replica was my only option because SQL Server Express is a hard req't on the destination/child geodatabase machine.
0 Kudos
MichaelWolfe
Emerging Contributor
This is still an issue for me.  I tried replicating to a personal geodatabase instead of SQL Server Express.  I get the same problem with the __ATTACH tables.  Is there any way to explicitly specify what layers should be included in the replica?
0 Kudos
JakeSkinner
Esri Esteemed Contributor
Try replicating to a personal geodatabase using Full Model.  You should not be receiving that error when you choose 'Full Model'.
0 Kudos
MichaelWolfe
Emerging Contributor
If I choose Full Model with the personal geodatabase I still receive an error similar to the one I received before:

The application is not licensed to create or modify schema for this type of data


I believe this is because our source geodatabase uses SDE schemas (on a full version of SQL Server).  The source geodatabase should have all necessary licenses to do just about anything.  However, the target geodatabase will need to run on laptops that only have ArcMap viewing licenses and no full-copy of SQL Server (only express).
0 Kudos
JakeSkinner
Esri Esteemed Contributor
You can replicate between SQL Server and SQL Server Express.  I believe the problem is with the data.  As a test, try the following:

1.  Create a new feature class in SQL Server
2.  Register the feature class as versioned
3.  Add Global IDs
4.  Enable Attachments
5.  Add the feature class to ArcMap and create the replica to the SQL Server Express database using the Create Replica wizard
[INDENT]a.  Be sure to select Advanced and select Full Model
b.  Specify 'All records' for the attachments table
[/INDENT]
6.  Complete the wizard

Is the attachments table replicated successfully?
0 Kudos
MichaelWolfe
Emerging Contributor
I think you're right.  I tried creating a Full Model replica with a subset of the data I need and it seemed to go through OK.  Now I just have to systematically add in the features I need and see what is specifically causing the "application not licensed" error.

Thanks for your help.
0 Kudos
NanaDei
Esri Contributor
Since you've been able to create the replica, this suggests that all feature classes/tables in the parent geodatabase has GlobalIDs and they are registered as versioned. Layers that are not versioned and/or do not have Globalids are not included in the replica.

I also wanted to check if the data being replicated is a Cadastral (Parcel) Fabric and which version of ArcGIS Desktop version (10.0 or 10.1) is being used to create the replica.

Thanks
0 Kudos
MichaelWolfe
Emerging Contributor
ESRI ArcMap 10.0 (Build 3600)
ArcGIS Desktop 10 Service Pack 3 (Build 3600)
License Type: ArcInfo

I hope that helps.  I'm not really a GIS guy.  I'm a software developer that occasionally has to help maintain an existing system set up by someone who has since been let go and not replaced.  I know just enough to be dangerous ;).
0 Kudos