Hello,
does anyone know why the Truncate Existing Function in Esri SDE Writer does not reset the OBJECTID Counter of a registered Table. (Table is not Versioned).
SDE Writer File is based on World Parameter (not SID) and I am using ArcGIS 3.1.4 and FME 2022.2 (but had the Issue also in constellation ArcGIS 2.6 and FME Desktop 2021)
The data is written on Oracle 19.15
Br
Goran
Hello @gorango, this is interesting. Cannot confirm yet, but this sounds like a known issue introduced in FME 2022.1, where the SDE Writer was not resetting the objectID field in truncate mode (FMEENGINE-77130). Are you able to submit a support case so we can take a closer look with you? When creating the case, please include any supporting files (eg. data, workspace), version numbers, complete logfile, and maybe even a video/screenshots of the behavior.
Otherwise, for the time being, you can try reverting back to FME 2020.1, where I think the truncating is reported to work as expected (downloads page). Let me know if you have any related questions, Kailin.
Hi @kailinatsafe I created a Ticket C696227.