Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
25 replies
Subscribers
8 subscribers
Views
5809 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Administration
Hi, I have installed Appian 7.9 and JBoss. During Jboss server start up I am get
ravinderl
over 9 years ago
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
0
ravinderl
over 9 years ago
... specify target table 'DATABASECHANGELOG' for update in FROM clause
at com.appiancorp.rdbms.common.schema.SchemaMigrator.migrate(SchemaMigrator.java:145) [appian-rdbms.jar:]
at com.appiancorp.rdbms.hb.DataSourceManagerHbImpl.ensureSchema(DataSourceManagerHbImpl.java:648) [appian-rdbms.jar:]
... 38 more
Caused by: 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...
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
ravinderl
over 9 years ago
... target table 'DATABASECHANGELOG' for update in FROM clause:
Caused By: You can't specify target table 'DATABASECHANGELOG' for update in FROM clause
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:347) [liquibase-core-2.0.1.jar:]
at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27) [liquibase-core-2.0.1.jar:]
at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58) [liquibase-core-2.0.1.jar:]
at liquibase.Liquibase.update(Liquibase.java:113) [liquibase-core-2.0.1.jar:]
at com.appiancorp.rdbms.common.schema.SchemaMigrator.migrate(SchemaMigrator.java:143) [appian-rdbms.jar:]
... 39 more
Caused by: 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...
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
ravinderl
over 9 years ago
... 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
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Eduardo Fuentes
Appian Employee
over 9 years ago
What version of MySQL are you using?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
ravinderl
over 9 years ago
I am using MySQL 5.7 version.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
ravinderl
over 9 years ago
databasechangeloglock table populated with below row.
SELECT * FROM appian_primary.databasechangeloglock;
ID, LOCKED, LOCKGRANTED, LOCKEDBY
1 0 NULL NULL
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
ravinderl
over 9 years ago
Hello Eduardo, Is this issue with MySQL? Could you please confirm what version of MySQL is compatible with Appian 7.9?
Appreciate your reply !!
Thx
Ravi
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Eduardo Fuentes
Appian Employee
over 9 years ago
5.6 is the supported version. I'm thinking that's why you get the syntax error.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Priya
over 9 years ago
Hi, I am facing similar issue. when i am trying to upgrade from 7.6 to 7.9. Can you kindly let me know if the issue is resolved for you. If so can you let me know how you resolved it
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Eduardo Fuentes
Appian Employee
over 9 years ago
What is the "Caused by" telling you in your specific case? These errors might all look similar but they are not if you carefully review each "Caused by" in the first error in the log.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
>