Red Gate forums :: View topic - Error parsing file when attempting to commit changes
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Source Control 3
SQL Source Control 3 forum

Error parsing file when attempting to commit changes

Search in SQL Source Control 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
tlentine



Joined: 29 Sep 2011
Posts: 3

PostPosted: Thu Aug 23, 2012 9:24 pm    Post subject: Error parsing file when attempting to commit changes Reply with quote

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.
Back to top
View user's profile Send private message
Marie



Joined: 01 Sep 2012
Posts: 1

PostPosted: Sat Sep 01, 2012 7:15 pm    Post subject: Also getting parsing file error Reply with quote

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.
Back to top
View user's profile Send private message
pmiskell



Joined: 10 Sep 2012
Posts: 2

PostPosted: Mon Sep 10, 2012 4:10 am    Post subject: Error parsing file when attempting to commit changes Reply with quote

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.
Back to top
View user's profile Send private message
stanori



Joined: 23 Apr 2012
Posts: 84

PostPosted: Tue Sep 11, 2012 12:17 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
pmiskell



Joined: 10 Sep 2012
Posts: 2

PostPosted: Sun Sep 16, 2012 11:50 pm    Post subject: Thx for the info Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group