31 Dec 2018: Thank you to our knowledgeable and friendly forums users for another great year. We are aware of the uptick in spam accounts and are doing our best to ban these at first sight. Thank you for your patience!

Installation issue -> CREATE EXTENSION postgres_fdw

org.akaza.openclinica.dao.core.OCContextLoaderListener
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'createPostgresAppServer' defined in org.akaza.openclinica.core.LiquibaseConfig: Invocation of init method failed; nested exception is liquibase.exception.MigrationFailedException: Migration failed for change set migration/initDB/mappingServer.xml::2017-03-31-7969-1::yogi:
Reason: liquibase.exception.DatabaseException: ERROR: syntax error at or near "EXTENSION"
Position: 8 [Failed SQL: CREATE EXTENSION postgres_fdw]

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1634)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:555)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:312)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:308)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:761)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:867)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:543)
at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:443)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:325)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:107)
at org.akaza.openclinica.dao.core.OCContextLoaderListener.contextInitialized(OCContextLoaderListener.java:37)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5157)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5680)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:145)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:1018)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:994)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:652)
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:1127)
at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:2021)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set migration/initDB/mappingServer.xml::2017-03-31-7969-1::yogi:
Reason: liquibase.exception.DatabaseException: ERROR: syntax error at or near "EXTENSION"
Position: 8 [Failed SQL: CREATE EXTENSION postgres_fdw]
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:619)
at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:51)
at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:79)
at liquibase.Liquibase.update(Liquibase.java:214)
at liquibase.Liquibase.update(Liquibase.java:192)
at liquibase.integration.spring.SpringLiquibase.performUpdate(SpringLiquibase.java:431)
at liquibase.integration.spring.SpringLiquibase.afterPropertiesSet(SpringLiquibase.java:388)
at org.akaza.openclinica.core.OCCreatePostgresAppServer.afterPropertiesSet(OCCreatePostgresAppServer.java:30)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1692)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1630)
... 26 more

Comments

  • haenselhaensel Posts: 586 ✭✭
    Hi @ravikumarverma53

    You probably try to build OC-4. This is of no use. Unless you are an enterprise user you can't do anything usefull with OC-4 since it depends heavily on modules that you only have access to if you are an enterprise user.

    Resolving this error won't bring you to an working OC-4 so my advise is to don't proceed with compiling oc-4.

    Regards,
    Christian
  • Thanks,
    But how I can copy code for community level code from github.
  • haenselhaensel Posts: 586 ✭✭
    You can checkout the 3.x versions.

    e.g. to checkout OC-3.14

    git clone -b 3.14 https://github.com/OpenClinica/OpenClinica.git
  • Thanks for quick reply.
    But I am using same link as you shared.
    https://github.com/OpenClinica/OpenClinica.git

    Following link is not working
    https://distros.openclinica.com/OpenClinica-3.14.zip

    I think, above mention link is community version link.
  • Hi,

    When I am deploying war of OpenClinica 3.14, then I am getting error:

    20:36:00,039 |-ERROR in ch.qos.logback.classic.net.SyslogAppender[SYSLOG-USAGESTATS] - Could not create SyslogWriter java.net.UnknownHostException: usage.openclinica.com
    at java.net.UnknownHostException: usage.openclinica.com
    at at java.net.Inet6AddressImpl.lookupAllHostAddr(Native Method)
    at at java.net.InetAddress$2.lookupAllHostAddr(Unknown Source)
    at at java.net.InetAddress.getAddressesFromNameService(Unknown Source)
    at at java.net.InetAddress.getAllByName0(Unknown Source)
    at at java.net.InetAddress.getAllByName(Unknown Source)
    at at java.net.InetAddress.getAllByName(Unknown Source)
    at at java.net.InetAddress.getByName(Unknown Source)
    at at ch.qos.logback.core.net.SyslogOutputStream.(SyslogOutputStream.java:44)
    at at ch.qos.logback.classic.net.SyslogAppender.createOutputStream(SyslogAppender.java:61)
    at at ch.qos.logback.core.net.SyslogAppenderBase.start(SyslogAppenderBase.java:54)
    at at ch.qos.logback.classic.net.SyslogAppender.start(SyslogAppender.java:51)
    at at ch.qos.logback.core.joran.action.AppenderAction.end(AppenderAction.java:96)
    at at ch.qos.logback.core.joran.spi.Interpreter.callEndAction(Interpreter.java:317)
    at at ch.qos.logback.core.joran.spi.Interpreter.endElement(Interpreter.java:196)
    at at ch.qos.logback.core.joran.spi.Interpreter.endElement(Interpreter.java:182)
    at at ch.qos.logback.core.joran.spi.EventPlayer.play(EventPlayer.java:62)
    at at ch.qos.logback.core.joran.GenericConfigurator.doConfigure(GenericConfigurator.java:149)
    at at ch.qos.logback.core.joran.GenericConfigurator.doConfigure(GenericConfigurator.java:135)
    at at ch.qos.logback.core.joran.GenericConfigurator.doConfigure(GenericConfigurator.java:99)
    at at ch.qos.logback.core.joran.GenericConfigurator.doConfigure(GenericConfigurator.java:49)
    at at ch.qos.logback.classic.util.ContextInitializer.configureByResource(ContextInitializer.java:75)
    at at ch.qos.logback.classic.util.ContextInitializer.autoConfig(ContextInitializer.java:150)
    at at org.slf4j.impl.StaticLoggerBinder.init(StaticLoggerBinder.java:85)
    at at org.slf4j.impl.StaticLoggerBinder.(StaticLoggerBinder.java:55)
    at at org.slf4j.LoggerFactory.bind(LoggerFactory.java:129)
    at at org.slf4j.LoggerFactory.performInitialization(LoggerFactory.java:108)
    at at org.slf4j.LoggerFactory.getILoggerFactory(LoggerFactory.java:302)
    at at org.slf4j.LoggerFactory.getLogger(LoggerFactory.java:276)
    at at org.akaza.openclinica.dao.core.OCContextLoaderListener.(OCContextLoaderListener.java:15)
    at at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    at at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    at at java.lang.reflect.Constructor.newInstance(Unknown Source)
    at at org.apache.catalina.core.DefaultInstanceManager.newInstance(DefaultInstanceManager.java:149)
    at at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5073)
    at at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5680)
    at at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:145)
    at at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:1018)
    at at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:994)
    at at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:652)
    at at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:1127)
    at at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:2021)
    at at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
    at at java.util.concurrent.FutureTask.run(Unknown Source)
    at at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    at at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at at java.lang.Thread.run(Unknown Source)
    20:36:00,042 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction - Setting additivity of logger [org.hibernate.SQL] to false
    20:36:00,042 |-INFO in ch.qos.logback.classic.joran.action.LevelAction - org.hibernate.SQL level set to ERROR


    Tomcate std.error:
    INFO: Server startup in 31080 ms
    solveReference(BeanDefinitionValueResolver.java:322)
    at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1325)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1086)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
    at org.springframework.context.support.AbstractApplicationContext.invokeBeanFactoryPostProcessors(AbstractApplicationContext.java:626)
    at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:407)
    at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:276)
    at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:197)
    at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)
    at org.akaza.openclinica.dao.core.OCContextLoaderListener.contextInitialized(OCContextLoaderListener.java:38)
    at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5157)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5680)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:145)
    at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:1018)
    at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:994)
    at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:652)
    at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:1127)
    at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:2021)
    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
    at java.util.concurrent.FutureTask.run(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)

Sign In or Register to comment.