AnsweredAssumed Answered

Liquibase mssql

Question asked by dzwiers on Feb 25, 2016
Latest reply on Mar 1, 2016 by jbarrez
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'.

Outcomes