• State Not Answered
  • Replies 25 replies
  • Subscribers 9 subscribers
  • Views 5659 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Administration

Hi, I have installed Appian 7.9 and JBoss. During Jboss server start up I am get

ravinderl
Hi, I have installed Appian 7.9 and JBoss. During Jboss server start up I am getting below errors. Could anyone tell me what action need to be taken to resolve this issue?

Caused by: java.lang.IllegalStateException: liquibase.exception.MigrationFailedException: Migration failed for change set db-changelog-000005.xml::000005.1.0::appian:
Reason: liquibase.exception.DatabaseException: Error executing SQL UPDATE `DATABASECHANGELOG` SET `TAG` = '6.6.1.0' WHERE DATEEXECUTED = (SELECT MAX(DATEEXECUTED) FROM (SELECT DATEEXECUTED FROM `DATABASECHANGELOG`) AS X): You can't specify target table 'DATABASECHANGELOG' for update in FROM clause:
Caused By: Error executing SQL UPDATE `DATABASECHANGELOG` SET `TAG` = '6.6.1.0' WHERE DATEEXECUTED = (SELECT MAX(DATEEXECUTED) FROM (SELECT DATEEXECUTED FROM `DATABASECHANGELOG`) AS X): You can't specify target table 'DATABASECHANGELOG' for update in FROM clause:
Caused By: You can't...

OriginalPostID-152223

OriginalPostID-152223

  Discussion posts and replies are publicly visible

Parents
  • 0
    ... in FROM clause
    at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62) [liquibase-core-2.0.1.jar:]
    at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:105) [liquibase-core-2.0.1.jar:]
    at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1014) [liquibase-core-2.0.1.jar:]
    at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:998) [liquibase-core-2.0.1.jar:]
    at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317) [liquibase-core-2.0.1.jar:]
    ... 43 more
    Caused by: java.sql.SQLException: You can't specify target table 'DATABASECHANGELOG' for update in FROM clause
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1086) [mysql-connector-java-5.1.28-bin.jar:]

    Thx
Reply
  • 0
    ... in FROM clause
    at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62) [liquibase-core-2.0.1.jar:]
    at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:105) [liquibase-core-2.0.1.jar:]
    at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1014) [liquibase-core-2.0.1.jar:]
    at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:998) [liquibase-core-2.0.1.jar:]
    at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317) [liquibase-core-2.0.1.jar:]
    ... 43 more
    Caused by: java.sql.SQLException: You can't specify target table 'DATABASECHANGELOG' for update in FROM clause
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1086) [mysql-connector-java-5.1.28-bin.jar:]

    Thx
Children
No Data
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.