Hi, I am trying to install 7.7 in to my windows machine.When I run st

RajHasti over 9 years ago

Hi,

I am trying to install 7.7 in to my windows machine.When I run standalone.bat in C:\\appian\\bin\\jboss\\jboss-eap-6.3\\bin..following error are coming ...Attached is the server.log

16:20:33,095 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[default-host].[/suite]] (ServerService Thread Pool -- 77) 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:]

Caused by: java.lang.IllegalStateException: [jdbc/AppianPrimaryDS] Error during schema migration.
at com.appiancorp.rdbms.hb.DataSource...

server.log

Discussion posts and replies are publicly visible

0 RajHasti over 9 years ago

...ManagerHbImpl.ensureSchema(DataSourceManagerHbImpl.java:612) [appian-rdbms.jar:]
          at com.appiancorp.rdbms.hb.DataSourceManagerHbImpl.getEntityManagerFactory(DataSourceManagerHbImpl.java:585) [appian-rdbms.jar:]
          at com.appiancorp.rdbms.hb.DataSourceManagerHbImpl.getSessionFactory(DataSourceManagerHbImpl.java:577) [appian-rdbms.jar:]
          at com.appiancorp.rdbms.hb.DataSourceManagerHbImpl.initialize(DataSourceManagerHbImpl.java:413) [appian-rdbms.jar:]
          at com.appiancorp.rdbms.config.PrimaryDataSourceConfig.finish(PrimaryDataSourceConfig.java:22) [appian-rdbms.jar:]
          ... 18 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:609) [appian-rdbms.jar:]
          ... 22 more
Caused ...
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 RajHasti over 9 years ago

...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:]
          ... 23 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:]
          at liquibase.executor.jvm.JdbcExecutor.queryForObject(JdbcExecutor.java:1...
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 RajHasti over 9 years ago

... 64) [liquibase-core-2.0.1.jar:]
at liquibase.lockservice.LockService.acquireLock(LockService.java:96) [liquibase-core-2.0.1.jar:]
... 26 more
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 RajHasti over 9 years ago

some more information on the error

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:]
          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:]
          ... 41 more
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Eduardo Fuentes
Appian Employee
over 9 years ago

Since this is a completely new install I suggest you delete the Primary Data Source and create a new empty one, then start the app server again.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Eduardo Fuentes
Appian Employee
over 9 years ago

This has to be done after re-installing Appian.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 RajHasti over 9 years ago

Thanks for the reply Eduardo...But no luck..its giving the same set of errors.,,

I created a datasoure in admin console with below attributes and restarted

Name -AppianPrimaryDS
JNDI NAME -java:jboss/datasources/AppianPrimaryDS
Driver - h2
Connection URL - jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=FALSE
security User Name - sa,
password - sa
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Eduardo Fuentes
Appian Employee
over 9 years ago

The only supported RDBMs are the ones listed here forum.appian.com/.../System_Requirements.html

The JBoss database is not a supported one.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 RajHasti over 9 years ago

Thanks Eduardo.I removed all set up and installed again everything.Its started working.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel