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

openclinica 3.1 web service installation issues

Hi users and developers,

I had a OC3.1.1 installed and running on a w2k3 R2 server. Then I tried to install OC-ws 3.1 onto the same tomcat. Deploying OpenClinica-ws.war to webapps was successful but tomcat failed to startup the /openclinica-ws. The catalina.log contained the errors as below.
Aug 25, 2011 8:06:09 AM org.apache.catalina.core.AprLifecycleListener init
INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: E:\oc\Tomcat6\bin;.;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;E:\oc\jdk1.6.0_16
Aug 25, 2011 8:06:10 AM org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-80
Aug 25, 2011 8:06:10 AM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 1564 ms
Aug 25, 2011 8:06:10 AM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
Aug 25, 2011 8:06:10 AM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.32
Aug 25, 2011 8:06:10 AM org.apache.catalina.startup.HostConfig deployDescriptor
INFO: Deploying configuration descriptor host-manager.xml
Aug 25, 2011 8:06:10 AM org.apache.catalina.startup.HostConfig deployDescriptor
INFO: Deploying configuration descriptor manager.xml
Aug 25, 2011 8:06:11 AM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive OpenClinica-ws.war
Aug 25, 2011 8:06:31 AM org.apache.catalina.core.StandardContext start
SEVERE: Error listenerStart
Aug 25, 2011 8:06:31 AM org.apache.catalina.core.StandardContext start
SEVERE: Context [/OpenClinica-ws] startup failed due to previous errors
localhost.log had more info about the failed startup:
Aug 25, 2011 8:25:57 AM org.apache.catalina.core.ApplicationContext log

INFO: Initializing Spring root WebApplicationContext
Aug 25, 2011 8:26:07 AM org.apache.catalina.core.StandardContext listenerStart
SEVERE: Exception sending context initialized event to listener instance of class org.springframework.web.context.ContextLoaderListener
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in URL [jar:file:/E:/oc/Tomcat6/webapps/OpenClinica-ws/WEB-INF/lib/OpenClinica-core-3.1.1-Community.jar!/org/akaza/openclinica/applicationContext-core-db.xml]: Invocation of init method failed; nested exception is liquibase.exception.JDBCException: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (FATAL: database "openclinica-ws" does not exist)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1420)

It seemed that it was looking for a database named "openclinica-ws", but because the database was installed by OC3.1 and it's named "openclinica". I figured the database name was from datainfo.properties of openclinica-ws:

dbType=postgres
dbUser=clinica
dbPass=clinica
db=${WEBAPP.lower}
dbPort=5432
dbHost=localhost

If I overwrote the db options with db=openclinica, then /openclinica-ws started working.

Has anyone else experienced this issue before? Please let me know your thoughts.

Thanks,
Michael

Comments

  • smartinsmartin Posts: 145
    Re: [Users] openclinica 3.1 web service installation issues Hi Michael,
    In 3.1 we implemented a variable to define the database based off of the webapp name. Since this webapp is named openclinica-ws there is no database called openclinica-ws so it could not start. If you change the “db” entry in datainfo.properties to point to a 3.1 database you should be all set.
    Thanks,
    Shaun
    On 8/25/11 02:10 PM, "Michael Shi" wrote:
    Hi users and developers,

    I had a OC3.1.1 installed and running on a w2k3 R2 server. Then I tried to install OC-ws 3.1 onto the same tomcat. Deploying OpenClinica-ws.war to webapps was successful but tomcat failed to startup the /openclinica-ws. The catalina.log contained the errors as below.
    Aug 25, 2011 8:06:09 AM org.apache.catalina.core.AprLifecycleListener init
    INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: E:\oc\Tomcat6\bin;.;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;E:\oc\jdk1.6.0_16
    Aug 25, 2011 8:06:10 AM org.apache.coyote.http11.Http11Protocol init
    INFO: Initializing Coyote HTTP/1.1 on http-80
    Aug 25, 2011 8:06:10 AM org.apache.catalina.startup.Catalina load
    INFO: Initialization processed in 1564 ms
    Aug 25, 2011 8:06:10 AM org.apache.catalina.core.StandardService start
    INFO: Starting service Catalina
    Aug 25, 2011 8:06:10 AM org.apache.catalina.core.StandardEngine start
    INFO: Starting Servlet Engine: Apache Tomcat/6.0.32
    Aug 25, 2011 8:06:10 AM org.apache.catalina.startup.HostConfig deployDescriptor
    INFO: Deploying configuration descriptor host-manager.xml
    Aug 25, 2011 8:06:10 AM org.apache.catalina.startup.HostConfig deployDescriptor
    INFO: Deploying configuration descriptor manager.xml
    Aug 25, 2011 8:06:11 AM org.apache.catalina.startup.HostConfig deployWAR
    INFO: Deploying web application archive OpenClinica-ws.war
    Aug 25, 2011 8:06:31 AM org.apache.catalina.core.StandardContext start
    SEVERE: Error listenerStart
    Aug 25, 2011 8:06:31 AM org.apache.catalina.core.StandardContext start
    SEVERE: Context [/OpenClinica-ws] startup failed due to previous errors
    localhost.log had more info about the failed startup:
    Aug 25, 2011 8:25:57 AM org.apache.catalina.core.ApplicationContext log

    INFO: Initializing Spring root WebApplicationContext
    Aug 25, 2011 8:26:07 AM org.apache.catalina.core.StandardContext listenerStart
    SEVERE: Exception sending context initialized event to listener instance of class org.springframework.web.context.ContextLoaderListener
    org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in URL [jar:file:/E:/oc/Tomcat6/webapps/OpenClinica-ws/WEB-INF/lib/OpenClinica-core-3.1.1-Community.jar!/org/akaza/openclinica/applicationContext-core-db.xml]: Invocation of init method failed; nested exception is liquibase.exception.JDBCException: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (FATAL: database "openclinica-ws" does not exist)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1420)

    It seemed that it was looking for a database named "openclinica-ws", but because the database was installed by OC3.1 and it's named "openclinica". I figured the database name was from datainfo.properties of openclinica-ws:

    dbType=postgres
    dbUser=clinica
    dbPass=clinica
    db=${WEBAPP.lower}
    dbPort=5432
    dbHost=localhost

    If I overwrote the db options with db=openclinica, then /openclinica-ws started working.

    Has anyone else experienced this issue before? Please let me know your thoughts.

    Thanks,
    Michael
This discussion has been closed.