Error parsing file when attempting to commit changes

A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.

Moderators: Chris Auckland, David Atkinson, sherr, PhilScrace, andy.campbell.smith

Error parsing file when attempting to commit changes

Postby tlentine » Thu Aug 23, 2012 9:24 pm

I am using SQL Server Management Studio 2012 with SQL Source Control Version 3.0.13.4214.

When attempting to either Commit Changes or Get Latest I repeatedly receive an error similar to the following:

There was an error parsing the file "%appdata%\\local\\Red Gate\\SQL Source Control 3\\Transients-Vault\\some gibberish\\Tables\\TableName.sql

The odd thing is that if I refresh the page the same error will appear with a different table or sproc name.

I am unable to move past these sets of errors to check code in or pull code from source control.

Any idea what might be causing this issue and how to correct it?

Thanks in advance.
tlentine
 
Posts: 3
Joined: Thu Sep 29, 2011 3:08 pm

Also getting parsing file error

Postby Marie » Sat Sep 01, 2012 7:15 pm

I am evaluating both SQL Connect and SQL Source Control to improve our SQL developer experience as the Visual Studio tools have a long way to go yet. But at initial set up with either tool, I have run across the "error parsing" message on a number of our stored procedures. I've tried cleaning up the queries but some of them are quite simple (i.e. Update table set column = value where id = @id). There's not much to fix with that query but somehow I cannot get past this error. Is there a way around this issue?

I am using SSMS 10.50.2500.0 with TFS 2012. I also tried against TFS 2010 but got the same error.
Marie
 
Posts: 1
Joined: Sat Sep 01, 2012 7:03 pm

Error parsing file when attempting to commit changes

Postby pmiskell » Mon Sep 10, 2012 4:10 am

In my case, every single file has a GO statement without a newline character in front of it (e.g.:

) ON [PRIMARY]GO

It should look like this:

) ON [PRIMARY]
GO

Maybe the linefeed/carraige return is incorrect in the file generated by Redgate Source Control.
pmiskell
 
Posts: 2
Joined: Mon Sep 10, 2012 4:00 am

Postby stanori » Tue Sep 11, 2012 12:17 am

Hi,

Thanks for your post. If you are using any new SQL Server objects that were introduced with SQL Server 2012, they are not yet compatible with SQL Source Control and will throw errors.

We have opened a support case and will be following up with you shortly.

Best Regards,
Steve Tanori
_________________
Steve Tanori
Product Support
Red Gate Software Ltd.
866-997-0378
stanori
 
Posts: 84
Joined: Mon Apr 23, 2012 1:13 pm

Thx for the info

Postby pmiskell » Sun Sep 16, 2012 11:50 pm

That makes sense. I scripted a database from Azure to a local server. I probably forgot to change the destination server type to Local SQL Server with the tool I use for database migration.

The wierd part is Source Control has no problem with the Azure server. Only the local server.

Thx.
pmiskell
 
Posts: 2
Joined: Mon Sep 10, 2012 4:00 am


Return to SQL Source Control 3

Who is online

Users browsing this forum: No registered users and 0 guests

cron