topic Re: Editor tracking and SQL update of Enterprise geodatabase in Geodatabase Questions

Editor tracking and SQL update of Enterprise geodatabase

NicolasGIS — Thu, 17 May 2018 13:02:12 GMT

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

Re: Editor tracking and SQL update of Enterprise geodatabase

KevinDunlop — Thu, 17 May 2018 14:28:29 GMT

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.

Re: Editor tracking and SQL update of Enterprise geodatabase

NicolasGIS — Wed, 23 May 2018 10:00:05 GMT

Hi Kevin,

Thanks for your reply. Indeed, that could work. I had thought that it was handle at the database level.

Wish I had noticed that before.

Thanks