Commit changes tab error: unexpected token

A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.

Commit changes tab error: unexpected token

Postby JosvanDuijn » Wed Jul 24, 2013 4:02 pm


I'm trying to setup SQL Source Control
I've added a couple of database successfully, but on one database I get the following exception, but it does not specify which file has the problem.

RedGate.SQLSourceControl.Engine.SqlCompareException: unexpected token: ["IIF",<986>,line=107,col=4] [char=4871] ---> antlr.NoViableAltException: unexpected token: ["IIF",<986>,line=107,col=4] [char=4871]
at RedGate.SQLCompare.ASTParser.StructureParser.#fhU(Exception #9Z)
at RedGate.SQLCompare.ASTParser.StructureParser.statementFirstInBatch()
at RedGate.SQLCompare.ASTParser.StructureParser.statementBatch()
at RedGate.SQLCompare.ASTParser.StructureParser.expr()
at RedGate.SQLCompare.Engine.DatabaseFromScriptObjectResolver.ColumnsInObject(ISqlObject obj)
at RedGate.SQLCompare.Engine.DatabaseFromScriptObjectResolver.#XGh(SchemaObject #61Qb)
at #Eyg.#Gyg.#LCdd()
at #Eyg.#Gyg.#vl(IEnumerable`1 #rXrc)
at RedGate.SQLCompare.Engine.Database.Register(String path, ScriptDatabaseInformation dbinfo, Options options, IEnumerable`1 filesToUse, IReadFromFolderCache cache)
at #NsZc.#y0Lc.#PsZc(String #yIc, ICompareScriptDatabaseInformation #P53c, ICompareOptions #5OPb, Boolean #jf4c)
at RedGate.SQLSourceControl.Engine.Diff.CompareEngineUtils.WrapRegisterWithCache(ICompareDatabase db, String path, ICompareScriptDatabaseInformation scriptFolderOptions, ICompareOptions options, Boolean isDatabaseCaseSensitive)
at #GWeb.#WXM.#TAb.#Byed()
at #NsZc.#MsZc.#gKf(Action #sxPb)
--- End of inner exception stack trace ---

We use the following version of SQL Server:
Microsoft SQL Server 2012 (SP1) - 11.0.3000.0 (X64)
Oct 19 2012 13:38:57
Copyright (c) Microsoft Corporation
Enterprise Edition: Core-based Licensing (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

Can someone help me find the cause of this problem?

Posts: 9
Joined: Tue Jan 25, 2011 9:36 am

Postby Evan Moss » Fri Jul 26, 2013 10:49 pm

Thanks for your post. We've opened up a support ticket and will be in contact with you shortly.
Evan Moss
Product Support
(866) 627-8107
Evan Moss
Posts: 112
Joined: Wed Jun 12, 2013 8:56 pm

Return to SQL Source Control Previous Versions

Who is online

Users browsing this forum: No registered users and 1 guest