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

SQL Optimizer for Sybase ASE Community

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

Follow / 2 Mar 2012 at 6:50am

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

Replies

  • Follow / 5 Mar 2012 at 6:04pm
    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.
  • Follow / 6 Mar 2012 at 1:32am

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

    Also, I will stop developing my own CompareAndSync :-)

    Julien.

  • Follow / 7 Mar 2012 at 12:46am
    The patch is now available. Let me know if you have any issues.

    Thanks.
  • Follow / 15 Mar 2012 at 12:15am

    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.

  • Follow / 15 Mar 2012 at 7:49am
    Hello Julien,

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

    Thanks,
    Michael Garza
  • Follow / 19 Mar 2012 at 11:30pm
    Hello Julien,

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

    Thanks.