Hi, I was trying to install Appian 7.8 on my local machine. I have 8 GB RAM

aswinb93 over 9 years ago

Hi,
I was trying to install Appian 7.8 on my local machine. I have 8 GB RAM. I am using MySQL for database and I have configured primary and business databases correctly. I tried to install in both ways- using configuration manager and without configuration manager. But both times I keep failing getting similar errors in server.log as "Empty result set....error during schema migration...". Can anybody help me on this.... I have attached the server.log file.

thanks,
Aswin

server.log

Discussion posts and replies are publicly visible

Parents

0 aswinb93 over 9 years ago

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:627) [appian-rdbms.jar:]
          ... 22 more
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:]
          ... 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:164) [liquibase-core-2.0.1.jar:]
          at liquibase.lockservice.LockService.acquireLock(LockService.java:96) [liquibase-core-2.0.1.jar:]
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 aswinb93 over 9 years ago

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:627) [appian-rdbms.jar:]
          ... 22 more
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:]
          ... 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:164) [liquibase-core-2.0.1.jar:]
          at liquibase.lockservice.LockService.acquireLock(LockService.java:96) [liquibase-core-2.0.1.jar:]
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data