Hi all,
I am developing a spatial ETL process to bring across entire dataset from Intergraph system into ArcGIS 10.1 SDE geodatabase periodically. In ArcGIS schema, there are feature classes with relationships e.g. "Service Point" (source) to "Customer Address" (destination) composite 1-M relationship. The ArcGIS datasets are NOT versioned.
The ETL process I created truncates the data from ArcGIS feature classes in SDE and then reloads them from the source system. For this, I have set "Truncate Table First" flag to "Yes" in the tool. And because the relationship is a composite relationship, I am hoping this will delete the destination records as well. However, this does not seem to be the case. I get this error below. However, if I drop the relationships, the process works fine. The "Transaction Type" in my destination writer is set to "TRANSACTIONS". Am I missing some setting to tell ETL process to delete the destination objects? Or is this works as designed? I am using ArcGIS for Desktop 10.1 with interop extension and ArcSDE 10.1.
Geodatabase Writer: Truncating table/feature class `ARCGIS.SERVICE_POINT'
Geodatabase Writer: An error occured while trying to truncate table/feature class `ARCGIS.SERVICE_POINT'. The error number from ArcObjects is: '-2147216556'. The error message from ArcObjects is: {Objects in this class cannot be updated outside an edit session [ARCGIS.SERVICE_POINT]}. The error will be ignored
An error occurred while attempting to open an insert cursor on the table 'ARCGIS.SERVICE_POINT'. The error number from ArcObjects is: '-2147216556'. The error message from ArcObjects is: {Objects in this class cannot be updated outside an edit session [ARCGIS.SERVICE_POINT]}
GeodatabaseRelationshipFeaturesPipeline::GeodatabaseRelationshipFeatures(SortFactory): Sorted 0 feature(s)
Transaction #1 rolled back. Rerun translation specifying transaction #0 for the keyword 'TRANSACTION'
Thanks,
Vish
