# Liquibase on SQL SERVER 2008R2, create table Databasechangeloglock failed.

**URL:** <https://forum.liquibase.org/t/liquibase-on-sql-server-2008r2-create-table-databasechangeloglock-failed/3708>\
**Category:** General Discussion\
**Created:** [January 16, 2019, 10:29pm UTC](https://forum.liquibase.org/t/liquibase-on-sql-server-2008r2-create-table-databasechangeloglock-failed/3708 "2019-01-16T22:29:00Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![saurabh](https://avatars.discourse-cdn.com/v4/letter/s/ee7513/32.png) [@saurabh](https://forum.liquibase.org/u/saurabh)\
**Post date:** [January 16, 2019, 10:29pm UTC](https://forum.liquibase.org/t/liquibase-on-sql-server-2008r2-create-table-databasechangeloglock-failed/3708/1 "2019-01-16T22:29:00Z")

</div>

)  
 at liquibase.lockservice.StandardLockService.waitForLock(StandardLockService.java:207)  
 at liquibase.Liquibase.update(Liquibase.java:184)  
 at liquibase.Liquibase.update(Liquibase.java:179)  
 at liquibase.integration.commandline.Main.doMigration(Main.java:1205)  
 at liquibase.integration.commandline.Main.run(Main.java:191)  
 at liquibase.integration.commandline.Main.main(Main.java:129)  
Caused by: liquibase.exception.DatabaseException: Column, parameter, or variable #2: Cannot find data type BOOLEAN. [Failed SQL: CREATE TABLE DATABASECHANGELOGLOCK (ID INT NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED datetime, LOCKEDBY VARCHAR(255), CONSTRAINT PK\_DATABASECHANGELOGLOCK PRIMARY KEY (ID))]  
 at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:356)  
 at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:57)  
 at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:125)  
 at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:109)  
 at liquibase.lockservice.StandardLockService.init(StandardLockService.java:97)  
 at liquibase.lockservice.StandardLockService.acquireLock(StandardLockService.java:246)  
 … 6 common frames omitted  
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Column, parameter, or variable #2: Cannot find data type BOOLEAN.  
 at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:217)  
 at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1655)  
 at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:885)  
 at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:778)  
 at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7505)  
 at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2445)  
 at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:191)  
 at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:166)  
 at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:751)  
 at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:352)  
 … 11 common frames omitted  
  
  
For more information, please use the --logLevel flag