T4Sybase 1.1.0.695 - Schema Compare fails to run. patch available?

Toad for SAP Solutions
1

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
vs
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 -----
System.ApplicationException
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)

System.ArgumentException
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)
2

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.

Thanks.

3

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

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

Julien.

4

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

Thanks.

5

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,
Julien.

6

Hello Julien,

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

Thanks,
Michael Garza

7

Hello Julien,

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

Thanks.