Unable to create logfile system tables

Problem:

Various workflows may display an error message that contains the text "Unable to create logfile system tables".

Cause:

ArcGIS requires so-called "logfile system tables" for certain operations. If these do not exist in the schema of the affected user, an attempt is made to create them. However, this schema change fails if an edit session is currently started.

Workaround:

Perform a selection of more than 100 objects outside an editing session. This will create the tables. Afterwards, the problem should no longer exist.

Solution:

The tables should be created at the same time as the user is created in the database. Esri has described how this can be done in the following article.

How To: Create log file tables in an enterprise geodatabase as global temporary tables in Oracle

With UT for ArcGIS the script UT.SDE_logfile_global.orc.sql is provided in the setup subdirectory.

Translated with www.DeepL.com/Translator (free version)