Hi @jfisch25​ 

This is something that sometimes catches me out since it's easy to miss. To read in attachments (and attachment attributes), you need to enable attachments on the Reader Feature Type. Click on the Reader in your workspace and set Include Attachments to Yes.

Let me know if this helps or if you're still stuck.

Hi @jfisch25​ and @danminneyatsaf​ 

I come back on this post because I have the same problem. I can't copy relation between entity and attachment because the globalid field is missing in the attachment table when FME reads it. When I export the geodatabase from ArcGIS Online, globalID is not missing in the data.

I try to enable attachments in my reader but I don't get the value of globalid.

When I try to write data in a geodatabase, translation failed with this error when entities has many attachment :

Could not register GlobalID column 'GLOBALID' in table 'TABLENAME__ATTACH'. The error number from ArcObjects is: '-2147155969'. The error message from ArcObjects is: { sORA-01452: CREATE UNIQUE INDEX impossible ; there are duplicates(TABLENAME__ATTACH)] TTABLENAME__ATTACH]}

I feel that is the entity's globalid which is written in the attachment globalid, so there are duplicate ID. Despite this error, data are written in geodatabase with globalid {00000000-0000-0000-0000-000000000000}

Thanks for your help.

Hi @gaetanpru​,

Sorry to hear you're experiencing something similar! In my situation, I discovered that it was not crucial to maintain the GlobalID of the attachment features, only the GlobalID of the point features themselves, and since the attached features have that stored in the REL_GlobalID field (or parent GlobalID), I ended up randomly generating a new GlobalID for the attachment features when writing to the attachment table. I used the GUIDGenerator custom transformer and then renamed the attribute from "GFID" to "GLOBALID" and it seems to be working fine.

I'm still not sure why the GlobalID's for the attachment features are not showing in FME. @danminneyatsaf​, I have the Include Attachments enabled on my reader, and it's still not reading the GlobalID's for the attached features. It's not a problem for me anymore, but it does seem like it may be something beyond the scope of user error. Maybe worth exploring a little more.

Hello @jfisch25​ 

Thanks, it works for me too now. I also thought that the attachment's GlobalID was not important but I couldn't calculate it and I didn't know this transformer.

I'm agree with you, it's not an error from user but just this transformer that does not read this information.

Hi @jfisch25​ thanks for bringing this to my attention. After some further testing of creating an ArcGIS Online feature, adding attachments, and querying it through the REST API, I can also see that separate global IDs exist that should be read in through the arcgisonline_attachment{}.globalid attribute. I've reported this as a bug for our developers to follow up on. For your reference, the issue number is FMEENGINE-74184. If a fix is released, we will notify you here. Sorry for the inconvenience.

- Dan M

Thanks Dan, I appreciate it!

Hello,

Thanks for the report.

I don't know if it's related but when I run the script with all tables, the globalid is not kept in relationship's table, I have an empty field. To make it work , I have to run the script with only main tables one time and run a second time with only the relationship's tables.

Hi @gaetanpru​ , which FME version are you using? I am still having this issue with FME 2021.2.

Hi,

I'm using FME 2020.2

Hi @brandonguo​, have you tried the workaround @jfisch25​ detailed above on using the GUIDGenerator?

The issue is still being resolved by our developers, so in the meantime the only way to workaround this is by adding those "fake" GlobalIDs using the GUIDGenerator.

Thank you. Yes, the GUIDGenerator works perfectly.

Hi @danminneyatsaf   brandonguo gaetanpru jfisch25

I am trying to ArcGIS Online (attachment photos) to GDB

In case “Weeds” from AGO which few points feature contain photos attachamentto transform it in GDB contain the photos attachament.

Have been mentioned to to follow this proceed - reader AGO and Writer GDB:

The reader is set up:

And the “Attributes”:

The AttributeExposer set up:

I am not sure about the “RasterReplacer_2”: 

If I select “Data”:

Became “Red”

Would you know which way should I follow to make it to happen?

Please, feel free to shared more details and screenshots

It was the only conversation about this issue.

Regards,

Henrique Reis

Use the Clear Value menu item in the RasterReplacer to get rid of that parameter.

If you exposed the data attriute correctly it should look like below.