When trying to run a Schema Compare for a (SQL Server 2016) schema with a large amount of database objects (1000+ tables, procedures etc), the following error occurs:
System.ApplicationException
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, FriendlyName friendlyName, SchemaSnapshot[] snapshots, SingleModel`3 model, OptionsStorage options)
at Quest.Schema.MSSQL.ModelLoad.ModelLoadServiceMSSQL.Create(ICallBack callback, FriendlyName friendlyName, SchemaSnapshot[] snapshots, ISingleModel model, OptionsStorage options)
at Quest.Schema.Common.Modules.SourcesLoader.SourcesLoaderModule.LoadModelFromSnapshot[T](ICallBack callback, SourceLoader`1 source)
at Quest.Schema.Common.Modules.SourcesLoader.SourcesLoaderModule.SourceLoader`1.Run(ICallBack callback)
System.ApplicationException
Not supported permission type 'VWCK' 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.Interfaces.Utils.Converters.GetDatabasePermissionNameFromServerValue(String value)
at Quest.Schema.MSSQL.ModelLoad.LoadModel.Declarations.Process.NameLoaders.NameDatabasePermissionActionLoader.GetName(String value)
at Quest.Shared.Memorizing.ObjectCache`2.GetValue(TKey key)
at Quest.Schema.MSSQL.ModelLoad.LoadModel.Declarations.Process.NameLoaders.NameDatabasePermissionActionLoader.GetName(DataReader`1 reader, LoadContext context, ScriptInfo info, ParentSearchContext parentContext)
at Quest.Schema.Common.ModelLoad.Declarations.ObjectLoaders.CommonObjectLoaderWithExtension`5.LoadObject(DataReader`1 reader, TLoadContext context, ParentSearchContext searchContext)
at Quest.Schema.Common.ModelLoad.Declarations.ObjectLoaders.CommonObjectLoaderBase`5.LoadObjects(ICanceling cancel, DataReader`1 reader, TLoadContext context)
at Quest.Schema.Common.ModelLoad.Declarations.ScriptLoaders.ScriptLoader`5.LoadObjects(ICanceling cancel, DataReader`1 reader, TLoadContext context)
at Quest.Schema.Common.ModelLoad.ModelLoader`6.Run(ICallBack callback)