How can we help you today? How can we help you today?

Error on adding database to source control

Apologies if this is not the spot to post errors:
After installing and testing on a small database I added our test database to the source control but received the folling errors on committing to sourve control



receivedFailed to update:
#oEc.#8Jf: Errors occured whilst parsing file C:\Documents and Settings\gcadmin\Local Settings\Application Data\Red Gate\SQL Source Control 0\Transients\713599f5-41c4-4426-b0e1-da7987683cd7\Tables\dbo.Sheet1$.sql
'line 11:44: expecting "on", found '$Insert''
'line 14:3: unexpected token: ["AS",<638>,line=14,col=3] [char=272]'
'line 14:3: unexpected token: ["AS",<638>,line=14,col=3] [char=272]'
---> #Eyg.#Lyg: Errors occured whilst parsing file C:\Documents and Settings\gcadmin\Local Settings\Application Data\Red Gate\SQL Source Control 0\Transients\713599f5-41c4-4426-b0e1-da7987683cd7\Tables\dbo.Sheet1$.sql
'line 11:44: expecting "on", found '$Insert''
'line 14:3: unexpected token: ["AS",<638>,line=14,col=3] [char=272]'
'line 14:3: unexpected token: ["AS",<638>,line=14,col=3] [char=272]'
---> line 11:44: expecting "on", found '$Insert'
--- 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 RedGate.SQLSourceControl.Engine.Cancellables.CancellableOperation.#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)
gordonc75
0

Comments

1 comment

  • StephanieHerr
    Hello,

    It looks like we may be having problems parsing your table name since it includes a $. Would you be able to email SqlSourceControlSupport@red-gate.com the CREATE script for this table so that we can try to reproduce the problem here?

    Thanks for your help!
    Stephanie M. Herr :-)
    SQL Source Control Project Manager
    StephanieHerr
    0

Add comment

Please sign in to leave a comment.