BUG

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

Last Published: April 25, 2020

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.

Article ID:000010180

Software:
  • Legacy Products

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Discover more on this topic

Esri Community

Search for related information

Training

Find training related to this topic

ArcGIS Ideas

Explore ideas and give feedback

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options