cancel
Showing results for 
Search instead for 
Did you mean: 

Liquibase mssql

dzwiers
Champ in-the-making
Champ in-the-making
Hi All,

I'm trying to setup 6.0 beta 2 against mssql 2014 and I'm running into some issues with liquibase generating incorrect ddl statements. How can I disable liquibase in the Beta?

Thanks!

Log snippet:

16:55:37,306 ERROR [stderr] (ServerService Thread Pool – 71) INFO 2/25/16 4:55 PM:liquibase: classpath:META-INF/liquibase/db-changelog-onpremise.xml: 1.1::activiti: Reading from [dbo].[DATABASECHANGELOG]

16:55:37,312 ERROR [stderr] (ServerService Thread Pool – 71) SEVERE 2/25/16 4:55 PM:liquibase: classpath:META-INF/liquibase/db-changelog-onpremise.xml: 1.1::activiti: Change Set classpath:META-INF/liquibase/db-changelog-onpremise.xml::1.1::activiti failed.  Error: Error executing SQL ALTER TABLE [dbo].[RELATED_CONTENT] DROP CONSTRAINT select d.name from syscolumns c,sysobjects d, sysobjects t where c.id=t.id AND d.parent_obj=t.id AND d.type='D' AND t.type='U' AND c.name='temporary' AND t.name='RELATED_CONTENT': Incorrect syntax near the keyword 'select'.

16:55:37,312 ERROR [stderr] (ServerService Thread Pool – 71) liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE [dbo].[RELATED_CONTENT] DROP CONSTRAINT select d.name from syscolumns c,sysobjects d, sysobjects t where c.id=t.id AND d.parent_obj=t.id AND d.type='D' AND t.type='U' AND c.name='temporary' AND t.name='RELATED_CONTENT': Incorrect syntax near the keyword 'select'.
1 REPLY 1

jbarrez
Star Contributor
Star Contributor
Hmm we do have tests on sql server, but not sure about version 2014.
We'll look into it.