Skip to main content

I have an ArcSDE Geodatabase created and stored in a PostgreSQL 11.1 Server. There is a Feature Class within the Geodatabase that has attachments. I have a ArcSDE GeoDB Feature Reader Transformer added to a Workspace, configured to read the Feature Class and its attachments and it does not read the attachments.

@dane_stephenson​ You should see both the feature class and the __ATTACH feature class in your FeatureReader. 2020-11-09_12-38-09If that's what you have, then perhaps test the 'native' reader to see if that can read both the feature class and the __ATTACH. If that doesn't work then you might have to contact your local FME provider.


@dane_stephenson​ You should see both the feature class and the __ATTACH feature class in your FeatureReader. 2020-11-09_12-38-09If that's what you have, then perhaps test the 'native' reader to see if that can read both the feature class and the __ATTACH. If that doesn't work then you might have to contact your local FME provider.

Strangely enough, yes, that is what I have. If I add the __ATTACHREL and set the transformer to "Ignore Relationship Info" - NO (by unchecking this option), it reads the Feature Class, its Attachments, and the Attachment Relationship table just fine. But, this option takes an exorbitant amount of time and I do not need the __ATTACHREL table.

 

The same set up (ArcSDE GeoDB Feature Reader Transformer set to read a Feature Class and its Attachments from an ArcSDE Geodatabase created and stored on a PostgreSQL 9.4.5 Server) reads everything just fine. The only difference I can see between the two Feature Classes is the underlying PostgreSQL Server version and the one that reads the attachments, the relationship is based on ObjectID, and the one that fails to read the attachments, the relationship is based on GlobalID.

 

I did add an ArcSDE GeoDB Reader with just the Feature Class and the Attachments and that fails to read the Attachments as well.


Reply