Commit changes tab error: unexpected token

JosvanDuijn

Hi,

I'm trying to setup SQL Source Control 3.4.8.18.
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?

Thanks,
Jos

Evan Moss

Thanks for your post. We've opened up a support ticket and will be in contact with you shortly.