Is This Content Helpful?
We're glad to know this article was helpful.
Reconciling versioned edits returns the following error message if the geodatabase is configured to use shared or session-based log file tables and the log file tables do not already exist in the connected user's schema:
"Unable to create logfile system tables. User perhaps lacks permission or resources to create tables."
This message is returned even if the connected user has privileges to create tables in the database.
The reconcile operation is performed within a single transaction to allow changes to rollback if the reconcile operation is cancelled or encounters issues. Creating log file tables would require part of the data in the reconciliation to be committed to the database, thereby eliminating the ability to recover from failure. Therefore, if the log file tables do not exist before the reconcile operation begins, it fails.
If using the default log file table setting for Oracle, PostgreSQL, DB2, or Informix, follow these steps to create log file tables before reconciling versioned data: