Red Gate forums :: View topic - Cannot get past error
Return to www.red-gate.com RSS Feed Available

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

Cannot get past error

Search in SQL Source Control 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
rsboczkay



Joined: 06 Oct 2010
Posts: 3

PostPosted: Wed Oct 06, 2010 3:34 pm    Post subject: Cannot get past error Reply with quote

I was trying to test out the software but when checking in an entire db got the following error which I cannot seem to get past:

There was a serious error parsing the file "C:\Documents and Settings\rsboczkay\Local Settings\Application Data\Red Gate\SQL Source Control 1\WorkingBases\htbf31pg.i5f\Stored Procedures\dbo.GetMapPolygonsLowest.sql".
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.
4. In SQL Source Control, click Refresh.
For more information, click Show complete error message.

The detailed error is:

Errors occurred whilst parsing file C:\Documents and Settings\rsboczkay\Local Settings\Application Data\Red Gate\SQL Source Control 1\Transients-TFS\r2jb4dov.dto\Stored Procedures\dbo.GetMapPolygonsLowest.sql
'line 1:1670: unexpected token: ["WHERE",<687>,line=1,col=1670] [char=1379]'
'line 1:1976: expecting "COLCOL", found 'as''
'line 1:2366: unexpected token: ["WHERE",<687>,line=1,col=2366] [char=1882]'

I tried doing what it says but there are no errors in the SP it is referring to. The COLCOL part doesn't make any sense. Ideas? Maybe put in an option to ignore these warnings or not validate my sql syntax at all...
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 757
Location: Red Gate Software Ltd.

PostPosted: Fri Oct 08, 2010 1:26 pm    Post subject: Reply with quote

Thanks for your post.

The problem might be that our own parser doesn't support some of the syntax in the file.

Would you be able to send me the file so I can check if this is the case?

"C:\Documents and Settings\rsboczkay\Local Settings\Application Data\Red Gate\SQL Source Control 1\WorkingBases\htbf31pg.i5f\Stored Procedures\dbo.GetMapPolygonsLowest.sql"

I've also send this in an email so you can reply to that rather then post the object here.
_________________
Chris
Back to top
View user's profile Send private message Send e-mail
rsboczkay



Joined: 06 Oct 2010
Posts: 3

PostPosted: Tue Oct 12, 2010 4:57 pm    Post subject: Resolved Reply with quote

Figured it out... We use the terms Geography and Geometry as table aliases which your parser does not like. Must be new reserved words in SQL 2008. Once I changed them this problem went away. I now have a new issue which I have posted in another thread.
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 757
Location: Red Gate Software Ltd.

PostPosted: Tue Oct 12, 2010 5:00 pm    Post subject: Reply with quote

I was just about to get back to you about that.

I found exactly the same thing. Using the 'Geometry' keyword as a table alias, seems to confuse our parser. I've logged this as a bug (SC-4853)

I'll let you know when a fix is available.
_________________
Chris
Back to top
View user's profile Send private message Send e-mail
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