liquibase.exception.MigrationFailedException: Migration failed for change set releases/1614/atg/dynct1/drop_view_v_a.xml::1614::venkatrama.kamaraj: Reason: src/main/resources/changeLog.xml : liquibase.precondition.core.ViewExistsPrecondition@59d4cd39 : Empty result set, expected one row

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via JIRA by Bhvani Prasad Atluri, 1 year ago
Migration failed for change set releases/1614/atg/dynct1/drop_view_v_a.xml::1614::venkatrama.kamaraj: Reason: src/main/resources/changeLog.xml : liquibase.precondition.core.ViewExistsPrecondition@59d4cd39 : Empty result set, expected one row
via JIRA by Bhvani Prasad Atluri, 1 year ago
Migration failed for change set releases/1614/atg/dynct1/drop_view_v_a.xml::1614::venkatrama.kamaraj: Reason: src/main/resources/changeLog.xml : liquibase.precondition.core.ViewExistsPrecondition@59d4cd39 : Empty result set, expected one row
via JIRA by Nathan Voxland, 1 year ago
Migration failed for change set latest/vw/departments_vw.xml::1::jsmith: Reason: update.xml : Error getting jdbc:hsqldb:hsql://localhost/testdb view with liquibase.statement.core.GetViewDefinitionStatement@a00185 : Caused By: Precondition Error
via JIRA by Nathan Voxland, 1 year ago
Migration failed for change set latest/vw/departments_vw.xml::1::jsmith: Reason: update.xml : Error getting jdbc:hsqldb:hsql://localhost/testdb view with liquibase.statement.core.GetViewDefinitionStatement@a00185 : Caused By: Precondition Error
via liquibase.org by Unknown author, 1 year ago
Migration failed for change set latest/vw/departments_vw.xml::1::jsmith:     Reason:          update.xml : Error getting jdbc:hsqldb:hsql://localhost/testdb view with liquibase.statement.core.GetViewDefinitionStatement@a00185 :          Caused By: Precondition Error
via JIRA by Dzmitry Kazimirchyk, 1 year ago
Migration failed for change set resources/liquibase/initialSchema/schema.xml::createIndex::dzmitry: Reason: resources/liquibase/liquibase.db.changelog.xml : Index Exists Precondition: Transaction_recordId : Comparisons between 'VARCHAR (UCS_BASIC
liquibase.exception.MigrationFailedException: Migration failed for change set releases/1614/atg/dynct1/drop_view_v_a.xml::1614::venkatrama.kamaraj: Reason: src/main/resources/changeLog.xml : liquibase.precondition.core.ViewExistsPrecondition@59d4cd39 : Empty result set, expected one row
at liquibase.util.JdbcUtils.requiredSingleResult(JdbcUtils.java:141)
at liquibase.executor.jvm.JdbcExecutor.queryForObject(JdbcExecutor.java:138)
at liquibase.executor.jvm.JdbcExecutor.queryForObject(JdbcExecutor.java:151)
at liquibase.executor.jvm.JdbcExecutor.queryForObject(JdbcExecutor.java:146)
at liquibase.database.AbstractJdbcDatabase.getViewDefinition(AbstractJdbcDatabase.java:867)
at liquibase.snapshot.jvm.ViewSnapshotGenerator.snapshotObject(ViewSnapshotGenerator.java:75)
at liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:60)
at liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:50)
at liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:63)
at liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:50)
at liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:194)
at liquibase.snapshot.DatabaseSnapshot.init(DatabaseSnapshot.java:70)
at liquibase.snapshot.DatabaseSnapshot.(DatabaseSnapshot.java:44)
at liquibase.snapshot.JdbcDatabaseSnapshot.(JdbcDatabaseSnapshot.java:21)
at liquibase.snapshot.SnapshotGeneratorFactory.createSnapshot(SnapshotGeneratorFactory.java:150)
at liquibase.snapshot.SnapshotGeneratorFactory.createSnapshot(SnapshotGeneratorFactory.java:158)
at liquibase.snapshot.SnapshotGeneratorFactory.has(SnapshotGeneratorFactory.java:108)
at liquibase.precondition.core.ViewExistsPrecondition.check(ViewExistsPrecondition.java:60)
at liquibase.precondition.core.AndPrecondition.check(AndPrecondition.java:43)
at liquibase.precondition.core.PreconditionContainer.check(PreconditionContainer.java:202)
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:470)
at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:51)
at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:73)
at liquibase.Liquibase.update(Liquibase.java:212)
at liquibase.Liquibase.update(Liquibase.java:192)
at liquibase.Liquibase.update(Liquibase.java:327)
at liquibase.Liquibase.updateTestingRollback(Liquibase.java:1069)
at liquibase.Liquibase.updateTestingRollback(Liquibase.java:1061)
at liquibase.integration.commandline.Main.doMigration(Main.java:1167)
at liquibase.integration.commandline.Main.run(Main.java:180)

Users with the same issue

You are the first who have seen this exception. Write a tip to help other users and build your expert profile.

Know the solutions? Share your knowledge to help other developers to debug faster.