How can we help you today? How can we help you today?

Error with Source Control - Unable to case object of type 'RedGate.SQLCompare...'

We have one database that is throwing this error in our SQL Source Control environment:

Unable to cast object of type 'RedGate.SQLCompare.ASTParser.Syntax.Element' to type 'RedGate.SQLCompare.ASTParser.Syntax.SearchCondition'. I've searched for this error and the only similar references I see are from 2011 or older. This just started happening on one database in our environment and blocks using the Redgate tool for source control for that one DB. 

Has anyone else encountered this and is there a fix?

Thanks!
Roger
0

Comments

6 comments

Sort by
  • Jon_Kirkwood

    Hi rsutherland_slc

     

    Thank you for reaching out on the Redgate forums, and sorry to hear about your SQL Source Control errors.

    I have tackled this issue previously, in most cases it was some bad or unprocessable code introduced into the Source Control project that is throwing the exception. 

     

    First suggestion is to unlink and relink your database from source control and see if this clears the error.


    If this does not, then to be able to replicate this issue, we need a DBCC CLONEDATABASE backup of the database (which is a schema only backup) and a zipped copy of the Working Base and Transient Folders of the database from SQL Source Control.

     

    To find the location of these folders, please go to the Setup tab on SQL Source Control and click on Show on the Under the hood section.

     

    The Working Base and Transient Folders contain the database scripts that SQL Source Control uses as part of its comparison process.

    For more information on this subject, please read: http://documentation.red-gate.com/display/SOC7/How+SQL+Source+Control+works+behind+the+scenes

     


    I have created a secure file link to upload your clone backup & folders from Source Control.

    This link is valid for 14 days

    https://files.red-gate.com/requests/5B1rAdH3TIeXrI6Ca42J5B

     

    Jon_Kirkwood
    0
  • rsutherland_slc
    Hey Jon, thanks for your response. Unfortunately, due to the holiday schedule, we were not able to complete the activities to provide the data within the 14 days for the link. Can you provide another link?

    We did try unlinking and linking the db a couple of times, with no success. 

    Thanks again!

    rsutherland_slc
    0
  • rsutherland_slc
    Hey @Jon_Kirkwood, 

    Can you provide another link for us to deliver the files to?

    Thanks!
    rsutherland_slc
    0
  • Jon_Kirkwood
    Hi and happy new year.

    A new file link can be accessed here:
    https://files.red-gate.com/requests/17VmjqHSTXf00BCRPK0tRC

    Jon_Kirkwood
    0
  • smad0210
    Hi Jon.  I work with Roger.  The files you requested were sent last Friday (1/26).  Thanks for your assistance!

    -Steve
    smad0210
    0
  • smad0210
    Hi Jon.  Just checking in to see if you have an update for us.  Thank you!

    -Steve
    smad0210
    0

Add comment

Please sign in to leave a comment.