Hi,
I’m getting an error when trying to compare one of our SQL 2012 databases. Wondering if anyone has seen this, or has any idea how I can get Toad to really ignore the permissions.
I’m using version 5.8.0.831. I dont see any weird roles defined, or assigned to any of the users. In my compare options I do have Ignore Permissions selected.
heres the error:
System.ApplicationException
Problem with load Permissions
Stack Trace:
at Quest.Schema.Common.ModelLoad.ModelLoader6.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)
System.ApplicationException
Not supported permission type detected
Stack Trace:
at Quest.Schema.MSSQL.Interfaces.Utils.Converters.GetDatabasePermission(String value)
at Quest.Shared.Memorizing.ObjectCache2.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.CommonObjectLoaderWithExtension5.LoadObject(DataReader
1 reader, TLoadContext context, ParentSearchContext1 searchContext) at Quest.Schema.Common.ModelLoad.Declarations.ObjectLoaders.CommonObjectLoaderBase
5.LoadObjects(ICanceling cancel, DataReader1 reader, TLoadContext context) at Quest.Schema.Common.ModelLoad.ModelLoader
6.Run(ICallBack callback)