Hi,
With Liquibase 3.0.1, generateChangeLog task failed with this error :
- liquibase.exception.UnexpectedLiquibaseException: Could not resolve MissingObjectChangeGenerator dependencies due to dependency cycle. Dependencies:
- [Column,PrimaryKey,Table] -> ForeignKey -> [Index]
- at liquibase.diff.output.changelog.DiffToChangeLog$DependencyGraph.sort(DiffToChangeLog.java:455)
- at liquibase.diff.output.changelog.DiffToChangeLog.getOrderedOutputTypes(DiffToChangeLog.java:176)
- at liquibase.diff.output.changelog.DiffToChangeLog.generateChangeSets(DiffToChangeLog.java:131)
- at liquibase.diff.output.changelog.DiffToChangeLog.print(DiffToChangeLog.java:120)
- at liquibase.diff.output.changelog.DiffToChangeLog.print(DiffToChangeLog.java:53)
- at liquibase.integration.ant.GenerateChangeLogTask.executeWithLiquibaseClassloader(GenerateChangeLogTask.java:98)
- at liquibase.integration.ant.BaseLiquibaseTask.execute(BaseLiquibaseTask.java:70)
- at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)
- at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
- at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
- at java.lang.reflect.Method.invoke(Method.java:597)
- at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
- at org.apache.tools.ant.Task.perform(Task.java:348)
- at org.apache.tools.ant.Target.execute(Target.java:392)
- at org.apache.tools.ant.Target.performTasks(Target.java:413)
- at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1399)
- at org.apache.tools.ant.Project.executeTarget(Project.java:1368)
- at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
- at org.apache.tools.ant.Project.executeTargets(Project.java:1251)
- at org.apache.tools.ant.Main.runBuild(Main.java:811)
- at org.apache.tools.ant.Main.startAnt(Main.java:217)
- at org.apache.tools.ant.launch.Launcher.run(Launcher.java:280)
- at org.apache.tools.ant.launch.Launcher.main(Launcher.java:109)
This is my code :
- <generateChangeLog
- liquibase.exception.DatabaseException: java.sql.SQLException: ORA-00936: expression abse
- at liquibase.snapshot.jvm.ColumnSnapshotGenerator.snapshotObject(ColumnSnapshotGenerator.java:58)
- at liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:56)
- at liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:42)
- at liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:75)
- at liquibase.snapshot.DatabaseSnapshot.replaceObject(DatabaseSnapshot.java:144)
- at liquibase.snapshot.DatabaseSnapshot.includeNestedObjects(DatabaseSnapshot.java:107)
- at liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:94)
- at liquibase.snapshot.DatabaseSnapshot.replaceObject(DatabaseSnapshot.java:124)
- at liquibase.snapshot.DatabaseSnapshot.includeNestedObjects(DatabaseSnapshot.java:107)
- at liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:94)
- at liquibase.snapshot.DatabaseSnapshot.replaceObject(DatabaseSnapshot.java:144)
- at liquibase.snapshot.DatabaseSnapshot.includeNestedObjects(DatabaseSnapshot.java:107)
- at liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:94)
- at liquibase.snapshot.DatabaseSnapshot.replaceObject(DatabaseSnapshot.java:124)
- at liquibase.snapshot.DatabaseSnapshot.includeNestedObjects(DatabaseSnapshot.java:107)
- at liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:94)
- at liquibase.snapshot.DatabaseSnapshot.replaceObject(DatabaseSnapshot.java:144)
- at liquibase.snapshot.DatabaseSnapshot.includeNestedObjects(DatabaseSnapshot.java:107)
- at liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:94)
- at liquibase.snapshot.DatabaseSnapshot.replaceObject(DatabaseSnapshot.java:144)
- at liquibase.snapshot.DatabaseSnapshot.replaceObject(DatabaseSnapshot.java:157)
- at liquibase.snapshot.DatabaseSnapshot.includeNestedObjects(DatabaseSnapshot.java:107)
- at liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:94)
- at liquibase.snapshot.SnapshotGeneratorFactory.createSnapshot(SnapshotGeneratorFactory.java:125)
- at liquibase.snapshot.SnapshotGeneratorFactory.createSnapshot(SnapshotGeneratorFactory.java:118)
- at liquibase.snapshot.SnapshotGeneratorFactory.createSnapshot(SnapshotGeneratorFactory.java:106)
- at liquibase.integration.ant.GenerateChangeLogTask.executeWithLiquibaseClassloader(GenerateChangeLogTask.java:90)
- at liquibase.integration.ant.BaseLiquibaseTask.execute(BaseLiquibaseTask.java:70)
- at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)
- at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
- at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
- at java.lang.reflect.Method.invoke(Method.java:597)
- at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
- at org.apache.tools.ant.Task.perform(Task.java:348)
- at org.apache.tools.ant.Target.execute(Target.java:392)
- at org.apache.tools.ant.Target.performTasks(Target.java:413)
- at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1399)
- at org.apache.tools.ant.Project.executeTarget(Project.java:1368)
- at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
- at org.apache.tools.ant.Project.executeTargets(Project.java:1251)
- at org.apache.tools.ant.Main.runBuild(Main.java:811)
- at org.apache.tools.ant.Main.startAnt(Main.java:217)
- at org.apache.tools.ant.launch.Launcher.run(Launcher.java:280)
- at org.apache.tools.ant.launch.Launcher.main(Launcher.java:109)
- Caused by: java.sql.SQLException: ORA-00936: expression absente
- at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
- at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
- at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
- at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
- at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210)
- at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:804)
- at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1049)
- at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:845)
- at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1154)
- at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1313)
- at liquibase.snapshot.jvm.ColumnSnapshotGenerator.readColumn(ColumnSnapshotGenerator.java:137)
- at liquibase.snapshot.jvm.ColumnSnapshotGenerator.snapshotObject(ColumnSnapshotGenerator.java:53)
- ... 44 more
I work great with liquibase 2.0.
Can you help me please ?
Thanks !