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

ravinderl over 10 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...

Discussion posts and replies are publicly visible

0 ravinderl over 10 years ago

Hi, I have installed MySQL 5.5 and Web logic server. Everything is working fine now.

Thx
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Priya over 10 years ago

The root error is "Caused by: java.sql.SQLException: Can't create table 'appian76.#sql-2682_2' (errno: 150)
"
Please find the error log attached.
ErrorStartingServer.log
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Eduardo Fuentes
Appian Employee
over 10 years ago

That means you're using the wrong version of SQL thus the syntax error code 150. Please make sure you install MySQL 5.5 and not 5.6
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Priya over 10 years ago

But as per the system requirements in the installation guide forum.appian.com/.../System_Requirements.html, the required version for mysql is MySQL 5.6.22 with the InnoDB default engine and for driver connector Connector/J 5.1.34 (or later). Can you kindly confirm me minimum required version for MySql and MySql connector.

Thanks
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Eduardo Fuentes
Appian Employee
over 10 years ago

I apologize for the type, it was supposed to be: Make sure you install MySQL 5.6 and the the 5.1.34 connector.

You might be running an older version of MySQL. Is this Linux or Windows?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Eduardo Fuentes
Appian Employee
over 10 years ago

I apologize for the typo, it was supposed to be: Make sure you install MySQL 5.6 and the 5.1.34 connector.

You might be running an older version of MySQL. Is this Linux or Windows?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Priya over 10 years ago

its a linux box.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Eduardo Fuentes
Appian Employee
over 10 years ago

Can you connect to MySQL from the shell and paste the output here to see what version you're running?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Eduardo Fuentes
Appian Employee
over 10 years ago

You can run

select version();

once you log in
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Priya over 10 years ago

k thanks.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel