I am using the ESRI file geodatabase writer to write data to both a feature class and table class and establish a foreign key relationship between the data in the two classes. The only relationship documentation I've found is under the ESRI geodatabase (Access database) writer and that is what I have been trying.
I have three FME feature types for my writer; one for the feature class, one for the table class, and one for the relationship. I am setting a geodb_oid on the data for the feature class and table class. I am setting the set the geodb_type to geodb_relationship, and I've also tried geodb_attributed_relationship, on the relationship FME feature type. The geodb_feature_has_relationship is set to Yes for all three FME feature types and the geodb_rel_origin_oid and geodb_rel_destination_oid are being set for just the relationship feature type.
When I run the workspace, I'm receiving the error:
Attempting to write a non-relationship feature to relationship class 'Main_Liner'. Ensure the 'geodb_type' is set to a valid relationship class type
Am I doing something wrong or is the ESRI file geodatabase writer not able to write the relationship information?
Thanks,
Steve
