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

ArcGIS Pro 2.6.2: How to reconnect the feature class with its attachment table that contains photos that are collected when enabling the “enable attac

JamalNUMAN

ArcGIS Pro 2.6.2: How to reconnect the feature class with its attachment table that contains photos that are collected when enabling the “enable attachments” property?

What if the relationship between the feature class and its attachment table is deleted? How to reconnect them so that the photos can be viewed?

If the “relationship class” is re-created between the feature class and its attachment table then the photos fails to view!

Find more posts tagged with

Desktop

Accepted answers

All comments

DanPatterson

are you sure the image isn't in the blob field? the *.jpg are just file names with no path

See your associated post

ArcGIS Pro 2.6.2: How to display the physical phot... - GeoNet, The Esri Community

JamalNUMAN

If you try to perform the “enable attachments” option from scratch, you will be finding out that the attachments are saved as per screenshots below

The issue in this thread is to find out how to rebuild the “relationship class” if it’s deleted!

DanPatterson

Did you use the tool or using shortcuts?

Enable Attachments (Data Management)—ArcGIS Pro | Documentation

Robert_LeClair

So the question is if by chance sometime deleted the Relationship Class (RC) that is used by the Enable Attachments GP tool/command, is it possible to build a new relationship class to re-enable the existing relationship? If so, I tried. I took a screen shot of the Relationship Class (RC) properties before I deleted it. Deleted the RC. Rebuilt the RC using the GP tool using the screen shot. Shut down AGP. Loaded the project again. Added the FC with the attachments "rebuilt" of sorts. Identified a point and it did not show the Attachment. So I'm guessing the answer is not possible. Which leads to a question, why would one delete the RC to begin with? An error?

JamalNUMAN

Thanks Robert.

Right. What if the relationship is deleted by mistake? Is this the end and we are losing everything?

Robert_LeClair

You're welcome Jamal. So if the relationship class itself is deleted, then the relationship appears to be broken. I would presume that the data in the relationship (i.e. source data - *.jpgs, *.docx, etc.) is fine. It's just not related to the feature class anymore. For example, if I created a RC to a non-spatial table, the non-spatial table still exists as would a folder of *.jpgs. You would have to rebuild the RC again to re-establish the relationship.

JamalNUMAN

Thanks Robert.

If the attachment relationship is deleted and rebuilt then the photos are not displayed as per the screenshot below

JamalNUMAN

Do you encourage me to report an idea for enhancement for this?

Robert_LeClair

Your call. If you feel this behavior is needed for workflow, then you can add it certainly. As you know, I'm not on the ArcGIS Pro Dev Team rather Training Services so have little pull in what gets incorporated into the ArcGIS Pro application. Like I said for eGDB's, one can do an incremental recovery to restore deleted RC's. Not as easy with fGDB's.

ToddW_stl

This is an untested theory, but you could try:

Step 1 of re-establish the relationship class for geodatabase attachments (*article is for ArcMap, see notes for ArcGIS Pro below)
replace step 2 (Create Attachments) with ArcGIS Pro's Enable Attachments , then Upgrade Attachments (since this is an older thread, see notes about ArcGIS Pro 2.6 and ArcGIS Enterprise 10.8.1 in Upgrade Attachments)
continue with the Step 3 of re-establish the relationship class for geodatabase attachments

yockee

Hi @JamalNUMAN . I encounter the same problem.. I was loading the attachment to feature Class stored in SDE postgresql and failed midway. Then I create another table with the exact same schema and turn the LOGGING of the table off. I load the attachment again into the new table. It is a success.

But now there is a problem: how to get the relationship class to read this new table. Several legal attempts (I tried all Geoprocessing Tools relating with Attachment) do not work.

I realize that I have 2 tables : one table is half empty table and another is table with successfull import. Then I open PGAdmin and start copying manually (INSERT INTO half_empty SELECT * FROM successfull_table).

Now the attachment works again..

Hope that helps. I know it's been a long time but might be useful to someone

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.