Red Gate forums :: View topic - Error Committing a New Database - Unexpected Token 'PAGE'
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Source Control EAP
SQL Source Control EAP forum

Error Committing a New Database - Unexpected Token 'PAGE'

Search in SQL Source Control EAP forum
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.
Jump to:  
Author Message
AndrewJacksonZA



Joined: 05 May 2010
Posts: 17
Location: Johannesburg, South Africa

PostPosted: Mon May 10, 2010 8:43 am    Post subject: Error Committing a New Database - Unexpected Token 'PAGE' Reply with quote

I'm adding a database to source control for the first time. I'm getting the following error:
Code:
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.
Back to top
View user's profile Send private message
AndrewJacksonZA



Joined: 05 May 2010
Posts: 17
Location: Johannesburg, South Africa

PostPosted: Wed May 12, 2010 1:34 pm    Post subject: Reply with quote

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

Code:
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]
Back to top
View user's profile Send private message
sherr



Joined: 19 Mar 2009
Posts: 125
Location: Cambridge

PostPosted: Thu May 20, 2010 6:15 pm    Post subject: Error Committing a New Database - Unexpected Token 'PAGE' Reply with quote

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/39019-sql-source-control/suggestions/606769-support-for-sql-server-2008-data-compression-key?ref=title

Thank you!
Stephanie M. Herr Smile
SQL Source Control - Project Manager
Back to top
View user's profile Send private message
Display posts from previous:   
This topic is locked: you cannot edit posts or make replies. All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group