laptop and a wrench

Bug

SQL Server Only: Setting PERMISSION_CACHE_THRESHOLD in DBTUNE can cause client connection attempt to fail when many objects exist in an ArcSDE instance. Error: "Microsoft OLE DB Provider for SQL Server: Timeout expired"

Last Published: August 25, 2014 No Product Found
Bug ID Number NIM039793
SubmittedOctober 31, 2008
Last ModifiedJune 5, 2024
Applies toNo Product Found
Version found10.0
Version FixedN/A
StatusFixed

Workaround

For SQL Server 2005 and above: Set the DBTUNE parameter PERMISSION_CACHE_THRESHOLD to -1. There is no work-around for SQL Server 2000.

Steps to Reproduce

Bug ID: NIM039793

Software:

  • No Product Found

Get notified when the status of a bug changes

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