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
3 replies
Subscribers
7 subscribers
Views
1597 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
I have installed Appian 7.6 on my 64 windows 7 laptop with mysql 5.6.20 an
foussenik
over 10 years ago
I have installed Appian 7.6 on my 64 windows 7 laptop with mysql 5.6.20 and connector mysql-connector-java-5.1.32-bin.jar.
The tables have created, however I am getting following error:
Error: Error executing SQL ALTER TABLE `rm_entry_groups` ADD PRIMARY KEY (`rm_entry_id`, `group_id`): Incorrect index name 'PRIMARY...
OriginalPostID-123555
OriginalPostID-123555
Discussion posts and replies are publicly visible
Parents
0
foussenik
over 10 years ago
Eduardo,
Here is complete error log.
14:37:15,466 INFO [stdout] (ServerService Thread Pool -- 88) at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
14:37:15,466 INFO [stdout] (ServerService Thread Pool -- 88) at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:147)
14:37:15,468 INFO [stdout] (ServerService Thread Pool -- 88) ... 64 more
14:37:15,468 INFO [stdout] (ServerService Thread Pool -- 88) Caused by: java.lang.IllegalStateException: [java:/jdbc/AppianPrimaryDS] Error during schema migration.
14:37:15,469 INFO [stdout] (ServerService Thread Pool -- 88) at com.appiancorp.rdbms.hb.DataSourceManagerHbImpl.ensureSchema(DataSourceManagerHbImpl.java:612)
14:37:15,470 INFO [stdout] (ServerService Thread Pool -- 88) at com.appiancorp.rdbms.hb.DataSourceManagerHbImpl.getEntityManagerFactory(DataSourceManagerHbImpl.jav
a:585)
14:37:15,471 INFO [stdout] (ServerService Thread Pool -- 88) at com.appiancorp.common.config.AppianPersistenceSpringConfig$EntityManagerFactoryWrapper.getDelegate(
AppianPersistenceSpringConfig.java:176)
14:37:15,472 INFO [stdout] (ServerService Thread Pool -- 88) at com.appiancorp.common.config.AppianPersistenceSpringConfig$EntityManagerFactoryWrapper.createEntity
Manager(AppianPersistenceSpringConfig.java:180)
14:37:15,473 INFO [stdout] (ServerService Thread Pool -- 88) at org.springframework.orm.jpa.JpaTransactionManager.createEntityManagerForTransaction(JpaTransactionM
anager.java:445)
14:37:15,475 INFO [stdout] (ServerService Thread Pool -- 88) at org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransactionManager.java:366)
14:37:15,476 INFO [stdout] (ServerService Thread Pool -- 88) ... 90 more
14:37:15,478 INFO [stdout] (ServerService Thread Pool -- 88) Caused by: java.lang.IllegalStateException: liquibase.exception.MigrationFailedException: Migration fail
ed for change set db-changelog-000009.xml::000009.3.11::appian:
14:37:15,479 INFO [stdout] (ServerService Thread Pool -- 88) Reason: liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE `rm_entry_groups` AD
D PRIMARY KEY (`rm_entry_id`, `group_id`): Incorrect index name 'PRIMARY':
14:37:15,479 INFO [stdout] (ServerService Thread Pool -- 88) Caused By: Error executing SQL ALTER TABLE `rm_entry_groups` ADD PRIMARY KEY (`rm_entry_id`, `
group_id`): Incorrect index name 'PRIMARY':
14:37:15,481 INFO [stdout] (ServerService Thread Pool -- 88) Caused By: Incorrect index name 'PRIMARY'
14:37:15,482 INFO [stdout] (ServerService Thread Pool -- 88) at com.appiancorp.rdbms.common.schema.SchemaMigrator.migrate(SchemaMigrator.java:145)
14:37:15,484 INFO [stdout] (ServerService Thread Pool -- 88) at com.appiancorp.rdbms.hb.DataSourceManagerHbImpl.ensureSchema(DataSourceManagerHbImpl.java:609)
14:37:15,484 INFO [stdout] (ServerService Thread Pool -- 88) ... 95 more
14:37:15,485 INFO [stdout] (ServerService Thread Pool -- 88) Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set db-changelog-00
0009.xml::000009.3.11::appian:
14:37:15,486 INFO [stdout] (ServerService Thread Pool -- 88) Reason: liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE `rm_entry_groups` AD
D PRIMARY KEY (`rm_entry_id`, `group_id`): Incorrect index name 'PRIMARY':
14:37:15,487 INFO [stdout] (ServerService Thread Pool -- 88) Caused By: Error executing SQL ALTER TABLE `rm_entry_groups` ADD PRIMARY KEY (`rm_entry_id`, `
group_id`): Incorrect index name 'PRIMARY':
14:37:15,488 INFO [stdout] (ServerService Thread Pool -- 88) Caused By: Incorrect index name 'PRIMARY'
14:37:15,490 INFO [stdout] (ServerService Thread Pool -- 88) at liquibase.changelog.ChangeSet.execute(ChangeSet.java:347)
14:37:15,491 INFO [stdout] (ServerService Thread Pool -- 88) at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27)
14:37:15,492 INFO [stdout] (ServerService Thread Pool -- 8
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
foussenik
over 10 years ago
Eduardo,
Here is complete error log.
14:37:15,466 INFO [stdout] (ServerService Thread Pool -- 88) at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
14:37:15,466 INFO [stdout] (ServerService Thread Pool -- 88) at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:147)
14:37:15,468 INFO [stdout] (ServerService Thread Pool -- 88) ... 64 more
14:37:15,468 INFO [stdout] (ServerService Thread Pool -- 88) Caused by: java.lang.IllegalStateException: [java:/jdbc/AppianPrimaryDS] Error during schema migration.
14:37:15,469 INFO [stdout] (ServerService Thread Pool -- 88) at com.appiancorp.rdbms.hb.DataSourceManagerHbImpl.ensureSchema(DataSourceManagerHbImpl.java:612)
14:37:15,470 INFO [stdout] (ServerService Thread Pool -- 88) at com.appiancorp.rdbms.hb.DataSourceManagerHbImpl.getEntityManagerFactory(DataSourceManagerHbImpl.jav
a:585)
14:37:15,471 INFO [stdout] (ServerService Thread Pool -- 88) at com.appiancorp.common.config.AppianPersistenceSpringConfig$EntityManagerFactoryWrapper.getDelegate(
AppianPersistenceSpringConfig.java:176)
14:37:15,472 INFO [stdout] (ServerService Thread Pool -- 88) at com.appiancorp.common.config.AppianPersistenceSpringConfig$EntityManagerFactoryWrapper.createEntity
Manager(AppianPersistenceSpringConfig.java:180)
14:37:15,473 INFO [stdout] (ServerService Thread Pool -- 88) at org.springframework.orm.jpa.JpaTransactionManager.createEntityManagerForTransaction(JpaTransactionM
anager.java:445)
14:37:15,475 INFO [stdout] (ServerService Thread Pool -- 88) at org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransactionManager.java:366)
14:37:15,476 INFO [stdout] (ServerService Thread Pool -- 88) ... 90 more
14:37:15,478 INFO [stdout] (ServerService Thread Pool -- 88) Caused by: java.lang.IllegalStateException: liquibase.exception.MigrationFailedException: Migration fail
ed for change set db-changelog-000009.xml::000009.3.11::appian:
14:37:15,479 INFO [stdout] (ServerService Thread Pool -- 88) Reason: liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE `rm_entry_groups` AD
D PRIMARY KEY (`rm_entry_id`, `group_id`): Incorrect index name 'PRIMARY':
14:37:15,479 INFO [stdout] (ServerService Thread Pool -- 88) Caused By: Error executing SQL ALTER TABLE `rm_entry_groups` ADD PRIMARY KEY (`rm_entry_id`, `
group_id`): Incorrect index name 'PRIMARY':
14:37:15,481 INFO [stdout] (ServerService Thread Pool -- 88) Caused By: Incorrect index name 'PRIMARY'
14:37:15,482 INFO [stdout] (ServerService Thread Pool -- 88) at com.appiancorp.rdbms.common.schema.SchemaMigrator.migrate(SchemaMigrator.java:145)
14:37:15,484 INFO [stdout] (ServerService Thread Pool -- 88) at com.appiancorp.rdbms.hb.DataSourceManagerHbImpl.ensureSchema(DataSourceManagerHbImpl.java:609)
14:37:15,484 INFO [stdout] (ServerService Thread Pool -- 88) ... 95 more
14:37:15,485 INFO [stdout] (ServerService Thread Pool -- 88) Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set db-changelog-00
0009.xml::000009.3.11::appian:
14:37:15,486 INFO [stdout] (ServerService Thread Pool -- 88) Reason: liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE `rm_entry_groups` AD
D PRIMARY KEY (`rm_entry_id`, `group_id`): Incorrect index name 'PRIMARY':
14:37:15,487 INFO [stdout] (ServerService Thread Pool -- 88) Caused By: Error executing SQL ALTER TABLE `rm_entry_groups` ADD PRIMARY KEY (`rm_entry_id`, `
group_id`): Incorrect index name 'PRIMARY':
14:37:15,488 INFO [stdout] (ServerService Thread Pool -- 88) Caused By: Incorrect index name 'PRIMARY'
14:37:15,490 INFO [stdout] (ServerService Thread Pool -- 88) at liquibase.changelog.ChangeSet.execute(ChangeSet.java:347)
14:37:15,491 INFO [stdout] (ServerService Thread Pool -- 88) at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27)
14:37:15,492 INFO [stdout] (ServerService Thread Pool -- 8
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data