Schema Compare times out after a few minutes with the following error:
System.InvalidOperationException
Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.
Stack Trace:
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at Quest.Shared.MSSQL.SQLConnOptions.GetOpenSqlConnection(ISQLConnOptions conn, Boolean defaultConnection)
at Quest.Shared.MSSQL.ScriptEngine.GetConnection()
at Quest.Shared.MSSQL.ScriptEngine.ExecuteDataAdapter(String script)
at Quest.Shared.MSSQL.Helper.SQLServerHelper.Info.GetServerVersion(IScriptEngine engine)
at Quest.Shared.MSSQL.Helper.SQLServerHelper.Info.GetServerVersion(ISQLConnOptions conn)
at Quest.Shared.MSSQL.SQLConnOptions.<.ctor>b__0()
at Quest.Shared.Memorizing.ThreadSafeObjectHolder`1.Initialize()
at Quest.Shared.Memorizing.ThreadSafeObjectHolder`1.get_Value()
at Quest.Shared.MSSQL.SQLConnOptions.get_ServerVersion()
at Quest.Shared.MSSQL.ScriptEngine.get_ServerVersion()
at Quest.Schema.MSSQL.Snapshot.Helper.CheckSupport(IScriptEngine engine, String databaseName, Version& serverVersion, Byte& compatibilityLevel)
at Quest.Schema.MSSQL.Snapshot.Loaders.SnapshotLoader.GetHeader(ScriptProcessor`1 processor, SnapshotHeaderUserProperties userHeader)
at Quest.Schema.MSSQL.Snapshot.Loaders.SnapshotLoader.Load(ICallBack callback)
at Quest.Schema.MSSQL.Snapshot.Loaders.SnapshotLoader.Run(ICallBack callback)
at Quest.Schema.MSSQL.Snapshot.SnapshotManager.CreateInstance(ICallBack callBack, ISQLConnOptions conn, SnapshotHeaderUser
Cause
Issue due to using pooling in Schema Compare connection.
Resolution
WORKAROUND:
Run the Schema Compare without making an initial connection.
1. Start Toad but do not make an initial connection
2. Click on the 'Compare and sync' icons to run your compare (see screen shot SOL77888_Fig1.jpg)
STATUS: Waiting for fix in a future release of Toad for SQL Server.
Defect ID
ST88080
Attachments
Leave a Comment
Your Request will be reviewed by our technical reviewer team and, if approved, will be added as a Topic in our Knowledgebase.