English

Bug: Pools of session-based log file tables in SQL Server are not being used if the geodatabase is in the DBO schema

Description

If the default log file configuration of a DBO-schema geodatabase in SQL Server is modified to use pools of session-based log files, the pool of log file tables are not used, and new session-based log files are created in the individual user's schema.

Cause

This is a known issue in 9.3.

Workaround

This issue was fixed in ArcSDE 9.3.1. Either upgrade the geodatabase or use the default session-based log file configuration. The settings for this are as follows:

  • In SDE_dbtune, SESSION_TEMP_TABLE under the LOGFILE_DEFAULTS keyword is set to 0.
  • The SDE_server_config parameter ALLOWSESSIONLOGFILE is set to TRUE.
  • The SDE_server_config parameter LOGFILEPOOLSIZE is set to 0.