Error Committing a New Database - Unexpected Token 'PAGE'

Early Access Program for SQL Source Control

Moderators: Chris Auckland, David Atkinson, sherr

Error Committing a New Database - Unexpected Token 'PAGE'

Postby AndrewJacksonZA » Mon May 10, 2010 8:43 am

I'm adding a database to source control for the first time. I'm getting the following error:
Code: Select all
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
 
Posts: 17
Joined: Wed May 05, 2010 11:09 am
Location: Johannesburg, South Africa

Postby AndrewJacksonZA » Wed May 12, 2010 1:34 pm

Is there any more information that I can provide that would help you guys solve this?

Code: Select all
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
 
Posts: 17
Joined: Wed May 05, 2010 11:09 am
Location: Johannesburg, South Africa

Error Committing a New Database - Unexpected Token 'PAGE'

Postby sherr » Thu May 20, 2010 6:15 pm

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
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