I'm trying to translate from text features (which translate with their "Text Location As Point") into feature-linked annotation in a GEODATABASE_SDE format. I have the feature class and the feature annotation class and the relationship between them set up in the geodatabase. When I only had the feature class created in the geodatabase I was able to run a translation and populate the feature class. But since creating the feature-linked annotation class in the geodatabase, I am unable to complete a translation.
Note that I made sure the feature class (map_element) and the feature linked annotation (map_element_anno) class had zero records before running the translation.
Also, note that there are many other feature classes and tables in the geodatabase. So if I were to use the workspace template method for the writer, the schema would contain much more than the features I'm trying to work with.
Here's the error message I get when I run the translation:
An error occurred while attempting to store a row into the table 'sde.map_element'. The error number from ArcObjects is: '-2147211171'. The error message from ArcObjects is: {Cannot open origin or destination class of this relationship class. [dev.sde.map_element_anno]}
I have verified that the classes referred to aren't locked.
The instructions in https://knowledge.safe.com/articles/21083/working-with-feature-linked-annotation.html are for a file geodatabase. I'm wondering if there's something different I have to do for an SDE geodatabase.
A secondary question I have is how can I get the orientation and size of the text being read to be used by the annotation in the annotation feature class? The translation workspace has a handle on both through the "fme_rotation" and "fme_text_size" attributes. Perhaps this is more a question for ESRI, but figured I'd throw it out here.
