Problems with SQL Compare

Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
edited April 20, 2004 6:05AM in SQL Compare Previous Versions
Hi Ruvan,

I think this is the same problem as one we've run into last week. I will
email a patch to you that should fix the problem.

Regards,

Brian Donahue
Red Gate Technical Support


"Ruvan Fernando" <rufe@[REMOVE-THIS]NETPEOPLE.DK> wrote in message
news:dW2pqofIEHA.3080@server53...
> Hi Redgate
>
> As I mentioned in a previous post I am developing a deploy tool.
> Using some databases works fine, but now I have started to use the ToolKit
> on production databases and suddenly the comparison operation can't
> complete.
>
> I tried to do it using the SQL Compare GUI tool (version 3.1.5.191) and
the
> error also occurs. BUT! What's really strange is that the SQL Compare tool
> works on the problematic databases from another machine - but not my
Deploy
> application, that still gets the same error as shown below.
>
>
>
> at System.Diagnostics.EventLog.WriteEvent(Int32 eventID, Int16 category,
> EventLogEntryType type, String[] strings, Byte[] rawData)
> at System.Diagnostics.EventLog.WriteEntry(String message,
> EventLogEntryType type, Int32 eventID, Int16 category, Byte[] rawData)
> at System.Diagnostics.EventLog.WriteEntry(String source, String
message,
> EventLogEntryType type, Int32 eventID, Int16 category, Byte[] rawData)
> at System.Diagnostics.EventLog.WriteEntry(String source, String
message,
> EventLogEntryType type, Int32 eventID, Int16 category)
> at System.Diagnostics.EventLog.WriteEntry(String source, String
message,
> EventLogEntryType type, Int32 eventID)
> at System.Diagnostics.EventLog.WriteEntry(String source, String
message,
> EventLogEntryType type)
> at RedGate.SQLCompare.Engine.Database.GetDependencies(String sql,
Boolean
> quotedIdentifiers, Boolean throwExceptions)
> at RedGate.SQLCompare.Engine.Database.Register(ConnectionProperties
> connectionProperties, Options options)
> at Deployer.DatabaseCompare.CompareDatabases() in
> c:videployerdbcompare.cs:line 52
> at Deployer.DeployProject.CompareDataBases() in
> c:videployerdeployproject.cs:line 135
> at Deployer.Form1.StartCompare_Click(Object sender, EventArgs e) in
> c:videployerform1.cs:line 603
>
> The error both the GUI displays and the ToolKit returns is: "The parameter
> is incorrect" right after examining "comments" objects.
>
> I have attached a screenshot also.
>
>
>
> Both machines that run SQL Compare and my Deploy tool runs on Windows
Server
> 2003 (the one that works is however a Standard, mine is a Enterprise).
> Databases are SQL Server 2000 running on Windows 2000 machines.
>
>
> Any ideas?
>
> Best regards,
>
> Ruvan Fernando
> System Developer
> NetPeople A/S
> Denmark
>
>
>
· Share on Twitter

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hi Scott,

    The patch is on the way!

    Brian Donahue
    Red Gate Technical Support

    "Scott Tucholka" <scott.tucholka@aqssys.com> wrote in message
    news:$f0leBnIEHA.1616@server53...
    > Brian, I think we are having the same problem. After installing 3.1.5.191
    > SQL Compare, we are receiving the "The parameter is incorrect" message
    box.
    > I had to get some compares done, so I uninstalled Red-Gate and installed
    the
    > previous version to finish my tasks. This morning I re-installed the
    > 3.1.5.191 update, and now the process just hangs without receiving any
    > error. ?? I was trying to reproduce the error before I submitted the
    > problem. It seems that it (3.1.5.191) works on a small percent of our
    > databases, but not all like before. It does seem like the unicode/ansi
    > problem has been resolved in 3.1.5.191.
    >
    > Scott Tucholka
    > AQS
    >
    >
    > "Brian Donahue (Red Gate)" <brian.donahue@red-gate.com> wrote in message
    > news:#TXgMkiIEHA.1848@server53...
    > > Hi Ruvan,
    > >
    > > I think this is the same problem as one we've run into last week. I
    > will
    > > email a patch to you that should fix the problem.
    > >
    > > Regards,
    > >
    > > Brian Donahue
    > > Red Gate Technical Support
    > >
    > >
    > > "Ruvan Fernando" <rufe@[REMOVE-THIS]NETPEOPLE.DK> wrote in message
    > > news:dW2pqofIEHA.3080@server53...
    > > > Hi Redgate
    > > >
    > > > As I mentioned in a previous post I am developing a deploy tool.
    > > > Using some databases works fine, but now I have started to use the
    > ToolKit
    > > > on production databases and suddenly the comparison operation can't
    > > > complete.
    > > >
    > > > I tried to do it using the SQL Compare GUI tool (version 3.1.5.191)
    and
    > > the
    > > > error also occurs. BUT! What's really strange is that the SQL Compare
    > tool
    > > > works on the problematic databases from another machine - but not my
    > > Deploy
    > > > application, that still gets the same error as shown below.
    > > >
    > > >
    > > >
    > > > at System.Diagnostics.EventLog.WriteEvent(Int32 eventID, Int16
    category,
    > > > EventLogEntryType type, String[] strings, Byte[] rawData)
    > > > at System.Diagnostics.EventLog.WriteEntry(String message,
    > > > EventLogEntryType type, Int32 eventID, Int16 category, Byte[] rawData)
    > > > at System.Diagnostics.EventLog.WriteEntry(String source, String
    > > message,
    > > > EventLogEntryType type, Int32 eventID, Int16 category, Byte[] rawData)
    > > > at System.Diagnostics.EventLog.WriteEntry(String source, String
    > > message,
    > > > EventLogEntryType type, Int32 eventID, Int16 category)
    > > > at System.Diagnostics.EventLog.WriteEntry(String source, String
    > > message,
    > > > EventLogEntryType type, Int32 eventID)
    > > > at System.Diagnostics.EventLog.WriteEntry(String source, String
    > > message,
    > > > EventLogEntryType type)
    > > > at RedGate.SQLCompare.Engine.Database.GetDependencies(String sql,
    > > Boolean
    > > > quotedIdentifiers, Boolean throwExceptions)
    > > > at RedGate.SQLCompare.Engine.Database.Register(ConnectionProperties
    > > > connectionProperties, Options options)
    > > > at Deployer.DatabaseCompare.CompareDatabases() in
    > > > c:videployerdbcompare.cs:line 52
    > > > at Deployer.DeployProject.CompareDataBases() in
    > > > c:videployerdeployproject.cs:line 135
    > > > at Deployer.Form1.StartCompare_Click(Object sender, EventArgs e) in
    > > > c:videployerform1.cs:line 603
    > > >
    > > > The error both the GUI displays and the ToolKit returns is: "The
    > parameter
    > > > is incorrect" right after examining "comments" objects.
    > > >
    > > > I have attached a screenshot also.
    > > >
    > > >
    > > >
    > > > Both machines that run SQL Compare and my Deploy tool runs on Windows
    > > Server
    > > > 2003 (the one that works is however a Standard, mine is a Enterprise).
    > > > Databases are SQL Server 2000 running on Windows 2000 machines.
    > > >
    > > >
    > > > Any ideas?
    > > >
    > > > Best regards,
    > > >
    > > > Ruvan Fernando
    > > > System Developer
    > > > NetPeople A/S
    > > > Denmark
    > > >
    > > >
    > > >
    > >
    > >
    >
    >
    · Share on Twitter
  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    edited September 16, 2004 9:00AM
    Hi Scott,

    It must be a problem in the dependency parsing code. I've had an email
    just today from someone with the same problem, where the application event
    logs fill up with 'couldn't parse' errors from SQL Compare.

    I am waiting for some information from the other customer, and when we
    find out what's wrong, I'll let you know.

    Regards,

    Brian Donahue
    Red Gate Technical Support

    "Scott Tucholka" <scott.tucholka@aqssys.com> wrote in message
    news:14wY2avIEHA.1612@server53...
    > After I installed the patch (3.1.6.200), I retried a compare. I received a
    > message like "Log File is Full" (Cannot recreate to get the exact syntax).
    > Then I tried again, and it just locked up. I then rebooted my workstation
    > and retried and it locked up again on the 'Reading Comments' step (screen
    > shot). Please let me know if you need any additional information.
    >
    > Scott.
    >
    > "Brian Donahue (Red Gate)" <brian.donahue@red-gate.com> wrote in message
    > news:Sdjk$2uIEHA.1236@server53...
    > > Hi Scott,
    > >
    > > The patch is on the way!
    > >
    > > Brian Donahue
    > > Red Gate Technical Support
    > >
    > > "Scott Tucholka" <scott.tucholka@aqssys.com> wrote in message
    > > news:$f0leBnIEHA.1616@server53...
    > > > Brian, I think we are having the same problem. After installing
    > 3.1.5.191
    > > > SQL Compare, we are receiving the "The parameter is incorrect"
    message
    > > box.
    > > > I had to get some compares done, so I uninstalled Red-Gate and
    installed
    > > the
    > > > previous version to finish my tasks. This morning I re-installed the
    > > > 3.1.5.191 update, and now the process just hangs without receiving any
    > > > error. ?? I was trying to reproduce the error before I submitted the
    > > > problem. It seems that it (3.1.5.191) works on a small percent of our
    > > > databases, but not all like before. It does seem like the unicode/ansi
    > > > problem has been resolved in 3.1.5.191.
    > > >
    > > > Scott Tucholka
    > > > AQS
    > > >
    > > >
    > > > "Brian Donahue (Red Gate)" <brian.donahue@red-gate.com> wrote in
    message
    > > > news:#TXgMkiIEHA.1848@server53...
    > > > > Hi Ruvan,
    > > > >
    > > > > I think this is the same problem as one we've run into last
    week.
    > I
    > > > will
    > > > > email a patch to you that should fix the problem.
    > > > >
    > > > > Regards,
    > > > >
    > > > > Brian Donahue
    > > > > Red Gate Technical Support
    > > > >
    > > > >
    > > > > "Ruvan Fernando" <rufe@[REMOVE-THIS]NETPEOPLE.DK> wrote in message
    > > > > news:dW2pqofIEHA.3080@server53...
    > > > > > Hi Redgate
    > > > > >
    > > > > > As I mentioned in a previous post I am developing a deploy tool.
    > > > > > Using some databases works fine, but now I have started to use the
    > > > ToolKit
    > > > > > on production databases and suddenly the comparison operation
    can't
    > > > > > complete.
    > > > > >
    > > > > > I tried to do it using the SQL Compare GUI tool (version
    3.1.5.191)
    > > and
    > > > > the
    > > > > > error also occurs. BUT! What's really strange is that the SQL
    > Compare
    > > > tool
    > > > > > works on the problematic databases from another machine - but not
    my
    > > > > Deploy
    > > > > > application, that still gets the same error as shown below.
    > > > > >
    > > > > >
    > > > > >
    > > > > > at System.Diagnostics.EventLog.WriteEvent(Int32 eventID, Int16
    > > category,
    > > > > > EventLogEntryType type, String[] strings, Byte[] rawData)
    > > > > > at System.Diagnostics.EventLog.WriteEntry(String message,
    > > > > > EventLogEntryType type, Int32 eventID, Int16 category, Byte[]
    > rawData)
    > > > > > at System.Diagnostics.EventLog.WriteEntry(String source, String
    > > > > message,
    > > > > > EventLogEntryType type, Int32 eventID, Int16 category, Byte[]
    > rawData)
    > > > > > at System.Diagnostics.EventLog.WriteEntry(String source, String
    > > > > message,
    > > > > > EventLogEntryType type, Int32 eventID, Int16 category)
    > > > > > at System.Diagnostics.EventLog.WriteEntry(String source, String
    > > > > message,
    > > > > > EventLogEntryType type, Int32 eventID)
    > > > > > at System.Diagnostics.EventLog.WriteEntry(String source, String
    > > > > message,
    > > > > > EventLogEntryType type)
    > > > > > at RedGate.SQLCompare.Engine.Database.GetDependencies(String
    sql,
    > > > > Boolean
    > > > > > quotedIdentifiers, Boolean throwExceptions)
    > > > > > at
    > RedGate.SQLCompare.Engine.Database.Register(ConnectionProperties
    > > > > > connectionProperties, Options options)
    > > > > > at Deployer.DatabaseCompare.CompareDatabases() in
    > > > > > c:videployerdbcompare.cs:line 52
    > > > > > at Deployer.DeployProject.CompareDataBases() in
    > > > > > c:videployerdeployproject.cs:line 135
    > > > > > at Deployer.Form1.StartCompare_Click(Object sender, EventArgs
    e)
    > in
    > > > > > c:videployerform1.cs:line 603
    > > > > >
    > > > > > The error both the GUI displays and the ToolKit returns is: "The
    > > > parameter
    > > > > > is incorrect" right after examining "comments" objects.
    > > > > >
    > > > > > I have attached a screenshot also.
    > > > > >
    > > > > >
    > > > > >
    > > > > > Both machines that run SQL Compare and my Deploy tool runs on
    > Windows
    > > > > Server
    > > > > > 2003 (the one that works is however a Standard, mine is a
    > Enterprise).
    > > > > > Databases are SQL Server 2000 running on Windows 2000 machines.
    > > > > >
    > > > > >
    > > > > > Any ideas?
    > > > > >
    > > > > > Best regards,
    > > > > >
    > > > > > Ruvan Fernando
    > > > > > System Developer
    > > > > > NetPeople A/S
    > > > > > Denmark
    > > > > >
    > > > > >
    > > > > >
    > > > >
    > > > >
    > > >
    > > >
    > >
    > >
    >
    >
    >
    · Share on Twitter
  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    edited September 16, 2004 9:01AM
    Hi Scott,

    It doesn't seem to be the numbering on its' own that causes a problem,
    because I can create any number of SPs using numbering and SQl Compare works
    okay with them...

    Is it possible for you to email your stored procedures to
    support@red-gate.com?

    Thanks!

    Regards,

    Brian Donahue
    Red Gate Technical Support

    "Scott Tucholka" <scott.tucholka@aqssys.com> wrote in message
    news:tFIcxR%23IEHA.1240@server53...
    > Hi Brian,
    >
    > I cleaned out the application event log and retried the compare and I
    think
    > I found the problem. We have a couple of large stored procedures that use
    > the ; number feature. Example: CREATE PROC [ EDURE ] [ owner. ]
    > procedure_name [ ; number ] <<. We get an error for each one that we
    have.
    > Before I ran the compare again, I increased my application event log to
    > handle 1024 instead of 512 and I think that allowed the compare to finish.
    > There is also a problem when scripting the number feature that it should
    > drop the procedure before it creates all the joined procedures.
    > Couldn't parse the following [first 16k follows]. Please contact
    > support@red-gate.com.
    >
    >
    /*==========================================================================
    > =======================
    >
    > ** NAME: dbo.AQSsp_OOS_Create_Reapply;1
    >
    >
    >
    > Hopes this helps in debugging,
    > Scott.
    >
    >
    > "Brian Donahue (Red Gate)" <brian.donahue@red-gate.com> wrote in message
    > news:7DhCHR8IEHA.1240@server53...
    > > Hi Scott,
    > >
    > > It must be a problem in the dependency parsing code. I've had an
    email
    > > just today from someone with the same problem, where the application
    event
    > > logs fill up with 'couldn't parse' errors from SQL Compare.
    > >
    > > I am waiting for some information from the other customer, and when
    we
    > > find out what's wrong, I'll let you know.
    > >
    > > Regards,
    > >
    > > Brian Donahue
    > > Red Gate Technical Support
    > >
    > > "Scott Tucholka" <scott.tucholka@aqssys.com> wrote in message
    > > news:14wY2avIEHA.1612@server53...
    > > > After I installed the patch (3.1.6.200), I retried a compare. I
    received
    > a
    > > > message like "Log File is Full" (Cannot recreate to get the exact
    > syntax).
    > > > Then I tried again, and it just locked up. I then rebooted my
    > workstation
    > > > and retried and it locked up again on the 'Reading Comments' step
    > (screen
    > > > shot). Please let me know if you need any additional information.
    > > >
    > > > Scott.
    > > >
    > > > "Brian Donahue (Red Gate)" <brian.donahue@red-gate.com> wrote in
    message
    > > > news:Sdjk$2uIEHA.1236@server53...
    > > > > Hi Scott,
    > > > >
    > > > > The patch is on the way!
    > > > >
    > > > > Brian Donahue
    > > > > Red Gate Technical Support
    > > > >
    > > > > "Scott Tucholka" <scott.tucholka@aqssys.com> wrote in message
    > > > > news:$f0leBnIEHA.1616@server53...
    > > > > > Brian, I think we are having the same problem. After installing
    > > > 3.1.5.191
    > > > > > SQL Compare, we are receiving the "The parameter is incorrect"
    > > message
    > > > > box.
    > > > > > I had to get some compares done, so I uninstalled Red-Gate and
    > > installed
    > > > > the
    > > > > > previous version to finish my tasks. This morning I re-installed
    the
    > > > > > 3.1.5.191 update, and now the process just hangs without receiving
    > any
    > > > > > error. ?? I was trying to reproduce the error before I submitted
    the
    > > > > > problem. It seems that it (3.1.5.191) works on a small percent of
    > our
    > > > > > databases, but not all like before. It does seem like the
    > unicode/ansi
    > > > > > problem has been resolved in 3.1.5.191.
    > > > > >
    > > > > > Scott Tucholka
    > > > > > AQS
    > > > > >
    > > > > >
    > > > > > "Brian Donahue (Red Gate)" <brian.donahue@red-gate.com> wrote in
    > > message
    > > > > > news:#TXgMkiIEHA.1848@server53...
    > > > > > > Hi Ruvan,
    > > > > > >
    > > > > > > I think this is the same problem as one we've run into last
    > > week.
    > > > I
    > > > > > will
    > > > > > > email a patch to you that should fix the problem.
    > > > > > >
    > > > > > > Regards,
    > > > > > >
    > > > > > > Brian Donahue
    > > > > > > Red Gate Technical Support
    > > > > > >
    > > > > > >
    > > > > > > "Ruvan Fernando" <rufe@[REMOVE-THIS]NETPEOPLE.DK> wrote in
    message
    > > > > > > news:dW2pqofIEHA.3080@server53...
    > > > > > > > Hi Redgate
    > > > > > > >
    > > > > > > > As I mentioned in a previous post I am developing a deploy
    tool.
    > > > > > > > Using some databases works fine, but now I have started to use
    > the
    > > > > > ToolKit
    > > > > > > > on production databases and suddenly the comparison operation
    > > can't
    > > > > > > > complete.
    > > > > > > >
    > > > > > > > I tried to do it using the SQL Compare GUI tool (version
    > > 3.1.5.191)
    > > > > and
    > > > > > > the
    > > > > > > > error also occurs. BUT! What's really strange is that the SQL
    > > > Compare
    > > > > > tool
    > > > > > > > works on the problematic databases from another machine - but
    > not
    > > my
    > > > > > > Deploy
    > > > > > > > application, that still gets the same error as shown below.
    > > > > > > >
    > > > > > > >
    > > > > > > >
    > > > > > > > at System.Diagnostics.EventLog.WriteEvent(Int32 eventID, Int16
    > > > > category,
    > > > > > > > EventLogEntryType type, String[] strings, Byte[] rawData)
    > > > > > > > at System.Diagnostics.EventLog.WriteEntry(String message,
    > > > > > > > EventLogEntryType type, Int32 eventID, Int16 category, Byte[]
    > > > rawData)
    > > > > > > > at System.Diagnostics.EventLog.WriteEntry(String source,
    > String
    > > > > > > message,
    > > > > > > > EventLogEntryType type, Int32 eventID, Int16 category, Byte[]
    > > > rawData)
    > > > > > > > at System.Diagnostics.EventLog.WriteEntry(String source,
    > String
    > > > > > > message,
    > > > > > > > EventLogEntryType type, Int32 eventID, Int16 category)
    > > > > > > > at System.Diagnostics.EventLog.WriteEntry(String source,
    > String
    > > > > > > message,
    > > > > > > > EventLogEntryType type, Int32 eventID)
    > > > > > > > at System.Diagnostics.EventLog.WriteEntry(String source,
    > String
    > > > > > > message,
    > > > > > > > EventLogEntryType type)
    > > > > > > > at
    RedGate.SQLCompare.Engine.Database.GetDependencies(String
    > > sql,
    > > > > > > Boolean
    > > > > > > > quotedIdentifiers, Boolean throwExceptions)
    > > > > > > > at
    > > > RedGate.SQLCompare.Engine.Database.Register(ConnectionProperties
    > > > > > > > connectionProperties, Options options)
    > > > > > > > at Deployer.DatabaseCompare.CompareDatabases() in
    > > > > > > > c:videployerdbcompare.cs:line 52
    > > > > > > > at Deployer.DeployProject.CompareDataBases() in
    > > > > > > > c:videployerdeployproject.cs:line 135
    > > > > > > > at Deployer.Form1.StartCompare_Click(Object sender,
    EventArgs
    > > e)
    > > > in
    > > > > > > > c:videployerform1.cs:line 603
    > > > > > > >
    > > > > > > > The error both the GUI displays and the ToolKit returns is:
    "The
    > > > > > parameter
    > > > > > > > is incorrect" right after examining "comments" objects.
    > > > > > > >
    > > > > > > > I have attached a screenshot also.
    > > > > > > >
    > > > > > > >
    > > > > > > >
    > > > > > > > Both machines that run SQL Compare and my Deploy tool runs on
    > > > Windows
    > > > > > > Server
    > > > > > > > 2003 (the one that works is however a Standard, mine is a
    > > > Enterprise).
    > > > > > > > Databases are SQL Server 2000 running on Windows 2000
    machines.
    > > > > > > >
    > > > > > > >
    > > > > > > > Any ideas?
    > > > > > > >
    > > > > > > > Best regards,
    > > > > > > >
    > > > > > > > Ruvan Fernando
    > > > > > > > System Developer
    > > > > > > > NetPeople A/S
    > > > > > > > Denmark
    > > > > > > >
    > > > > > > >
    > > > > > > >
    > > > > > >
    > > > > > >
    > > > > >
    > > > > >
    > > > >
    > > > >
    > > >
    > > >
    > > >
    > >
    > >
    >
    >
    · Share on Twitter
  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hi Scott,

    Have you tried re-installing SQL Compare 1.51 without the patch that I
    sent you? This had cleared the problem for another customer. We think this
    might have something to do with one of Microsoft's security updates,
    although we haven't had the problem here.

    Regards,

    Brian Donahue
    Red Gate Technical Support

    "Scott Tucholka" <scott.tucholka@aqssys.com> wrote in message
    news:tFIcxR%23IEHA.1240@server53...
    > Hi Brian,
    >
    > I cleaned out the application event log and retried the compare and I
    think
    > I found the problem. We have a couple of large stored procedures that use
    > the ; number feature. Example: CREATE PROC [ EDURE ] [ owner. ]
    > procedure_name [ ; number ] <<. We get an error for each one that we
    have.
    > Before I ran the compare again, I increased my application event log to
    > handle 1024 instead of 512 and I think that allowed the compare to finish.
    > There is also a problem when scripting the number feature that it should
    > drop the procedure before it creates all the joined procedures.
    > Couldn't parse the following [first 16k follows]. Please contact
    > support@red-gate.com.
    >
    >
    /*==========================================================================
    > =======================
    >
    > ** NAME: dbo.AQSsp_OOS_Create_Reapply;1
    >
    >
    >
    > Hopes this helps in debugging,
    > Scott.
    >
    >
    > "Brian Donahue (Red Gate)" <brian.donahue@red-gate.com> wrote in message
    > news:7DhCHR8IEHA.1240@server53...
    > > Hi Scott,
    > >
    > > It must be a problem in the dependency parsing code. I've had an
    email
    > > just today from someone with the same problem, where the application
    event
    > > logs fill up with 'couldn't parse' errors from SQL Compare.
    > >
    > > I am waiting for some information from the other customer, and when
    we
    > > find out what's wrong, I'll let you know.
    > >
    > > Regards,
    > >
    > > Brian Donahue
    > > Red Gate Technical Support
    > >
    > > "Scott Tucholka" <scott.tucholka@aqssys.com> wrote in message
    > > news:14wY2avIEHA.1612@server53...
    > > > After I installed the patch (3.1.6.200), I retried a compare. I
    received
    > a
    > > > message like "Log File is Full" (Cannot recreate to get the exact
    > syntax).
    > > > Then I tried again, and it just locked up. I then rebooted my
    > workstation
    > > > and retried and it locked up again on the 'Reading Comments' step
    > (screen
    > > > shot). Please let me know if you need any additional information.
    > > >
    > > > Scott.
    > > >
    > > > "Brian Donahue (Red Gate)" <brian.donahue@red-gate.com> wrote in
    message
    > > > news:Sdjk$2uIEHA.1236@server53...
    > > > > Hi Scott,
    > > > >
    > > > > The patch is on the way!
    > > > >
    > > > > Brian Donahue
    > > > > Red Gate Technical Support
    > > > >
    > > > > "Scott Tucholka" <scott.tucholka@aqssys.com> wrote in message
    > > > > news:$f0leBnIEHA.1616@server53...
    > > > > > Brian, I think we are having the same problem. After installing
    > > > 3.1.5.191
    > > > > > SQL Compare, we are receiving the "The parameter is incorrect"
    > > message
    > > > > box.
    > > > > > I had to get some compares done, so I uninstalled Red-Gate and
    > > installed
    > > > > the
    > > > > > previous version to finish my tasks. This morning I re-installed
    the
    > > > > > 3.1.5.191 update, and now the process just hangs without receiving
    > any
    > > > > > error. ?? I was trying to reproduce the error before I submitted
    the
    > > > > > problem. It seems that it (3.1.5.191) works on a small percent of
    > our
    > > > > > databases, but not all like before. It does seem like the
    > unicode/ansi
    > > > > > problem has been resolved in 3.1.5.191.
    > > > > >
    > > > > > Scott Tucholka
    > > > > > AQS
    > > > > >
    > > > > >
    > > > > > "Brian Donahue (Red Gate)" <brian.donahue@red-gate.com> wrote in
    > > message
    > > > > > news:#TXgMkiIEHA.1848@server53...
    > > > > > > Hi Ruvan,
    > > > > > >
    > > > > > > I think this is the same problem as one we've run into last
    > > week.
    > > > I
    > > > > > will
    > > > > > > email a patch to you that should fix the problem.
    > > > > > >
    > > > > > > Regards,
    > > > > > >
    > > > > > > Brian Donahue
    > > > > > > Red Gate Technical Support
    > > > > > >
    > > > > > >
    > > > > > > "Ruvan Fernando" <rufe@[REMOVE-THIS]NETPEOPLE.DK> wrote in
    message
    > > > > > > news:dW2pqofIEHA.3080@server53...
    > > > > > > > Hi Redgate
    > > > > > > >
    > > > > > > > As I mentioned in a previous post I am developing a deploy
    tool.
    > > > > > > > Using some databases works fine, but now I have started to use
    > the
    > > > > > ToolKit
    > > > > > > > on production databases and suddenly the comparison operation
    > > can't
    > > > > > > > complete.
    > > > > > > >
    > > > > > > > I tried to do it using the SQL Compare GUI tool (version
    > > 3.1.5.191)
    > > > > and
    > > > > > > the
    > > > > > > > error also occurs. BUT! What's really strange is that the SQL
    > > > Compare
    > > > > > tool
    > > > > > > > works on the problematic databases from another machine - but
    > not
    > > my
    > > > > > > Deploy
    > > > > > > > application, that still gets the same error as shown below.
    > > > > > > >
    > > > > > > >
    > > > > > > >
    > > > > > > > at System.Diagnostics.EventLog.WriteEvent(Int32 eventID, Int16
    > > > > category,
    > > > > > > > EventLogEntryType type, String[] strings, Byte[] rawData)
    > > > > > > > at System.Diagnostics.EventLog.WriteEntry(String message,
    > > > > > > > EventLogEntryType type, Int32 eventID, Int16 category, Byte[]
    > > > rawData)
    > > > > > > > at System.Diagnostics.EventLog.WriteEntry(String source,
    > String
    > > > > > > message,
    > > > > > > > EventLogEntryType type, Int32 eventID, Int16 category, Byte[]
    > > > rawData)
    > > > > > > > at System.Diagnostics.EventLog.WriteEntry(String source,
    > String
    > > > > > > message,
    > > > > > > > EventLogEntryType type, Int32 eventID, Int16 category)
    > > > > > > > at System.Diagnostics.EventLog.WriteEntry(String source,
    > String
    > > > > > > message,
    > > > > > > > EventLogEntryType type, Int32 eventID)
    > > > > > > > at System.Diagnostics.EventLog.WriteEntry(String source,
    > String
    > > > > > > message,
    > > > > > > > EventLogEntryType type)
    > > > > > > > at
    RedGate.SQLCompare.Engine.Database.GetDependencies(String
    > > sql,
    > > > > > > Boolean
    > > > > > > > quotedIdentifiers, Boolean throwExceptions)
    > > > > > > > at
    > > > RedGate.SQLCompare.Engine.Database.Register(ConnectionProperties
    > > > > > > > connectionProperties, Options options)
    > > > > > > > at Deployer.DatabaseCompare.CompareDatabases() in
    > > > > > > > c:videployerdbcompare.cs:line 52
    > > > > > > > at Deployer.DeployProject.CompareDataBases() in
    > > > > > > > c:videployerdeployproject.cs:line 135
    > > > > > > > at Deployer.Form1.StartCompare_Click(Object sender,
    EventArgs
    > > e)
    > > > in
    > > > > > > > c:videployerform1.cs:line 603
    > > > > > > >
    > > > > > > > The error both the GUI displays and the ToolKit returns is:
    "The
    > > > > > parameter
    > > > > > > > is incorrect" right after examining "comments" objects.
    > > > > > > >
    > > > > > > > I have attached a screenshot also.
    > > > > > > >
    > > > > > > >
    > > > > > > >
    > > > > > > > Both machines that run SQL Compare and my Deploy tool runs on
    > > > Windows
    > > > > > > Server
    > > > > > > > 2003 (the one that works is however a Standard, mine is a
    > > > Enterprise).
    > > > > > > > Databases are SQL Server 2000 running on Windows 2000
    machines.
    > > > > > > >
    > > > > > > >
    > > > > > > > Any ideas?
    > > > > > > >
    > > > > > > > Best regards,
    > > > > > > >
    > > > > > > > Ruvan Fernando
    > > > > > > > System Developer
    > > > > > > > NetPeople A/S
    > > > > > > > Denmark
    > > > > > > >
    > > > > > > >
    > > > > > > >
    > > > > > >
    > > > > > >
    > > > > >
    > > > > >
    > > > >
    > > > >
    > > >
    > > >
    > > >
    > >
    > >
    >
    >
    · Share on Twitter
This discussion has been closed.