Toad World® Forums

Schema Compare: Toad for SAP Beta 3.0.0.604 : Problem with load IndexedColumns


#1

The target database Sybase ASE 15.5

The error appears to happen for tables that have function based indexes

Note: It looks like both Schema and Data compare has some issues with tables that contain such indexes.

Example of such index

CREATE INDEX MyColumnUpper ON MyTable (upper(MyColumn))

System.ApplicationException
Problem with load IndexedColumns
Stack Trace:
at Quest.Schema.Common.ModelLoad.ModelLoader6.Run(ICallBack callback) at Quest.Schema.Common.ModelLoad.ModelLoadManager7.Loader.LoadModel(ICallBack callback)
at Quest.Schema.Common.ModelLoad.ModelLoadManager7.CreateInstance(ICallBack callback, FriendlyName friendlyName, SchemaSnapshot[] snapshots, SingleModel3 model, OptionsStorage options)
at Quest.Schema.Sybase.ModelLoad.ModelLoadServiceSybase.Create(ICallBack callback, FriendlyName friendlyName, SchemaSnapshot[] snapshots, ISingleModel model, OptionsStorage options)
at Quest.Schema.Common.Modules.SourcesLoader.SourcesLoaderModule.LoadModelFromSnapshot[T](ICallBack callback, SourceLoader1 source) at Quest.Schema.Common.Modules.SourcesLoader.SourcesLoaderModule.SourceLoader1.Run(ICallBack callback)

System.NullReferenceException
Object reference not set to an instance of an object.
Stack Trace:
   at Quest.Schema.Sybase.ModelLoad.LoadModel.Declarations.Process.ObjectLoaders.ObjectLoaderIndexedColumns`1.GetColumnLink(ParentSearchContext parentContext, DataReader`1 reader, LoadContext context)
   at Quest.Schema.Sybase.ModelLoad.LoadModel.Declarations.Process.ObjectLoaders.ObjectLoaderIndexedColumns`1.CreateIndexColumn(ParentSearchContext parentContext, DataReader`1 reader, LoadContext context)
   at Quest.Schema.Sybase.ModelLoad.LoadModel.Declarations.Process.ObjectLoaders.ObjectLoaderIndexedColumns.LoadValue(ParentSearchContext parentContext, DataReader`1 reader, LoadContext context, ScriptInfo scriptInfo)
   at Quest.Schema.Common.ModelLoad.Declarations.ObjectLoaders.ObjectLoaderMultilinePropertyBase`7.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)

#2

Hi ZeenKork,

Thanks for the feedback!

We’re sorry but the hidden computed columns for function-based index keys currently can not be supported.


#3

Hi Dan,

No problem. In such case I would expect to see a more nicely presented error message

but not the exception thrown.

Thanks!