Error when finding changes to commit for prev. linked DB

Early Access Program for SQL Source Control

Moderators: Chris Auckland, David Atkinson, sherr

Error when finding changes to commit for prev. linked DB

Postby dbachman » Thu Feb 11, 2010 10:46 pm

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)
dbachman
 
Posts: 1
Joined: Thu Feb 11, 2010 10:42 pm

Error when finding changes to commit for prev. linked DB

Postby sherr » Fri Feb 12, 2010 11:04 am

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!
sherr
 
Posts: 126
Joined: Thu Mar 19, 2009 12:45 pm
Location: Cambridge


Return to SQL Source Control EAP

Who is online

Users browsing this forum: No registered users and 0 guests