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

Error Committing a New Database - Unexpected Token 'PAGE'

I'm adding a database to source control for the first time. I'm getting the following error:
Failed to update:
#oEc.#8Jf: Errors occured whilst parsing file C:\Documents and Settings\xxxx\Local Settings\Application Data\Red Gate\SQL Source Control 0\WorkingBases\bocabwbh.yom\Tables\dbo.doc_TT.sql
'line 19:118: unexpected token: ["PAGE",<698>,line=19,col=118] [char=927]'
 ---> #Eyg.#Lyg: Errors occured whilst parsing file C:\Documents and Settings\xxxx\Local Settings\Application Data\Red Gate\SQL Source Control 0\WorkingBases\bocabwbh.yom\Tables\dbo.doc_TT.sql
'line 19:118: unexpected token: ["PAGE",<698>,line=19,col=118] [char=927]'
 ---> line 19:118: unexpected token: ["PAGE",<698>,line=19,col=118] [char=927]
   --- End of inner exception stack trace ---
   at #Eyg.#Gyg.#CGh(FileInfo file)
   at #Eyg.#Gyg.#vl()
   at RedGate.SQLCompare.Engine.Database.Register(String path, ScriptDatabaseInformation dbinfo, Options options)
   at #G3c.#L3c.#t.#u3.#i4c()
   at #oEc.#7Jf.#hKf(ICancellableOperationStatus status, ICancellable database, Action action)
   at #oEc.#7Jf.#t.#B3.#sKf()
   at #oEc.#7Jf.#gKf(Action action)
   --- End of inner exception stack trace ---

Server stack trace: 
   at #oEc.#7Jf.#gKf(Action action)
   at #oEc.#7Jf.#jKf(ICancellableOperationStatus status, ICancellable database, Action action)
   at #G3c.#L3c.#e4c(String path, #M3c args)
   at #G3c.#K3c.#83c(String path, TArg argument)
   at #G3c.#L3c.#f6c(String path, ScriptDatabaseInformation folderOptions, Options options, ICancellableOperationStatus status)
   at #oEc.#i7c.#t.#9Jf.#t.#2Db.#TSi()
   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 System.Runtime.Remoting.Proxies.RealProxy.EndInvokeHelper(Message reqMsg, Boolean bProxyCase)
   at System.Runtime.Remoting.Proxies.RemotingProxy.Invoke(Object NotUsed, MessageData& msgData)
   at RedGate.SQLSourceControl.Engine.Action.EndInvoke(IAsyncResult result)
   at RedGate.SQLSourceControl.Engine.Cancellables.CancellableOperation.#zIc(ICancellableOperationStatus status, Pair`2[] labelledActions)
   at #oEc.#i7c.#t.#9Jf.#SSi()
   at #oEc.#7Jf.#t.#9Jf.#uKf()
   at #oEc.#7Jf.#hKf(ICancellableOperationStatus status, ICancellable database, Action action)
   at #oEc.#7Jf.#lKf[T](ICancellableOperationStatus status, ICancellable database, Func`1 function)
   at #oEc.#i7c.#QSi[TDiffType](ICancellableOperationStatus status, IReadOnlySourceControlServerCallBacks sourceControlUserCallBacks, ScriptDatabaseInformation folderOptions)
   at #oEc.#i7c.#t.#z2.#hOi()
   at #oEc.#i7c.#bOi[TDiffType](ICancellableOperationStatus status, Func`1 innerBuild)
   at #oEc.#i7c.#q1f(ICancellableOperationStatus status, IReadOnlySourceControlServerCallBacks sourceControlUserCallBacks, ScriptDatabaseInformation folderOptions)
   at #oEc.#4Ec.#z7c(ICancellableOperationStatus status, IReadOnlySourceControlServerCallBacks sourceControlUserCallBacks)
   at #oEc.#4Ec.#7Jc(ICancellableOperationStatus status, IReadOnlySourceControlServerCallBacks sourceControlUserCallBacks)
   at #oEc.#4Ec.#t.#A2.#D7c(ICancellableOperationStatus status)
   at #eEc.#iEc.#t.#u3.#k5f()
   at RedGate.SQLSourceControl.Engine.Cancellables.CancellableOperationBase.InvokeWithTracker(Action action)
   at #eEc.#iEc.Invoke()
   at #JLc.#Qlg.Invoke()
   at #mMc.#8Ec.#t.#57c.#l8i()
   at #mMc.#8Ec.#LBf(Action action)
   at #mMc.#8Ec.#LBf[T](Func`1 action)
   at #JLc.#PLc.#t.#Jfb.#EJf()
   at RedGate.SQLSourceControl.Engine.SmartAssembly.ExceptionReporting.ErrorReporterBase.#Mwf(Action toDo, Predicate`1 shouldReportPredicate)
   at RedGate.SQLSourceControl.Engine.SmartAssembly.ExceptionReporting.ErrorReporterBase.Do(Action toDo, Predicate`1 shouldReportPredicate, Boolean rethrow)
   at RedGate.SQLSourceControl.Engine.SmartAssembly.ExceptionReporting.ErrorReporterBase.DoWithObviousExceptionsRethrowAll(Action action)
   at RedGate.SQLSourceControl.CommonUI.Forms.ErrorDialog.DoWithObviousExceptionsRethrowAll(Action action)
   at #JLc.#PLc.#CTc(ICancellableOperation`1 operation, Object token)

What is the next step in resolving this?

Thank you.
AndrewJacksonZA
0

Comments

2 comments

  • AndrewJacksonZA
    Is there any more information that I can provide that would help you guys solve this?
    PRINT @@VERSION:
    
    Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (Intel X86) 
    	Mar 29 2009 10:27:29 
    	Copyright (c) 1988-2008 Microsoft Corporation
    	Developer Edition on Windows NT 5.1 <X86> (Build 2600: Service Pack 3)
    
    [/code]
    AndrewJacksonZA
    0
  • StephanieHerr
    This error occurs because we currently don't support the SQL Server 2008 DATA_COMPRESSION keyword. We will be looking into this soon.

    For now, you would need to turn off the data compression on your tables to work with SQL Source Control. We'll update this posting once this is supported.

    You can vote/comment on this feature in our Suggestion Forum at http://redgate.uservoice.com/forums/390 ... ?ref=title

    Thank you!
    Stephanie M. Herr :-)
    SQL Source Control - Project Manager
    StephanieHerr
    0

Add comment

Please sign in to leave a comment.