Howdy, I'm running FME 2019.0 and I am having problems writing a file geodatabase relationship table, specifically working with geodatabase attachments.
In my situation I am using an ArcGIS Online Feature Service Reader to read in data collected with the ArcGIS Collector App. For my purposes I have filtered out unwanted attachments and now I need to write the data as a file geodatabase with the desired attachments.
The error message I am consistently getting is:
|ERROR |Failed to retrieve origin row for a relationship feature with OBJECTID '558' from table/feature class 'RC_Fire_Hazardous_Trees_Removal_CIP2260'This error implies that in the origin table (the point geometry) the 'geodb_oid' is written to the 'OBJECTID' field. However, testing out the "Writing ArcGIS Geodatabase Attachments" template file (https://knowledge.safe.com/articles/45301/writing-arcgis-geodatabase-attachments.html) it does not appear to be necessary to be feasible nor necessary to write the 'geodb_oid' to 'OBJECTID' .
Testing in that that template file, I observed that if I modify the 'geodb_oid' values (created by the 'Count Start' parameter's for the Counter transformer in "step 4" & modify them to start at a random # like 542 instead of 1) then the relationships work just fine, however the ObjectID in the points table does not match the geodb_oid that was fed to the writer. Therein by all appearances something magical happens to build the relationships off of the invisible geodb_oid while referencing the ObjectID.
My parameters for the relationship table writer feature type are:
- Feature Class Name: RC_Fire_Hazardous_Trees_Removal_CIP2260__ATTACHREL
- Geometry: geodb_relationship
- Feature Operation: Insert
- Table Handling: Truncate Existing
A copy of my workbench can be retrieved here (https://cityofsantarosa-my.sharepoint.com/:u:/g/personal/e06214_srcity_org/EbneJbFI7rxPqzYt-Y0-dBwBtfDGqdQjAgYSOQ2goTobVA?e=BkwEWX) the file is 69 MB so it exceeds the forum limits.
My workflow is structured similar to the example provided here: https://knowledge.safe.com/articles/45301/writing-arcgis-geodatabase-attachments.html
Any assistance is appreciated