# Liquibase for SQL Server 2008R2, DATABASECHANGLOGLOCK table creation failed.

**URL:** <https://forum.liquibase.org/t/liquibase-for-sql-server-2008r2-databasechangloglock-table-creation-failed/3993>\
**Category:** Liquibase Development\
**Created:** [January 16, 2019, 10:27pm UTC](https://forum.liquibase.org/t/liquibase-for-sql-server-2008r2-databasechangloglock-table-creation-failed/3993 "2019-01-16T22:27:00Z")\
**Posts on this page:** 2\
**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:27pm UTC](https://forum.liquibase.org/t/liquibase-for-sql-server-2008r2-databasechangloglock-table-creation-failed/3993/1 "2019-01-16T22:27:00Z")

</div>

While running Liquibase on SQL SERVER 2008R2, create table databasechangeloglock failed with below error&nbsp;

C:\Liquibase\>liquibase update  
)  
 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

---

<div class="post-metadata">

**Author:** ![vishun](https://avatars.discourse-cdn.com/v4/letter/v/a5b964/32.png) [@vishun](https://forum.liquibase.org/u/vishun)\
**Post date:** [March 8, 2022, 2:28pm UTC](https://forum.liquibase.org/t/liquibase-for-sql-server-2008r2-databasechangloglock-table-creation-failed/3993/2 "2022-03-08T14:28:57Z")

</div>

In `3.6.0`, `3.6.1`, `3.6.2` version, may be a bug , the code judge sqlserver version is: `majorVersion <= MSSQL_SERVER_VERSIONS.MSSQL2008` in the file `liquibase/liquibase-core/src/main/java/liquibase/database/core/MSSQLDatabase.java `, but it should be `<`, so do not use this three version.