Hi all,
I have an FME process that I run nightly to refresh a polygon feature class in my SQL Server geodatabase. What I'm trying to do is truncate the feature class first and then insert new features into the feature class.
It has worked successfully in the past, but it's not working properly at the moment. The truncate call fails and features get inserted into the feature class. Since the truncate is failing, now I have duplicates in the table. Please see the logs below..
2021-01-04 10:59:26| 248.2| 0.0|INFORM|Geodatabase Writer: Truncating table/feature class `GISO.Cadastral_FME'
2021-01-04 11:21:04| 303.4| 55.1|WARN |Geodatabase Writer: An error occurred while trying to truncate table/feature class `GISO.Cadastral_FME'. The error number from ArcObjects is: '-2147154945'. The error message from ArcObjects is: {Table schema changed after cursor declared a42000:2Microsoft]sODBC Driver 17 for SQL Server]rSQL Server]Could not complete cursor operation because the table schema changed after the cursor was declared.] egeoDBweb.GISO.Cadastral_FME]}. The error will be ignored
2021-01-04 11:21:04| 303.4| 0.0|INFORM|Geodatabase Writer: The field 'OBJECTID' in table 'GISO.Cadastral_FME' will not be updated since it is not editable
2021-01-04 11:21:04| 303.4| 0.0|INFORM|Geodatabase Writer: The field 'SHAPE.STArea()' in table 'GISO.Cadastral_FME' will not be updated since it is not editable
2021-01-04 11:21:04| 303.4| 0.0|INFORM|Geodatabase Writer: The field 'SHAPE.STLength()' in table 'GISO.Cadastral_FME' will not be updated since it is not editable
My writer is GEODATABASE_SDE and I have set the transaction type to Non-Versioned Edit Session. Currently using FME Desktop 2019.1 . Any help would be much appreciated.
Thanks in advance!