Can someone explain to me why this is happening and a possible workaround? I’m using SQL Server 2008. I think this is in a view rather than an actual table…
INFO 7/5/11 3:52 PM:liquibase: Reading foreign keys for sa @ jdbc:sqlserver://10.212.0.22:1433;xopenStates=false;sendTimeAsDatetime=true;trustServerCertificate=false;sendStringParametersAsUnicode=true;selectMethod=direct;resp
onseBuffering=adaptive;packetSize=8000;loginTimeout=15;lockTimeout=-1;lastUpdateCount=true;encrypt=false;disableStatementPooling=true;databaseName=ch33metrics;applicationName=Microsoft SQL Server JDBC Driver; (Default Schema:
dbo) …
DEBUG 7/5/11 3:52 PM:liquibase: Reading primary keys for sa @ jdbc:sqlserver://10.212.0.22:1433;xopenStates=false;sendTimeAsDatetime=true;trustServerCertificate=false;sendStringParametersAsUnicode=true;selectMethod=direct;res
ponseBuffering=adaptive;packetSize=8000;loginTimeout=15;lockTimeout=-1;lastUpdateCount=true;encrypt=false;disableStatementPooling=true;databaseName=ch33metrics;applicationName=Microsoft SQL Server JDBC Driver; (Default Schema
: dbo) …
INFO 7/5/11 3:52 PM:liquibase: Reading primary keys for sa @ jdbc:sqlserver://10.212.0.22:1433;xopenStates=false;sendTimeAsDatetime=true;trustServerCertificate=false;sendStringParametersAsUnicode=true;selectMethod=direct;resp
onseBuffering=adaptive;packetSize=8000;loginTimeout=15;lockTimeout=-1;lastUpdateCount=true;encrypt=false;disableStatementPooling=true;databaseName=ch33metrics;applicationName=Microsoft SQL Server JDBC Driver; (Default Schema:
dbo) …
DEBUG 7/5/11 3:52 PM:liquibase: Reading columns for sa @ jdbc:sqlserver://10.212.0.22:1433;xopenStates=false;sendTimeAsDatetime=true;trustServerCertificate=false;sendStringParametersAsUnicode=true;selectMethod=direct;response
Buffering=adaptive;packetSize=8000;loginTimeout=15;lockTimeout=-1;lastUpdateCount=true;encrypt=false;disableStatementPooling=true;databaseName=ch33metrics;applicationName=Microsoft SQL Server JDBC Driver; (Default Schema: dbo
) …
INFO 7/5/11 3:52 PM:liquibase: Reading columns for sa @ jdbc:sqlserver://10.212.0.22:1433;xopenStates=false;sendTimeAsDatetime=true;trustServerCertificate=false;sendStringParametersAsUnicode=true;selectMethod=direct;responseB
uffering=adaptive;packetSize=8000;loginTimeout=15;lockTimeout=-1;lastUpdateCount=true;encrypt=false;disableStatementPooling=true;databaseName=ch33metrics;applicationName=Microsoft SQL Server JDBC Driver; (Default Schema: dbo)
…
DEBUG 7/5/11 3:52 PM:liquibase: Could not find table or view fn_Dates for column date
Liquibase Update Failed: ‘Priority’ is not a recognized built-in function name.
SEVERE 7/5/11 3:52 PM:liquibase: ‘Priority’ is not a recognized built-in function name.
liquibase.exception.DatabaseException: com.microsoft.sqlserver.jdbc.SQLServerException: ‘Priority’ is not a recognized built-in function name.
at liquibase.snapshot.jvm.JdbcDatabaseSnapshotGenerator.createSnapshot(JdbcDatabaseSnapshotGenerator.java:251)
at liquibase.snapshot.DatabaseSnapshotGeneratorFactory.createSnapshot(DatabaseSnapshotGeneratorFactory.java:69)
at liquibase.diff.Diff.compare(Diff.java:63)
at liquibase.integration.commandline.CommandLineUtils.doGenerateChangeLog(CommandLineUtils.java:145)
at liquibase.integration.commandline.Main.doMigration(Main.java:624)
at liquibase.integration.commandline.Main.main(Main.java:116)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: ‘Priority’ is not a recognized built-in function name.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:775)
at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:676)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeQuery(SQLServerStatement.java:611)
at liquibase.snapshot.jvm.JdbcDatabaseSnapshotGenerator.isColumnAutoIncrement(JdbcDatabaseSnapshotGenerator.java:842)
at liquibase.snapshot.jvm.JdbcDatabaseSnapshotGenerator.readColumns(JdbcDatabaseSnapshotGenerator.java:369)
at liquibase.snapshot.jvm.JdbcDatabaseSnapshotGenerator.createSnapshot(JdbcDatabaseSnapshotGenerator.java:244)
… 5 more