Hi,
When i just run Liquibase 3.5.3 with command
liquibase.bat --defaultsFile=DB_DIFF.properties diffChangeLog
The File DB_DIFF.properties content:
driver: com.microsoft.sqlserver.jdbc.SQLServerDriver
classpath: C:\Program Files\Microsoft JDBC Driver 6.0 for SQL Server\sqljdbc_6.0\enu\jre8\sqljdbc42.jar
url: jdbc:sqlserver://DBSERVER1:1433;databaseName=DATABASE01;integratedSecurity=false;
username: sa
password: xxxxxx
referenceUrl: jdbc:sqlserver://DBSERVER02:1433;databaseName=DATABASE02;integratedSecurity=false;
referenceUsername: sa
referencePassword: xxxxxx
changeLogFile: C:\Liquibase\DiffChangeLogFile.xml
I get the Exception:
Unexpected error running Liquibase: java.lang.ClassCastException: liquibase.statement.DatabaseFunction cannot be cast to java.lang.Integer
With LogLevel Activated:
liquibase: java.lang.ClassCastException: liquibase.statement.DatabaseFunction cannot be cast to java.lang.Integer
liquibase.exception.LiquibaseException: liquibase.command.CommandExecutionException: java.lang.ClassCastException: liquibase.statement.DatabaseFunction cannot be cast to java.lang.Integer
at liquibase.integration.commandline.CommandLineUtils.doDiffToChangeLog(CommandLineUtils.java:233)
at liquibase.integration.commandline.Main.doMigration(Main.java:996)
at liquibase.integration.commandline.Main.run(Main.java:188)
at liquibase.integration.commandline.Main.main(Main.java:103)
Caused by: liquibase.command.CommandExecutionException: java.lang.ClassCastException: liquibase.statement.DatabaseFunction cannot be cast to java.lang.Integer
at liquibase.command.AbstractCommand.execute(AbstractCommand.java:13)
at liquibase.integration.commandline.CommandLineUtils.doDiffToChangeLog(CommandLineUtils.java:231)
… 3 more
Caused by: java.lang.ClassCastException: liquibase.statement.DatabaseFunction cannot be cast to java.lang.Integer
at java.lang.Integer.compareTo(Unknown Source)
at liquibase.diff.ObjectDifferences$StandardCompareFunction.areEqual(ObjectDifferences.java:133)
at liquibase.diff.ObjectDifferences.compare(ObjectDifferences.java:69)
at liquibase.diff.ObjectDifferences.compare(ObjectDifferences.java:50)
at liquibase.diff.compare.core.DefaultDatabaseObjectComparator.findDifferences(DefaultDatabaseObjectComparator.java:85)
at liquibase.diff.compare.DatabaseObjectComparatorChain.findDifferences(DatabaseObjectComparatorChain.java:98)
at liquibase.diff.compare.core.ColumnComparator.findDifferences(ColumnComparator.java:68)
at liquibase.diff.compare.DatabaseObjectComparatorChain.findDifferences(DatabaseObjectComparatorChain.java:98)
at liquibase.diff.compare.DatabaseObjectComparatorFactory.findDifferences(DatabaseObjectComparatorFactory.java:171)
at liquibase.diff.core.StandardDiffGenerator.compareObjectType(StandardDiffGenerator.java:96)
at liquibase.diff.core.StandardDiffGenerator.compare(StandardDiffGenerator.java:52)
at liquibase.diff.DiffGeneratorFactory.compare(DiffGeneratorFactory.java:100)
at liquibase.command.DiffCommand.createDiffResult(DiffCommand.java:149)
at liquibase.command.DiffToChangeLogCommand.run(DiffToChangeLogCommand.java:51)
at liquibase.command.AbstractCommand.execute(AbstractCommand.java:8)
… 4 more
noticed that the error occurs after running a query on [sys]. [Extended_properties]
SELECT CAST([ep].[value] AS nvarchar) AS [REMARKS]
FROM [sys].[extended_properties] AS [ep]
WHERE [ep].[class] = 1
AND [ep].[major_id] = OBJECT_ID(N’[dbo].[View]’)
AND [ep].[minor_id] = COLUMNPROPERTY([ep].[major_id], N’Column’, ‘ColumnId’)
AND [ep].[name] = ‘MS_Description’
Thanks a lot for the help