Red Gate forums :: View topic - Error when finding changes to commit for prev. linked DB
Return to www.red-gate.com RSS Feed Available

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

Error when finding changes to commit for prev. linked DB

Search in SQL Source Control EAP forum
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.
Jump to:  
Author Message
dbachman



Joined: 11 Feb 2010
Posts: 1

PostPosted: Thu Feb 11, 2010 10:46 pm    Post subject: Error when finding changes to commit for prev. linked DB Reply with quote

Microsoft SQL Server 2008 (SP1) - 10.0.2723.0 (Intel X86) Jul 10 2009 01:41:08 Copyright (c) 1988-2008 Microsoft Corporation Standard Edition on Windows NT 5.2 <X86> (Build 3790: Service Pack 2)

Connecting with windows authentication.

Failed to update:
#oEc.#8Jf: Errors occured whilst parsing file C:\Users\DBachman\AppData\Local\Red Gate\SQL Source Control 0\WorkingBases\798f80c1-7997-4372-963e-a5827d6e0ec0\Stored Procedures\dbo.sproc_System_SSBQueue_Predicto_MessageReceive_Process_TopN.sql
'line 43:17: expecting "Integer", found '@N''
'line 55:33: unexpected token: [";",<631>,line=55,col=33] [char=1233]'
---> cZ: Errors occured whilst parsing file C:\Users\DBachman\AppData\Local\Red Gate\SQL Source Control 0\WorkingBases\798f80c1-7997-4372-963e-a5827d6e0ec0\Stored Procedures\dbo.sproc_System_SSBQueue_Predicto_MessageReceive_Process_TopN.sql
'line 43:17: expecting "Integer", found '@N''
'line 55:33: unexpected token: [";",<631>,line=55,col=33] [char=1233]'
---> line 43:17: expecting "Integer", found '@N'
--- End of inner exception stack trace ---
at #oEc.#7Jf.#t.#B3.#sKf()
at #oEc.#7Jf.#gKf(Action action)
--- End of inner exception stack trace ---

Server stack trace:
at #eEc.#fEc.#t.#izb.#j5f()
at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
at System.Runtime.Remoting.Messaging.StackBuilderSink.PrivateProcessMessage(RuntimeMethodHandle md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
at System.Runtime.Remoting.Messaging.StackBuilderSink.AsyncProcessMessage(IMessage msg, IMessageSink replySink)

Exception rethrown at [0]:
at RedGate.SQLSourceControl.CommonUI.Forms.ErrorDialog.DoWithObviousExceptionsThrowAll(Action action)
at #JLc.#PLc.#CTc(ICancellableOperation`1 operation, Object token)
Back to top
View user's profile Send private message AIM Address
sherr



Joined: 19 Mar 2009
Posts: 125
Location: Cambridge

PostPosted: Fri Feb 12, 2010 11:04 am    Post subject: Error when finding changes to commit for prev. linked DB Reply with quote

It looks like we are having a problem parsing the following stored procedure:
C:\Users\DBachman\AppData\Local\Red Gate\SQL Source Control 0\WorkingBases\798f80c1-7997-4372-963e-a5827d6e0ec0\Stored Procedures\dbo.sproc_System_SSBQueue_Predicto_MessageReceive_Process_TopN.sql

From the information you provided:
'line 55:33: unexpected token: [";",<631>,line=55,col=33] [char=1233]'
There's a known issue about semi-colons with 2008 stored procedures, which we are currently working (internal reference number SOC-600).

But, it seems like there may be another issue because it shows that a problem actually occurs on another line:
'line 43:17: expecting "Integer", found '@N''

Could you please email the stored procedure to SqlSourceControlSupport@red-gate.com so we can replicate your issue and make sure we can parse it correctly?

Thank you!
Back to top
View user's profile Send private message
Display posts from previous:   
This topic is locked: you cannot edit posts or make replies. 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