Comments
1 comment
-
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!
Add comment
Please sign in to leave a comment.
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)