Toad World® Forums

T4Sybase - Schema Compare fails to run. patch available?

Hey T4Syb team,
I’m doing a schema compare between 2 sybases.

select @@version on each:

Adaptive Server Enterprise/15.5/EBF 17794 SMP ESD#1/P/Solaris AMD64/OS 5.10/asear155/2495/64-bit/FBO/Thu May 27 07:04:51 2010
Adaptive Server Enterprise/15.5/EBF 18163 SMP ESD#2/P/Solaris AMD64/OS 5.10/asear155/2514/64-bit/FBO/Wed Aug 25 11:26:26 2010

It throws and exception after processing for a while.
I reproduced this three times. Just choose the defaults.

---- Exception here -----
Problem with load IndexesScript
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.ModelLoadManager`7.CreateInstance(ICallBack callback, SchemaSnapshot snapshot, OptionsStorage options)
at Quest.Schema.Sybase.ModelLoad.ModelLoadServiceSybase.Create(ICallBack callback, SchemaSnapshot snapshot, 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)

An item with the same key has already been added.
Stack Trace:
   at System.ThrowHelper.ThrowArgumentException(ExceptionResource resource)
   at System.Collections.Generic.Dictionary`2.Insert(TKey key, TValue value, Boolean add)
   at Quest.Schema.Common.Tree.Base.Collections.CollectionWithIndex`3.Add(Item`3 item)
   at Quest.Schema.Common.Tree.Base.Collections.GroupsCollection`3.AddInternal(SupportedGroup group, ActionContext actionContext)
   at Quest.Schema.Common.Tree.Base.Collections.GroupsCollection`3.WorkWithGroups(List`1 groups, ActionContext actionContext)
   at Quest.Schema.Common.Tree.Base.Collections.GroupsCollection`3.Add(Item`3 item)
   at Quest.Schema.Common.Tree.Base.Item`3.AddToParent(Item`3 parent)
   at Quest.Schema.Common.Tree.Base.Item`3..ctor(TIndex index, TType type, Item`3 parent, CollectionComparer`1 comparer, TContent content)
   at Quest.Schema.Common.Model.SingleModel`3.CreateObject(Item`3 parent, String name, Int32 id, Int32 typeIndex, StringComparer comparer)
   at Quest.Schema.Common.Model.SingleModel`3.Add(Item`3 parent, Int32 typeIndex, String name, Int32 id, StringComparer comparer)
   at Quest.Schema.Common.Model.SingleModel`3.Add(Item`3 parent, Int32 typeIndex, String name, Int32 id)
   at Quest.Schema.Common.ModelLoad.Declarations.ObjectLoaders.CommonObjectLoaderWithExtension`5.LoadObject(DataReader`1 reader, TLoadContext context, ParentSearchContext`1 searchContext)
   at Quest.Schema.Sybase.Load.LoadModel.Declarations.Process.ObjectLoaders.ObjectLoaderIndexes.LoadObject(DataReader`1 reader, LoadContext context, ParentSearchContext`1 searchContext)
   at Quest.Schema.Common.ModelLoad.Declarations.ObjectLoaders.CommonObjectLoaderBase`5.LoadObjects(DataReader`1 reader, TLoadContext context)
   at Quest.Schema.Common.ModelLoad.ModelLoader`6.Run(ICallBack callback)

Hello Julien,

I apologize for the inconvenience, we have a patch coming out in the next couple of days that fixes some of the Schema Compare issues.


Excellent, I’ll download this in a few days time.

Also, I will stop developing my own CompareAndSync :slight_smile:


The patch is now available. Let me know if you have any issues.


Please generate a new Trial version with this patch.
I put aside code that I was writing because this feature is something we need.
If I can not evaluate it, I can not buy it - I’ve verbal approval so far.

Many thanks,

Hello Julien,

Please send an email to and I will get the information to you.

Michael Garza

Hello Julien,

I created CR 98,157 for this issue and we will look into fixing it as soon as possible.