Editor tracking and SQL update of Enterprise geodatabase

Question

Hello,

I was surprised to notice that updating an archived table view as described here:

Mise à jour de données non versionnées de géodatabase dans Oracle avec SQL—Aide | ArcGIS Desktop

does not update the editor tracking fields.

The archiving functionnality works but not the tracking editor.

Is it an expected behavior ? I searched in the documentation and found no mention of it. Maybe I missed it but I think it should be documented somewhere that the tracking editor is not working when updating geodatabase with SQL from the view.

Is there any work-around ?

Thanks

KevinDunlop · Accepted Answer

After reading your question, I was curious so I set up a test case in my GDB (SQL Server/ArcGIS 10.6).  I went into the backend of the view and looked at its triggers.  It appears that the ArcGIS Desktop software handles the editor tracking field values since the view triggers does not generate them itself.  Therefore, a workaround would be for your SQL statements to included the values for the tracking fields.