Schema Compare between two SQL Server 2012 databases gave the following error:
Exception: System.ApplicationException
Message : Problem with load Permissions
Stack Trace:
at Quest.Schema.Common.ModelLoad.ModelLoader`6.Run(ICallBack callback)
at Quest.Schema.Common.ModelLoad.ModelLoadManager`7.Loader.LoadModel(ICallBack callback)
at Quest.Schema.Common.ModelLoad.ModelLoadManager`7.CreateInstance(ICallBack callback, SchemaSnapshot snapshot, ISingleModel model, OptionsStorage options)
at Quest.Schema.MSSQL.ModelLoad.ModelLoadServiceMSSQL.Create(ICallBack callback, SchemaSnapshot snapshot, ISingleModel model, OptionsStorage options)
at Quest.Schema.Common.Modules.SourcesLoader.SourcesLoaderModule.LoadModelFromSnapshot(ICallBack callback, SourceLoader source)
at Quest.Schema.Common.Modules.SourcesLoader.SourcesLoaderModule.SourceLoader.Run(ICallBack callback)
Inner Exception: System.ApplicationException
Message : Not supported permission type detected
Stack Trace:
at Quest.Schema.MSSQL.Interfaces.Utils.Converters.GetDatabasePermission(String value)
at Quest.Shared.Memorizing.ObjectCache`2.GetValue(TKey key)
at Quest.Schema.MSSQL.ModelLoad.LoadModel.Declarations.Process.IdLoaders.IdPermissionActionLoader.GetId(DataReader`1 reader, LoadContext context)
at Quest.Schema.Common.ModelLoad.Declarations.ObjectLoaders.CommonObjectLoaderWithExtension`5.LoadObject(DataReader`1 reader, TLoadContext context, ParentSearchContext`1 searchContext)
at Quest.Schema.Common.ModelLoad.Declarations.ObjectLoaders.CommonObjectLoaderBase`5.LoadObjects(ICanceling cancel, DataReader`1 reader, TLoadContext context)
at Quest.Schema.Common.ModelLoad.ModelLoader`6.Run(ICallBack callback)
WORKAROUND:
None
STATUS:
Issue fixed in version 6.0. The latest version of Toad for SQL Server can be downloaded at:
https://support.quest.com/
