topic Re: AddAttachments GP Tool Not Working for SDE Feature Classes in Geoprocessing Questions

AddAttachments GP Tool Not Working for SDE Feature Classes

JamesGustine — Thu, 19 Jul 2012 14:32:56 GMT

I am having trouble getting the AddAttachments GP Tool to work with SDE feature classes. The tool works nicely with the same feature class in a file geodatabase.

Its not failing per se just returning messages like:

Cannot add file 'x'

Notes:
1) I am using the same Input dataset and Match table with the OBJECT ID as the key
2) the Path field is a UNC Path. I tried converting the UNC to a mapped drive....no dice.
3) These files exist on disk.
4) I have tried running the tool within an edit session via arcpy and the da module. Doesn't work either.
5) Its not a privilege issue, I can load the attachments manually in ArcMap (1 @ a time).
6) The attachment table is registered as versioned.
7) Local 10.1 Desktop client with a direct connect to a 10.0 geodatabase (SS 2008 R2).

Any help on this would be greatly appreciated.

<James>

Re: AddAttachments GP Tool Not Working for SDE Feature Classes

RussellBrennan — Fri, 20 Jul 2012 14:58:16 GMT

Hi James,

If you reference the full path to the data (feature class with attachments enabled) when you run the tool rather than the layer name from the TOC do the attachments get added successfully?

Re: AddAttachments GP Tool Not Working for SDE Feature Classes

JamesGustine — Fri, 20 Jul 2012 16:55:23 GMT

Thanks for looking into this.

No. the attachments fail to load in all scenarios, via ArcCatalog (with full paths) and ArcMap (with Layer name in the TOC and full path). Same result in VS2010 using python.

Re: AddAttachments GP Tool Not Working for SDE Feature Classes

RussellBrennan — Mon, 06 Aug 2012 20:45:06 GMT

I tried to repro this on a number of machines here and was unable to. I would suggest contacting Tech Support so that they can help determine where this is failing.

Re: AddAttachments GP Tool Not Working for SDE Feature Classes

MichaelDesroches — Mon, 22 Oct 2012 13:36:38 GMT

Hi James,

Did you ever get down to the cause of this? I'm discovery with tech support at the moment and would welcome any additional insight.

Re: AddAttachments GP Tool Not Working for SDE Feature Classes

TaraGallant — Fri, 21 Dec 2012 16:30:35 GMT

I am having similar issue; add attachments work fine in a local file gdb, but as soon as I try this within SDE I get results that show Cannot add file _____.

I am not sure if it is a privileges issue within SDE for that particular db, something to do with replication? I am using 10.1 SP1

Any help would be appreciated.

Re: AddAttachments GP Tool Not Working for SDE Feature Classes

JamesGustine — Fri, 21 Dec 2012 16:59:51 GMT

I worked with tech support to "resolve this". Not sure of the root cause, but the work around is to create a copy of the feature class in SDE and run the tool on that.

Let me know if that works for you. Mabey someone else has a better idea. At this point my plan is to export the copy the gdb to a dev environment upate the attachments and move it back to production.

Re: AddAttachments GP Tool Not Working for SDE Feature Classes

MichaelDesroches — Fri, 21 Dec 2012 17:07:28 GMT

This is a known bug, and I have been told by esri tech support that the geoprocessing team is taking a look at it to be included in the sp2.

Re: AddAttachments GP Tool Not Working for SDE Feature Classes

TimothyMichael — Wed, 09 Jan 2013 20:22:04 GMT

This is the only thread that I have come across that addresses this issue, but I am experiencing the same behavior in ArcGIS 10.1. Just like the original poster, I have tried:

1. GP tool and python via python window in Desktop.
2. Tried running GP tool in an edit session.
3. File(s) exist on disk on the machine that I am running this tool from.
4. Tried mapped drive and local paths.
5. I can add an attachment manually, so that is working and I have the necessary rights to do so.
6. Tried running GP tool from Catalog and Desktop
7. Etc.

The error is the same as well: "Cannot add file 'X' to feature with OID = 'X'"

The feature class participates in a replica, so making a copy is not an option.

The environment is ArcGIS for Desktop Standard 10.1, SP1. Database in SDE; geodatabase version matches the ArcGIS release.

Thanks!
Tim

Re: AddAttachments GP Tool Not Working for SDE Feature Classes

TimothyMichael — Tue, 22 Jan 2013 21:35:27 GMT

I opened a case with Esri support and found that this behavior is a known bug - NIM073706 - that pertains to running the Add Attachments tool against data that is registered as versioned. The work around that I used was to compress my database, unregister the feature dataset and attachment table as versioned, and then run the tool. After the tool ran successfully I registered my data as versioned again.

--Tim

Re: AddAttachments GP Tool Not Working for SDE Feature Classes

KyleMorgan — Tue, 23 Jul 2013 19:50:37 GMT

I opened a case with Esri support and found that this behavior is a known bug - NIM073706 - that pertains to running the Add Attachments tool against data that is registered as versioned. The work around that I used was to compress my database, unregister the feature dataset and attachment table as versioned, and then run the tool. After the tool ran successfully I registered my data as versioned again.

--Tim

Just to add to Tim's suggestion (which worked great)... You have to actually right click the attachment table and uregister as versioned as only unregistering the feature class as versioned doesn't cascade down to this table.

Thanks for the suggestion Tim!