I am trying to install the Appian 8.0. As a part of this installation I have in

ramakg

A Score Level 1

over 9 years ago

I am trying to install the Appian 8.0. As a part of this installation I have installed Jboss EAP 6.3 and MySQL 5.6. when I start the jboss I am getting the below error message. Any inputs on this?

JBWEB000287: Exception sending context initialized event to listener instance of class com.appiancorp.common.config.ConfigurationLoader: com.appiancorp.common.config.FatalConfigurationException: com.appiancorp.suiteapi.common.exceptions.AppianException: An unexpected error occurred while trying to initialize and validate the primary data source. (APNX-1-4179-004)
          at com.appiancorp.suiteapi.common.exceptions.AppianRuntimeException.<init>(AppianRuntimeException.java:52) [appian-suiteapi.jar:]
          at com.appiancorp.common.config.FatalConfigurationException.<init>(FatalConfigurationException.java:23) [appian-common.jar:]
          at com.appiancorp.rdbms.config.PrimaryDataSourceConfig.finish(PrimaryDataSourceConfig.java:29) [appian-rdbms.jar:]
          at com.app...

Discussion posts and replies are publicly visible

Parents

0 Tejas Kargutkar
Appian Employee
over 9 years ago

You would need to focus on this particular error:
02:59:12,328 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[default-host].[/suite]] (ServerService Thread Pool -- 62) JBWEB000287: Exception sending context initialized event to listener instance of class com.appiancorp.common.config.ConfigurationLoader: com.appiancorp.common.config.FatalConfigurationException: com.appiancorp.suiteapi.common.exceptions.AppianException: An unexpected error occurred while trying to initialize and validate the primary data source. (APNX-1-4179-004)
.
.
Caused by: java.lang.IllegalStateException: [java:/jdbc/Appian_primaryDS1] Error during schema migration.
.
.
Caused by: java.lang.IllegalStateException: liquibase.exception.LockException: liquibase.exception.DatabaseException: Empty result set, expected one row
.
.
Caused by: liquibase.exception.LockException: liquibase.exception.DatabaseException: Empty result set, expected one row

Do you know if the "Appian_primaryDS1" schema was manually modified was someone OR a row was deleted from the existing schema ?

Appian is expecting a row in this schema which is missing and that's why it's throwing the error we are seeing in the log.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Tejas Kargutkar
Appian Employee
over 9 years ago

You would need to focus on this particular error:
02:59:12,328 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[default-host].[/suite]] (ServerService Thread Pool -- 62) JBWEB000287: Exception sending context initialized event to listener instance of class com.appiancorp.common.config.ConfigurationLoader: com.appiancorp.common.config.FatalConfigurationException: com.appiancorp.suiteapi.common.exceptions.AppianException: An unexpected error occurred while trying to initialize and validate the primary data source. (APNX-1-4179-004)
.
.
Caused by: java.lang.IllegalStateException: [java:/jdbc/Appian_primaryDS1] Error during schema migration.
.
.
Caused by: java.lang.IllegalStateException: liquibase.exception.LockException: liquibase.exception.DatabaseException: Empty result set, expected one row
.
.
Caused by: liquibase.exception.LockException: liquibase.exception.DatabaseException: Empty result set, expected one row

Do you know if the "Appian_primaryDS1" schema was manually modified was someone OR a row was deleted from the existing schema ?

Appian is expecting a row in this schema which is missing and that's why it's throwing the error we are seeing in the log.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data