We hope you'll join us for our 4/23 webinar on using data tables to apply reference ranges and AE codes in OC4. For more information and to register, visit https://register.gotowebinar.com/register/2882170018956684555

Installation issue

Hello everybody,

After two days trying to install OC I ran out of ideas where the problem can be.

OS: Centos 6.9, apache tomcat: 7.0.52, jdk-7u51-linux-x64, OpenClinica 3.13.
OC application is on one server, PostgreSQL on separate machine.

I went through all linux installation steps. In tomcat manager all default apps work fine, but OC running status is FAULSE.
There is connection to database, as after starting OC application the first time, database was filled with tables.

But still OpenClinica application doesn't work. And below are some questions:

1. tomcat/webapp/OpenClinica/openclinica.config/datainfo.properties was not created by default ( is this proper location? )
2. I tried with tomcat/webapp/openclinica.config/datainfo.properties as it is not clearly described if and where exactly this file should be located
3. same with tomcat/webapp/ [ OpenClinica ] /openclinica.data created manually, as was not created by default

Trying to start OC in tomcat manager shows the error: FAIL - Application at context path /OpenClinica could not be started


And some logs from catalina.out:


Nov 18, 2017 10:54:15 PM org.apache.catalina.core.StandardContext listenerStart
SEVERE: Exception sending context initialized event to listener instance of class org.akaza.openclinica.control.OCServletContextListener
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in class path resource [org/akaza/openclinica/applicationContext-core-db.xml]: Invocation of init method failed; nested exception is liquibase.exception.MigrationFailedException: Migration failed for change set migration/amethyst/2011-05-28-9305.xml::2011-05-9305-1::ahamid:
Reason:
Empty result set, expected one row
:
Caused By: Precondition Error
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1420)
......... 50 more

Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set migration/amethyst/2011-05-28-9305.xml::2011-05-9305-1::ahamid:
Reason:
Empty result set, expected one row
:
Caused By: Precondition Error
at liquibase.ChangeSet.execute(ChangeSet.java:204)
at liquibase.parser.visitor.UpdateVisitor.visit(UpdateVisitor.java:26)
... 56 more

Nov 18, 2017 10:54:15 PM org.apache.catalina.core.StandardContext startInternal
SEVERE: Error listenerStart
Nov 18, 2017 10:54:15 PM org.apache.catalina.core.StandardContext startInternal
SEVERE: Context [/OpenClinica] startup failed due to previous errors
Nov 18, 2017 10:54:15 PM org.apache.catalina.core.StandardContext listenerStop
SEVERE: Exception sending context destroyed event to listener instance of class org.akaza.openclinica.control.OCServletContextListener
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in class path resource [org/akaza/openclinica/applicationContext-core-db.xml]: Invocation of init method failed; nested exception is liquibase.exception.MigrationFailedException: Migration failed for change set migration/amethyst/2011-05-28-9305.xml::2011-05-9305-1::ahamid:
Reason:
Empty result set, expected one row
:
Caused By: Precondition Error
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1420)
....50 more

at java.lang.Thread.run(Thread.java:744)
Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set migration/amethyst/2011-05-28-9305.xml::2011-05-9305-1::ahamid:
Reason:
Empty result set, expected one row
:
Caused By: Precondition Error
at liquibase.ChangeSet.execute(ChangeSet.java:204)
... 56 more

Nov 18, 2017 10:54:15 PM org.apache.catalina.core.ApplicationContext log
INFO: Closing Spring root WebApplicationContext
Nov 18, 2017 10:54:15 PM org.apache.catalina.loader.WebappClassLoader clearReferencesJdbc
SEVERE: The web application [/OpenClinica] registered the JDBC driver [org.postgresql.Driver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.
Nov 18, 2017 10:54:15 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: The web application [/OpenClinica] appears to have started a thread named [[email protected]] but has failed to stop it. This is very likely to create a memory leak.
Nov 18, 2017 10:54:15 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: The web application [/OpenClinica] appears to have started a thread named [Timer-3] but has failed to stop it. This is very likely to create a memory leak.



If someone can point me in the right direction, I'd appreciate that.

Thank you in advance
Derek

Comments

  • hopiihopii Posts: 2
    Problem has been solved. PostgreSQL 10 caused the issue. Installing 8.4 solved it.
  • haenselhaensel ✭✭✭ Posts: 602 ✭✭✭
    That's nasty but good to know.
Sign In or Register to comment.