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

Hello. I am getting an odd error during the initial startup. I'm in a JBOSS

johnj415
Hello. I am getting an odd error during the initial startup. I'm in a JBOSS EAP-6.4.0 environment on RHEL 7. It looks like the startup routine is expecting something in the database but it is empty as it's the initial startup. I did not see any kind of sql scripts to create a db so not sure what it is expecting there. Exception stack is below. Any help would be greatly appreciated. Thanks!

04:33:33,918 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[default-host].[/suite]] (ServerService Thread Pool -- 71) 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 Appian data source. (APNX-1-4179-004)
at com.appiancorp.suiteapi.common.exceptions.AppianR...

OriginalPostID-204038

OriginalPostID-204038

  Discussion posts and replies are publicly visible

  • 0
    ...untimeException.<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:33) [appian-rdbms.jar:]
    at com.appiancorp.common.config.ConfigObject.init(ConfigObject.java:72) [appian-common.jar:]
    at com.appiancorp.common.config.ConfigObjectRepository.initConfigObject(ConfigObjectRepository.java:376) [appian-common.jar:]
    at com.appiancorp.common.config.ConfigObjectRepository.initConfigObject(ConfigObjectRepository.java:267) [appian-common.jar:]
    at com.appiancorp.common.config.ConfigObjectRepository.init(ConfigObjectRepository.java:227) [appian-common.jar:]
    at com.appiancorp.common.config.ConfigObjectRepository.create(ConfigObjectRepository.java:95) [appian-common.jar:]
    at com.appiancorp.common...
  • 0
    ....config.ConfigObjectRepository.create(ConfigObjectRepository.java:89) [appian-common.jar:]
    at com.appiancorp.common.config.ConfigurationLoader$1.run(ConfigurationLoader.java:64) [appian-common.jar:]
    at com.appiancorp.security.changelog.AuditLogLocationService.runWithLocation(AuditLogLocationService.java:40) [appian-security.jar:]
    at com.appiancorp.common.config.ConfigurationLoader.contextInitialized(ConfigurationLoader.java:60) [appian-common.jar:]
    at org.apache.catalina.core.StandardContext.contextListenerStart(StandardContext.java:3339) [jbossweb-7.5.7.Final-redhat-1.jar:7.5.7.Final-redhat-1]
    at org.apache.catalina.core.StandardContext.start(StandardContext.java:3780) [jbossweb-7.5.7.Final-redhat-1.jar:7.5.7.Final-redhat-1]
    at org.jboss.as.web.deployment.WebDeploymentService.doStart(WebDeploymentService.java:163) [jboss-as-web-7.5.0.Final-redhat-21.jar:7.5.0.Final-redhat-21]
    at org.jboss.as.web.deployment.Web...
  • 0
    ... DeploymentService.access$000(WebDeploymentService.java:61) [jboss-as-web-7.5.0.Final-redhat-21.jar:7.5.0.Final-redhat-21]
    at org.jboss.as.web.deployment.WebDeploymentService$1.run(WebDeploymentService.java:96) [jboss-as-web-7.5.0.Final-redhat-21.jar:7.5.0.Final-redhat-21]
    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [rt.jar:1.8.0_77]
    at java.util.concurrent.FutureTask.run(Unknown Source) [rt.jar:1.8.0_77]
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [rt.jar:1.8.0_77]
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [rt.jar:1.8.0_77]
    at java.lang.Thread.run(Unknown Source) [rt.jar:1.8.0_77]
    at org.jboss.threads.JBossThread.run(JBossThread.java:122)
    Caused by: java.lang.IllegalStateException: [java:/jdbc/AppianPrimaryDS] Error during schema migration.
    at com.appiancorp.rdbms.hb.DataSourceManagerHbImpl.ensureSchema(DataSourceManagerHbI...
  • 0
    ... mpl.java:712) [appian-rdbms.jar:]
    at com.appiancorp.rdbms.hb.DataSourceManagerHbImpl.getEntityManagerFactory(DataSourceManagerHbImpl.java:681) [appian-rdbms.jar:]
    at com.appiancorp.rdbms.hb.DataSourceManagerHbImpl.getSessionFactory(DataSourceManagerHbImpl.java:673) [appian-rdbms.jar:]
    at com.appiancorp.rdbms.hb.DataSourceManagerHbImpl.initialize(DataSourceManagerHbImpl.java:490) [appian-rdbms.jar:]
    at com.appiancorp.rdbms.config.PrimaryDataSourceConfig.finish(PrimaryDataSourceConfig.java:24) [appian-rdbms.jar:]
    ... 20 more
    Caused by: java.lang.IllegalStateException: liquibase.exception.LockException: liquibase.exception.DatabaseException: Empty result set, expected one row
    at com.appiancorp.rdbms.common.schema.SchemaMigrator.migrate(SchemaMigrator.java:145) [appian-rdbms.jar:]
    at com.appiancorp.rdbms.hb.DataSourceManagerHbImpl.ensureSchema(DataSourceManagerHbImpl.java:707) [appian-rdbms.jar:]
    ... 24 m...
  • 0
    ... ore
    Caused by: liquibase.exception.LockException: liquibase.exception.DatabaseException: Empty result set, expected one row
    at liquibase.lockservice.LockService.acquireLock(LockService.java:121) [liquibase-core-2.0.1.jar:]
    at liquibase.lockservice.LockService.waitForLock(LockService.java:61) [liquibase-core-2.0.1.jar:]
    at liquibase.Liquibase.update(Liquibase.java:101) [liquibase-core-2.0.1.jar:]
    at com.appiancorp.rdbms.common.schema.SchemaMigrator.migrate(SchemaMigrator.java:143) [appian-rdbms.jar:]
    ... 25 more
    Caused by: liquibase.exception.DatabaseException: Empty result set, expected one row
    at liquibase.util.JdbcUtils.requiredSingleResult(JdbcUtils.java:124) [liquibase-core-2.0.1.jar:]
    at liquibase.executor.jvm.JdbcExecutor.queryForObject(JdbcExecutor.java:160) [liquibase-core-2.0.1.jar:]
    at liquibase.executor.jvm.JdbcExecutor.queryForObject(JdbcExecutor.java:168) [liquibase-core-2.0.1.jar:]
    ...
  • 0
    ... at liquibase.executor.jvm.JdbcExecutor.queryForObject(JdbcExecutor.java:164) [liquibase-core-2.0.1.jar:]
    at liquibase.lockservice.LockService.acquireLock(LockService.java:96) [liquibase-core-2.0.1.jar:]
    ... 28 more
  • 0
    Ensure you are using the correct primary database for your environment.
    Then take a look at this knowledge base article:
    forum.appian.com/.../kb-1024.html
    where you are encountering a similar issue but instead of a lock value, it is not getting any values. Go to the table mentioned in the KB article and ensure that there is a databasechangeloglock table and necessary record within.
  • 0
    That seems to have worked...or at least got me to the next set of errors. Thanks so much for the quick response.
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.