Corrupt Source File in TFS failing SQL Source Control Commit

I am getting this error in 2 linked SQL databases:

There was an error parsing the file "C:UsersSQLDBAAppDataLocalRed GateSQL Source Control 4Transientszm34t4qv.u1sStored Proceduresdbo.DC_SP_BIL_GetPolicyTermRenewalConfigAsXML.sql" at line 16, column 7, near text ,

To resolve this issue:

1. Open the affected file.

2. Edit it to ensure the SQL is valid.

3. Commit the changes without using SQL Source Control. For example by using Tortoise SVN, or Microsoft Team Explorer.
I have found the file on disk and verified the SQL and compiled it without error, replaced it and checked it in via TFS.

I even started brand new and re-typed the whole thing in another script.

What else can I do?

Thanks in advance
Steve Middleton
Senior Database Developer

Comments

  • Sergio RSergio R Posts: 394 Rose Gold 1
    Hi Steve,

    I have opened a support ticket and I am going to contact you through there.

    Thank you,
    Sergio
    Product Support Engineer
    Redgate Software Ltd
    Please see our Help Center for detailed guides on how to use our tools
  • crimdoncrimdon Posts: 51 Bronze 2
    I seem to get this on a regular basis. The fix is to update the SQL script in your workspace and then check it back in to TFS.

    Seems to me that Source Control sometimes adds corrupted lines to the end of scripts. TFS doesn't seem to be the common link either as I've also have it happen with a local file repo.
Sign In or Register to comment.