Guest User

feasability study

a guest
Sep 2nd, 2015
198
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 192.31 KB | None | 0 0
  1. Last login: Wed Sep 2 00:20:42 on ttys000
  2. -bash: e: command not found
  3. rgmac:~ maurya$ cd Downloads/
  4. rgmac:Downloads maurya$ java -XX:MaxPermSize=128m -jar Olympus-1.2.0-exec.war
  5. Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=128m; support was removed in 8.0
  6.  
  7. . ____ _ __ _ _
  8. /\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \
  9. ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
  10. \\/ ___)| |_)| | | | | || (_| | ) ) ) )
  11. ' |____| .__|_| |_|_| |_\__, | / / / /
  12. =========|_|==============|___/=/_/_/_/
  13. :: Spring Boot :: (v1.2.1.RELEASE)
  14.  
  15. 2015-09-02 01:03:03.389 INFO main org.ohdsi.olympus.Olympus - - Starting Olympus on rgmac.local with PID 1322 (started by maurya in /Users/maurya/Downloads)
  16. 2015-09-02 01:03:03.390 DEBUG main org.ohdsi.olympus.Olympus - - Running with Spring Boot v1.2.1.RELEASE, Spring v4.1.4.RELEASE
  17. 2015-09-02 01:03:03.444 INFO main org.springframework.boot.context.embedded.AnnotationConfigEmbeddedWebApplicationContext - - Refreshing org.springframework.boot.context.embedded.AnnotationConfigEmbeddedWebApplicationContext@6b66587e: startup date [Wed Sep 02 01:03:03 EDT 2015]; root of context hierarchy
  18. 2015-09-02 01:03:03.816 WARN main org.springframework.core.io.support.PathMatchingResourcePatternResolver - - Skipping [/Users/maurya/Downloads/Olympus-1.2.0-exec.war] because it does not denote a directory
  19. 2015-09-02 01:03:04.665 INFO main org.springframework.beans.factory.support.DefaultListableBeanFactory - - Overriding bean definition for bean 'passwordEncoder': replacing [Root bean: class [null]; scope=; abstract=false; lazyInit=false; autowireMode=3; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=securityConfig.SecurityUtilsConfiguration; factoryMethodName=passwordEncoder; initMethodName=null; destroyMethodName=(inferred); defined in class path resource [org/ohdsi/olympus/SecurityConfig$SecurityUtilsConfiguration.class]] with [Root bean: class [null]; scope=; abstract=false; lazyInit=false; autowireMode=3; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=securityConfig; factoryMethodName=passwordEncoder; initMethodName=null; destroyMethodName=(inferred); defined in class path resource [org/ohdsi/olympus/SecurityConfig.class]]
  20. 2015-09-02 01:03:05.453 INFO main org.hibernate.validator.internal.util.Version - - HV000001: Hibernate Validator 5.1.3.Final
  21. 2015-09-02 01:03:05.739 INFO main org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - - Bean 'org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration' of type [class org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration$$EnhancerBySpringCGLIB$$620f90ac] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
  22. 2015-09-02 01:03:05.786 INFO main org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - - Bean 'transactionAttributeSource' of type [class org.springframework.transaction.annotation.AnnotationTransactionAttributeSource] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
  23. 2015-09-02 01:03:05.807 INFO main org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - - Bean 'transactionInterceptor' of type [class org.springframework.transaction.interceptor.TransactionInterceptor] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
  24. 2015-09-02 01:03:05.835 INFO main org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - - Bean 'org.springframework.transaction.config.internalTransactionAdvisor' of type [class org.springframework.transaction.interceptor.BeanFactoryTransactionAttributeSourceAdvisor] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
  25. 2015-09-02 01:03:06.261 INFO main org.springframework.boot.context.embedded.jetty.JettyEmbeddedServletContainerFactory - - Server initialized with port: 20000
  26. 2015-09-02 01:03:06.323 INFO main org.eclipse.jetty.server.Server - - jetty-9.2.4.v20141103
  27. 2015-09-02 01:03:06.379 INFO main / - - Initializing Spring embedded WebApplicationContext
  28. 2015-09-02 01:03:06.379 INFO main org.springframework.web.context.ContextLoader - - Root WebApplicationContext: initialization completed in 2938 ms
  29. 2015-09-02 01:03:07.498 INFO main org.ohdsi.olympus.DataSourceConfig - - Using jdbcurl: jdbc:h2:file:/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/olympus/dbfile
  30. 2015-09-02 01:03:07.597 INFO main org.springframework.jdbc.datasource.DriverManagerDataSource - - Loaded JDBC driver: org.h2.Driver
  31. 2015-09-02 01:03:07.883 INFO main org.springframework.jdbc.datasource.init.ScriptUtils - - Executing SQL script from URL [jar:file:/Users/maurya/Downloads/Olympus-1.2.0-exec.war!/WEB-INF/classes!/schema.sql]
  32. 2015-09-02 01:03:07.894 INFO main org.springframework.jdbc.datasource.init.ScriptUtils - - Executed SQL script from URL [jar:file:/Users/maurya/Downloads/Olympus-1.2.0-exec.war!/WEB-INF/classes!/schema.sql] in 11 ms.
  33. 2015-09-02 01:03:07.908 INFO main org.springframework.jdbc.datasource.init.ScriptUtils - - Executing SQL script from URL [jar:file:/Users/maurya/Downloads/Olympus-1.2.0-exec.war!/WEB-INF/classes!/data.sql]
  34. 2015-09-02 01:03:07.915 INFO main org.springframework.jdbc.datasource.init.ScriptUtils - - Executed SQL script from URL [jar:file:/Users/maurya/Downloads/Olympus-1.2.0-exec.war!/WEB-INF/classes!/data.sql] in 7 ms.
  35. 2015-09-02 01:03:08.193 INFO main org.springframework.security.web.DefaultSecurityFilterChain - - Creating filter chain: Ant [pattern='/static/**'], []
  36. 2015-09-02 01:03:08.193 INFO main org.springframework.security.web.DefaultSecurityFilterChain - - Creating filter chain: Ant [pattern='/webjars/**'], []
  37. 2015-09-02 01:03:08.193 INFO main org.springframework.security.web.DefaultSecurityFilterChain - - Creating filter chain: Ant [pattern='/js/**'], []
  38. 2015-09-02 01:03:08.193 INFO main org.springframework.security.web.DefaultSecurityFilterChain - - Creating filter chain: Ant [pattern='/css/**'], []
  39. 2015-09-02 01:03:08.193 INFO main org.springframework.security.web.DefaultSecurityFilterChain - - Creating filter chain: Ant [pattern='/img/**'], []
  40. 2015-09-02 01:03:08.230 INFO main org.springframework.security.web.DefaultSecurityFilterChain - - Creating filter chain: Ant [pattern='/console/**'], [org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter@5117dc79, org.springframework.security.web.context.SecurityContextPersistenceFilter@6ecffed9, org.springframework.security.web.authentication.logout.LogoutFilter@2ec28b0e, org.springframework.security.web.authentication.UsernamePasswordAuthenticationFilter@6eef6332, org.springframework.security.web.savedrequest.RequestCacheAwareFilter@197a385c, org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter@2831e48c, org.springframework.security.web.authentication.AnonymousAuthenticationFilter@44f4c39a, org.springframework.security.web.session.SessionManagementFilter@46031edd, org.springframework.security.web.access.ExceptionTranslationFilter@70107842, org.springframework.security.web.access.intercept.FilterSecurityInterceptor@1ccb324e]
  41. 2015-09-02 01:03:08.243 INFO main org.springframework.security.web.DefaultSecurityFilterChain - - Creating filter chain: org.springframework.security.web.util.matcher.AnyRequestMatcher@1, [org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter@79931131, org.springframework.security.web.context.SecurityContextPersistenceFilter@60cebc0b, org.springframework.security.web.csrf.CsrfFilter@2723bb6, org.springframework.security.web.authentication.logout.LogoutFilter@4679965d, org.springframework.security.web.authentication.UsernamePasswordAuthenticationFilter@9f67bd6, org.springframework.security.web.savedrequest.RequestCacheAwareFilter@340372a9, org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter@20192fa0, org.springframework.security.web.authentication.rememberme.RememberMeAuthenticationFilter@5cc13f1e, org.springframework.security.web.authentication.AnonymousAuthenticationFilter@4301ed1e, org.springframework.security.web.session.SessionManagementFilter@61c0355, org.springframework.security.web.access.ExceptionTranslationFilter@152025cc, org.springframework.security.web.access.intercept.FilterSecurityInterceptor@7f317a64]
  42. 2015-09-02 01:03:08.313 INFO main org.springframework.boot.context.embedded.ServletRegistrationBean - - Mapping servlet: 'webServlet' to [/console/*]
  43. 2015-09-02 01:03:08.315 INFO main org.springframework.boot.context.embedded.ServletRegistrationBean - - Mapping servlet: 'dispatcherServlet' to [/]
  44. 2015-09-02 01:03:08.316 INFO main org.springframework.boot.context.embedded.FilterRegistrationBean - - Mapping filter: 'characterEncodingFilter' to: [/*]
  45. 2015-09-02 01:03:08.319 INFO main org.springframework.boot.context.embedded.FilterRegistrationBean - - Mapping filter: 'springSecurityFilterChain' to: [/*]
  46. 2015-09-02 01:03:08.319 INFO main org.springframework.boot.context.embedded.FilterRegistrationBean - - Mapping filter: 'hiddenHttpMethodFilter' to: [/*]
  47. 2015-09-02 01:03:08.320 INFO main org.eclipse.jetty.server.handler.ContextHandler - - Started o.s.b.c.e.j.JettyEmbeddedWebAppContext@2265b737{/,jar:file:/Users/maurya/Downloads/Olympus-1.2.0-exec.war!/,AVAILABLE}
  48. 2015-09-02 01:03:08.320 INFO main org.eclipse.jetty.server.Server - - Started @6366ms
  49. 2015-09-02 01:03:08.471 INFO main org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean - - Building JPA container EntityManagerFactory for persistence unit 'default'
  50. 2015-09-02 01:03:08.486 INFO main org.hibernate.jpa.internal.util.LogHelper - - HHH000204: Processing PersistenceUnitInfo [
  51. name: default
  52. ...]
  53. 2015-09-02 01:03:08.590 INFO main org.hibernate.Version - - HHH000412: Hibernate Core {4.3.7.Final}
  54. 2015-09-02 01:03:08.596 INFO main org.hibernate.cfg.Environment - - HHH000206: hibernate.properties not found
  55. 2015-09-02 01:03:08.598 INFO main org.hibernate.cfg.Environment - - HHH000021: Bytecode provider name : javassist
  56. 2015-09-02 01:03:09.176 INFO main org.hibernate.annotations.common.Version - - HCANN000001: Hibernate Commons Annotations {4.0.5.Final}
  57. 2015-09-02 01:03:09.270 INFO main org.hibernate.dialect.Dialect - - HHH000400: Using dialect: org.hibernate.dialect.H2Dialect
  58. 2015-09-02 01:03:09.516 INFO main org.hibernate.hql.internal.ast.ASTQueryTranslatorFactory - - HHH000397: Using ASTQueryTranslatorFactory
  59. 2015-09-02 01:03:09.849 INFO main org.ohdsi.olympus.WebApiConfig - - Copying WAR to absolute path: /var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/olympus
  60. 2015-09-02 01:03:09.857 DEBUG main org.ohdsi.olympus.WebApiConfig - - InputStream for WebAPI.war: 0
  61. 2015-09-02 01:03:10.461 INFO main org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter - - Looking for @ControllerAdvice: org.springframework.boot.context.embedded.AnnotationConfigEmbeddedWebApplicationContext@6b66587e: startup date [Wed Sep 02 01:03:03 EDT 2015]; root of context hierarchy
  62. 2015-09-02 01:03:10.540 INFO main org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - - Mapped "{[/achilles//datasources],methods=[GET],params=[],headers=[],consumes=[],produces=[application/json],custom=[]}" onto public org.springframework.http.HttpEntity<org.json.simple.JSONObject> org.ohdsi.olympus.controller.AchillesController.datasource()
  63. 2015-09-02 01:03:10.540 INFO main org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - - Mapped "{[/achilles//data],methods=[GET],params=[],headers=[],consumes=[],produces=[application/json],custom=[]}" onto public org.springframework.http.HttpEntity<org.json.simple.JSONObject> org.ohdsi.olympus.controller.AchillesController.datasource(java.lang.String,java.lang.String)
  64. 2015-09-02 01:03:10.541 INFO main org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - - Mapped "{[/login],methods=[GET],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public org.springframework.web.servlet.ModelAndView org.ohdsi.olympus.controller.LoginController.getLoginPage(java.lang.String,javax.servlet.http.HttpServletRequest,org.springframework.security.core.Authentication)
  65. 2015-09-02 01:03:10.541 INFO main org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - - Mapped "{[/home/index || /home || //index || /],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public org.springframework.web.servlet.ModelAndView org.ohdsi.olympus.controller.MainController.handleIndexRequest() throws java.lang.Exception
  66. 2015-09-02 01:03:10.541 INFO main org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - - Mapped "{[/home/error || //error],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public org.springframework.web.servlet.ModelAndView org.ohdsi.olympus.controller.MainController.handleErrorRequest(javax.servlet.http.HttpServletRequest,javax.servlet.http.HttpServletResponse,javax.servlet.http.HttpSession) throws java.lang.Exception
  67. 2015-09-02 01:03:10.542 INFO main org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - - Mapped "{[/user],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public org.springframework.web.servlet.ModelAndView org.ohdsi.olympus.controller.UserController.getUsersPage()
  68. 2015-09-02 01:03:10.542 INFO main org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - - Mapped "{[/user/create],methods=[GET],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public org.springframework.web.servlet.ModelAndView org.ohdsi.olympus.controller.UserController.getUserCreatePage()
  69. 2015-09-02 01:03:10.542 INFO main org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - - Mapped "{[/user/create],methods=[POST],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public org.springframework.web.servlet.ModelAndView org.ohdsi.olympus.controller.UserController.handleUserCreateForm(org.ohdsi.olympus.model.UserCreateForm,org.springframework.validation.BindingResult)
  70. 2015-09-02 01:03:10.543 INFO main org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - - Mapped "{[/webapi/start],methods=[POST],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public org.springframework.http.ResponseEntity org.ohdsi.olympus.controller.WebApiController.start() throws java.lang.Exception
  71. 2015-09-02 01:03:10.544 INFO main org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - - Mapped "{[/webapi/stop],methods=[POST],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public org.springframework.http.ResponseEntity org.ohdsi.olympus.controller.WebApiController.stop() throws java.lang.Exception
  72. 2015-09-02 01:03:10.544 INFO main org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - - Mapped "{[/webapi],methods=[GET],params=[],headers=[],consumes=[],produces=[application/json],custom=[]}" onto public org.springframework.http.HttpEntity<java.util.List<org.ohdsi.olympus.model.WebApiRemote>> org.ohdsi.olympus.controller.WebApiController.webApis()
  73. 2015-09-02 01:03:10.544 INFO main org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - - Mapped "{[/webapi/config],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public org.springframework.web.servlet.ModelAndView org.ohdsi.olympus.controller.WebApiController.handleConfigurationRequest(java.lang.String) throws java.lang.Exception
  74. 2015-09-02 01:03:10.544 INFO main org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - - Mapped "{[/webapi/remote],methods=[POST],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public org.springframework.web.servlet.ModelAndView org.ohdsi.olympus.controller.WebApiController.handleConfigurationSubmission(org.ohdsi.olympus.model.WebApiRemote,org.springframework.validation.BindingResult) throws java.lang.Exception
  75. 2015-09-02 01:03:10.544 INFO main org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - - Mapped "{[/webapi/appproperties],methods=[POST],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public org.springframework.web.servlet.ModelAndView org.ohdsi.olympus.controller.WebApiController.handleConfigurationSubmission(org.ohdsi.olympus.model.AppProperties,org.springframework.validation.BindingResult) throws java.lang.Exception
  76. 2015-09-02 01:03:10.544 INFO main org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - - Mapped "{[/webapi/config],methods=[POST],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public org.springframework.web.servlet.ModelAndView org.ohdsi.olympus.controller.WebApiController.handleConfigurationSubmission(org.ohdsi.olympus.model.WebApiProperties,org.springframework.validation.BindingResult) throws java.lang.Exception
  77. 2015-09-02 01:03:10.544 INFO main org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - - Mapped "{[/webapi/request-start],methods=[POST],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public org.springframework.web.servlet.ModelAndView org.ohdsi.olympus.controller.WebApiController.handleStartSubmission() throws java.lang.Exception
  78. 2015-09-02 01:03:10.546 INFO main org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - - Mapped "{[/error],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public org.springframework.http.ResponseEntity<java.util.Map<java.lang.String, java.lang.Object>> org.springframework.boot.autoconfigure.web.BasicErrorController.error(javax.servlet.http.HttpServletRequest)
  79. 2015-09-02 01:03:10.547 INFO main org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - - Mapped "{[/error],methods=[],params=[],headers=[],consumes=[],produces=[text/html],custom=[]}" onto public org.springframework.web.servlet.ModelAndView org.springframework.boot.autoconfigure.web.BasicErrorController.errorHtml(javax.servlet.http.HttpServletRequest)
  80. 2015-09-02 01:03:10.585 INFO main org.springframework.web.servlet.handler.SimpleUrlHandlerMapping - - Mapped URL path [/webjars/**] onto handler of type [class org.springframework.web.servlet.resource.ResourceHttpRequestHandler]
  81. 2015-09-02 01:03:10.585 INFO main org.springframework.web.servlet.handler.SimpleUrlHandlerMapping - - Mapped URL path [/**] onto handler of type [class org.springframework.web.servlet.resource.ResourceHttpRequestHandler]
  82. 2015-09-02 01:03:10.641 INFO main org.springframework.web.servlet.handler.SimpleUrlHandlerMapping - - Mapped URL path [/**/favicon.ico] onto handler of type [class org.springframework.web.servlet.resource.ResourceHttpRequestHandler]
  83. 2015-09-02 01:03:10.979 INFO main org.springframework.boot.autoconfigure.security.AuthenticationManagerConfiguration - -
  84.  
  85. Using default security password: 12ec74ab-edf5-4176-a455-e0815b7b758a
  86.  
  87. 2015-09-02 01:03:11.028 INFO main org.springframework.web.servlet.view.velocity.VelocityConfigurer - - ClasspathResourceLoader with name 'springMacro' added to configured VelocityEngine
  88. 2015-09-02 01:03:11.039 INFO main org.springframework.ui.velocity.SpringResourceLoader - - SpringResourceLoader for Velocity: using resource loader [org.springframework.boot.context.embedded.AnnotationConfigEmbeddedWebApplicationContext@6b66587e: startup date [Wed Sep 02 01:03:03 EDT 2015]; root of context hierarchy] and resource loader paths [classpath:/templates/]
  89. 2015-09-02 01:03:11.158 INFO main org.springframework.jmx.export.annotation.AnnotationMBeanExporter - - Registering beans for JMX exposure on startup
  90. 2015-09-02 01:03:11.176 INFO main / - - Initializing Spring FrameworkServlet 'dispatcherServlet'
  91. 2015-09-02 01:03:11.176 INFO main org.springframework.web.servlet.DispatcherServlet - - FrameworkServlet 'dispatcherServlet': initialization started
  92. 2015-09-02 01:03:11.206 INFO main org.springframework.web.servlet.DispatcherServlet - - FrameworkServlet 'dispatcherServlet': initialization completed in 30 ms
  93. 2015-09-02 01:03:11.251 INFO main org.eclipse.jetty.server.ServerConnector - - Started ServerConnector@18c2a746{HTTP/1.1}{0.0.0.0:20000}
  94. 2015-09-02 01:03:11.254 INFO main org.springframework.boot.context.embedded.jetty.JettyEmbeddedServletContainer - - Jetty started on port(s) 20000 (http/1.1)
  95. 2015-09-02 01:03:11.324 DEBUG main org.ohdsi.olympus.model.WebApiService - - Property [datasource.driverClassName,org.postgresql.Driver]
  96. 2015-09-02 01:03:11.324 DEBUG main org.ohdsi.olympus.model.WebApiService - - Property [datasource.url,jdbc:postgresql://localhost:5432/postgres]
  97. 2015-09-02 01:03:11.324 DEBUG main org.ohdsi.olympus.model.WebApiService - - Property [datasource.username,postgres]
  98. 2015-09-02 01:03:11.325 DEBUG main org.ohdsi.olympus.model.WebApiService - - Property [datasource.password,***]
  99. 2015-09-02 01:03:11.325 DEBUG main org.ohdsi.olympus.model.WebApiService - - Property [flyway.datasource.driverClassName,org.postgresql.Driver]
  100. 2015-09-02 01:03:11.325 DEBUG main org.ohdsi.olympus.model.WebApiService - - Property [flyway.datasource.url,jdbc:postgresql://localhost:5432/postgres]
  101. 2015-09-02 01:03:11.325 DEBUG main org.ohdsi.olympus.model.WebApiService - - Property [flyway.datasource.username,postgres]
  102. 2015-09-02 01:03:11.325 DEBUG main org.ohdsi.olympus.model.WebApiService - - Property [flyway.datasource.password,***]
  103. 2015-09-02 01:03:11.325 DEBUG main org.ohdsi.olympus.model.WebApiService - - Property [flyway.schemas,public]
  104. 2015-09-02 01:03:11.325 DEBUG main org.ohdsi.olympus.model.WebApiService - - Property [flyway.locations,classpath:db/migration/postgresql]
  105. 2015-09-02 01:03:11.325 DEBUG main org.ohdsi.olympus.model.WebApiService - - Property [datasource.dialect,postgresql]
  106. 2015-09-02 01:03:11.325 DEBUG main org.ohdsi.olympus.model.WebApiService - - Property [datasource.cdm.schema,postgres]
  107. 2015-09-02 01:03:11.325 DEBUG main org.ohdsi.olympus.model.WebApiService - - Property [datasource.ohdsi.schema,public]
  108. 2015-09-02 01:03:11.325 DEBUG main org.ohdsi.olympus.model.WebApiService - - Property [datasource.cohort.schema,public]
  109. 2015-09-02 01:03:11.335 INFO main org.ohdsi.olympus.model.WebApiService - - Not setting key[achilles.data.dir] due to null key or value
  110. 2015-09-02 01:03:11.335 WARN main org.ohdsi.olympus.model.WebApiService - - WebApi launch disabled.
  111. 2015-09-02 01:03:11.337 INFO main org.ohdsi.olympus.Olympus - - Started Olympus in 8.783 seconds (JVM running for 9.383)
  112. 2015-09-02 01:03:43.506 DEBUG qtp965307475-22 org.ohdsi.olympus.controller.WebApiController - - Get config
  113. 2015-09-02 01:03:46.563 INFO qtp965307475-44 org.ohdsi.olympus.model.WebApiService - - Starting WebAppContext: o.e.j.w.WebAppContext@5f8a03e3{/WebAPI,null,null}{/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/olympus/WebAPI.war}
  114. SLF4J: Class path contains multiple SLF4J bindings.
  115. SLF4J: Found binding in [jar:file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/slf4j-log4j12-1.7.8.jar!/org/slf4j/impl/StaticLoggerBinder.class]
  116. SLF4J: Found binding in [jar:file:/Users/maurya/Downloads/Olympus-1.2.0-exec.war!/WEB-INF/lib/slf4j-log4j12-1.7.8.jar!/org/slf4j/impl/StaticLoggerBinder.class]
  117. SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
  118. SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]
  119. 2015-09-02 01:03:48.782 INFO qtp965307475-44 /WebAPI - - Spring WebApplicationInitializers detected on classpath: [org.springframework.boot.autoconfigure.jersey.JerseyAutoConfiguration@5e8afbf3, org.ohdsi.webapi.WebApi@585cfb67, org.glassfish.jersey.server.spring.SpringWebApplicationInitializer@6440d9ee]
  120.  
  121. . ____ _ __ _ _
  122. /\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \
  123. ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
  124. \\/ ___)| |_)| | | | | || (_| | ) ) ) )
  125. ' |____| .__|_| |_|_| |_\__, | / / / /
  126. =========|_|==============|___/=/_/_/_/
  127. :: Spring Boot :: (v1.2.1.RELEASE)
  128.  
  129. 2015-09-02 01:03:49.293 INFO qtp965307475-44 org.springframework.boot.SpringApplication - - Starting application on rgmac.local with PID 1322 (/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-boot-1.2.1.RELEASE.jar started by maurya in /Users/maurya/Downloads)
  130. 2015-09-02 01:03:49.316 INFO qtp965307475-44 org.springframework.boot.context.embedded.AnnotationConfigEmbeddedWebApplicationContext - - Refreshing org.springframework.boot.context.embedded.AnnotationConfigEmbeddedWebApplicationContext@743885b6: startup date [Wed Sep 02 01:03:49 EDT 2015]; root of context hierarchy
  131. 2015-09-02 01:03:50.066 WARN qtp965307475-44 org.springframework.core.io.support.PathMatchingResourcePatternResolver - - Skipping [/Users/maurya/Downloads/Olympus-1.2.0-exec.war] because it does not denote a directory
  132. 2015-09-02 01:03:50.694 INFO qtp965307475-44 org.springframework.beans.factory.support.DefaultListableBeanFactory - - Overriding bean definition for bean 'entityLinksPluginRegistry': replacing [Root bean: class [org.springframework.plugin.core.support.PluginRegistryFactoryBean]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null] with [Root bean: class [org.springframework.plugin.core.support.PluginRegistryFactoryBean]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null]
  133. 2015-09-02 01:03:50.695 INFO qtp965307475-44 org.springframework.beans.factory.support.DefaultListableBeanFactory - - Overriding bean definition for bean 'controllerEntityLinks': replacing [Root bean: class [org.springframework.hateoas.core.ControllerEntityLinksFactoryBean]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null] with [Root bean: class [org.springframework.hateoas.core.ControllerEntityLinksFactoryBean]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null]
  134. 2015-09-02 01:03:50.695 INFO qtp965307475-44 org.springframework.beans.factory.support.DefaultListableBeanFactory - - Overriding bean definition for bean 'jaxRsEntityLinks': replacing [Root bean: class [org.springframework.hateoas.core.ControllerEntityLinksFactoryBean]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null] with [Root bean: class [org.springframework.hateoas.core.ControllerEntityLinksFactoryBean]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null]
  135. 2015-09-02 01:03:50.695 INFO qtp965307475-44 org.springframework.beans.factory.support.DefaultListableBeanFactory - - Overriding bean definition for bean 'delegatingEntityLinks': replacing [Root bean: class [org.springframework.hateoas.core.DelegatingEntityLinks]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=true; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null] with [Root bean: class [org.springframework.hateoas.core.DelegatingEntityLinks]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=true; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null]
  136. 2015-09-02 01:03:50.710 INFO qtp965307475-44 org.springframework.beans.factory.config.PropertiesFactoryBean - - Loading properties file from URL [jar:file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-integration-core-4.1.1.RELEASE.jar!/META-INF/spring.integration.default.properties]
  137. 2015-09-02 01:03:50.717 INFO qtp965307475-44 org.springframework.integration.config.IntegrationRegistrar - - No bean named 'integrationHeaderChannelRegistry' has been explicitly defined. Therefore, a default DefaultHeaderChannelRegistry will be created.
  138. 2015-09-02 01:03:50.944 WARN qtp965307475-44 org.springframework.context.annotation.ConfigurationClassEnhancer - - @Bean method ScopeConfiguration.stepScope is non-static and returns an object assignable to Spring's BeanFactoryPostProcessor interface. This will result in a failure to process annotations such as @Autowired, @Resource and @PostConstruct within the method's declaring @Configuration class. Add the 'static' modifier to this method to avoid these container lifecycle issues; see @Bean javadoc for complete details
  139. 2015-09-02 01:03:50.953 WARN qtp965307475-44 org.springframework.context.annotation.ConfigurationClassEnhancer - - @Bean method ScopeConfiguration.jobScope is non-static and returns an object assignable to Spring's BeanFactoryPostProcessor interface. This will result in a failure to process annotations such as @Autowired, @Resource and @PostConstruct within the method's declaring @Configuration class. Add the 'static' modifier to this method to avoid these container lifecycle issues; see @Bean javadoc for complete details
  140. 2015-09-02 01:03:50.992 INFO qtp965307475-44 org.springframework.integration.config.DefaultConfiguringBeanFactoryPostProcessor - - No bean named 'errorChannel' has been explicitly defined. Therefore, a default PublishSubscribeChannel will be created.
  141. 2015-09-02 01:03:50.996 INFO qtp965307475-44 org.springframework.integration.config.DefaultConfiguringBeanFactoryPostProcessor - - No bean named 'taskScheduler' has been explicitly defined. Therefore, a default ThreadPoolTaskScheduler will be created.
  142. 2015-09-02 01:03:51.006 INFO qtp965307475-44 org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor - - JSR-330 'javax.inject.Inject' annotation found and supported for autowiring
  143. 2015-09-02 01:03:51.049 INFO qtp965307475-44 org.hibernate.validator.internal.util.Version - - HV000001: Hibernate Validator 5.1.2.Final
  144. 2015-09-02 01:03:51.245 INFO qtp965307475-44 org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - - Bean '$autoCreateChannelCandidates' of type [class org.springframework.integration.config.ChannelInitializer$AutoCreateCandidatesCollector] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
  145. 2015-09-02 01:03:51.245 INFO qtp965307475-44 org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - - Bean 'org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration' of type [class org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration$$EnhancerBySpringCGLIB$$8e200227] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
  146. 2015-09-02 01:03:51.262 INFO qtp965307475-44 org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - - Bean 'transactionAttributeSource' of type [class org.springframework.transaction.annotation.AnnotationTransactionAttributeSource] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
  147. 2015-09-02 01:03:51.272 INFO qtp965307475-44 org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - - Bean 'transactionInterceptor' of type [class org.springframework.transaction.interceptor.TransactionInterceptor] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
  148. 2015-09-02 01:03:51.282 INFO qtp965307475-44 org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - - Bean 'org.springframework.transaction.config.internalTransactionAdvisor' of type [class org.springframework.transaction.interceptor.BeanFactoryTransactionAttributeSourceAdvisor] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
  149. 2015-09-02 01:03:51.310 INFO qtp965307475-44 org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - - Bean 'org.springframework.integration.jmx.config.IntegrationMBeanExportConfiguration' of type [class org.springframework.integration.jmx.config.IntegrationMBeanExportConfiguration$$EnhancerBySpringCGLIB$$d0cb25d3] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
  150. 2015-09-02 01:03:51.335 INFO qtp965307475-44 org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - - Bean 'org.springframework.boot.autoconfigure.jmx.JmxAutoConfiguration' of type [class org.springframework.boot.autoconfigure.jmx.JmxAutoConfiguration$$EnhancerBySpringCGLIB$$6fbbdc3] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
  151. 2015-09-02 01:03:51.343 INFO qtp965307475-44 org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - - Bean 'mbeanServer' of type [class com.sun.jmx.mbeanserver.JmxMBeanServer] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
  152. 2015-09-02 01:03:51.397 INFO qtp965307475-44 org.springframework.beans.factory.config.PropertiesFactoryBean - - Loading properties file from URL [jar:file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-integration-core-4.1.1.RELEASE.jar!/META-INF/spring.integration.default.properties]
  153. 2015-09-02 01:03:51.397 INFO qtp965307475-44 org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - - Bean 'integrationGlobalProperties' of type [class org.springframework.beans.factory.config.PropertiesFactoryBean] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
  154. 2015-09-02 01:03:51.398 INFO qtp965307475-44 org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - - Bean 'integrationGlobalProperties' of type [class java.util.Properties] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
  155. 2015-09-02 01:03:51.404 INFO qtp965307475-44 org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - - Bean 'messageBuilderFactory' of type [class org.springframework.integration.support.DefaultMessageBuilderFactory] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
  156. 2015-09-02 01:03:51.465 INFO qtp965307475-44 org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - - Bean '(inner bean)#448f23e7' of type [class org.springframework.integration.channel.MessagePublishingErrorHandler] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
  157. 2015-09-02 01:03:51.465 INFO qtp965307475-44 org.springframework.scheduling.concurrent.ThreadPoolTaskScheduler - - Initializing ExecutorService 'taskScheduler'
  158. 2015-09-02 01:03:51.465 INFO qtp965307475-44 org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - - Bean 'taskScheduler' of type [class org.springframework.scheduling.concurrent.ThreadPoolTaskScheduler] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
  159. 2015-09-02 01:03:51.466 INFO qtp965307475-44 org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - - Bean 'integrationHeaderChannelRegistry' of type [class org.springframework.integration.channel.DefaultHeaderChannelRegistry] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
  160. 2015-09-02 01:03:51.481 INFO qtp965307475-44 /WebAPI - - Initializing Spring embedded WebApplicationContext
  161. 2015-09-02 01:03:51.481 INFO qtp965307475-44 org.springframework.web.context.ContextLoader - - Root WebApplicationContext: initialization completed in 2165 ms
  162. 2015-09-02 01:03:52.264 INFO qtp965307475-44 org.springframework.boot.context.embedded.FilterRegistrationBean - - Mapping filter: 'errorPageFilter' to: [/*]
  163. 2015-09-02 01:03:52.264 INFO qtp965307475-44 org.springframework.boot.context.embedded.FilterRegistrationBean - - Mapping filter: 'characterEncodingFilter' to: [/*]
  164. 2015-09-02 01:03:52.264 INFO qtp965307475-44 org.springframework.boot.context.embedded.FilterRegistrationBean - - Mapping filter: 'requestContextFilter' to: [/*]
  165. 2015-09-02 01:03:52.264 INFO qtp965307475-44 org.springframework.boot.context.embedded.FilterRegistrationBean - - Mapping filter: 'hiddenHttpMethodFilter' to: [/*]
  166. 2015-09-02 01:03:52.264 INFO qtp965307475-44 org.springframework.boot.context.embedded.ServletRegistrationBean - - Mapping servlet: 'jerseyServlet' to [/*]
  167. 2015-09-02 01:03:52.264 INFO qtp965307475-44 org.springframework.boot.context.embedded.ServletRegistrationBean - - Mapping servlet: 'dispatcherServlet' to [/]
  168. 2015-09-02 01:03:52.322 INFO qtp965307475-44 org.springframework.jdbc.datasource.DriverManagerDataSource - - Loaded JDBC driver: org.postgresql.Driver
  169. 2015-09-02 01:03:52.783 INFO qtp965307475-44 org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean - - Building JPA container EntityManagerFactory for persistence unit 'default'
  170. 2015-09-02 01:03:52.792 INFO qtp965307475-44 org.hibernate.jpa.internal.util.LogHelper - - HHH000204: Processing PersistenceUnitInfo [
  171. name: default
  172. ...]
  173. 2015-09-02 01:03:52.854 INFO qtp965307475-44 org.hibernate.Version - - HHH000412: Hibernate Core {4.3.7.Final}
  174. 2015-09-02 01:03:52.863 INFO qtp965307475-44 org.hibernate.cfg.Environment - - HHH000206: hibernate.properties not found
  175. 2015-09-02 01:03:52.865 INFO qtp965307475-44 org.hibernate.cfg.Environment - - HHH000021: Bytecode provider name : javassist
  176. 2015-09-02 01:03:53.027 INFO qtp965307475-44 org.hibernate.annotations.common.Version - - HCANN000001: Hibernate Commons Annotations {4.0.5.Final}
  177. 2015-09-02 01:03:53.068 DEBUG qtp965307475-44 org.springframework.jdbc.datasource.DriverManagerDataSource - - Creating new JDBC DriverManager Connection to [jdbc:postgresql://localhost:5432/postgres]
  178. 2015-09-02 01:03:53.319 INFO qtp965307475-44 org.hibernate.dialect.Dialect - - HHH000400: Using dialect: org.hibernate.dialect.PostgreSQL9Dialect
  179. 2015-09-02 01:03:53.342 INFO qtp965307475-44 org.hibernate.engine.jdbc.internal.LobCreatorBuilder - - HHH000424: Disabling contextual LOB creation as createClob() method threw error : java.lang.reflect.InvocationTargetException
  180. 2015-09-02 01:03:53.539 INFO qtp965307475-44 org.hibernate.hql.internal.ast.ASTQueryTranslatorFactory - - HHH000397: Using ASTQueryTranslatorFactory
  181. 2015-09-02 01:03:54.110 DEBUG qtp965307475-44 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
  182. 2015-09-02 01:03:54.151 DEBUG qtp965307475-44 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
  183. 2015-09-02 01:03:54.160 DEBUG qtp965307475-44 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
  184. 2015-09-02 01:03:54.160 DEBUG qtp965307475-44 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
  185. 2015-09-02 01:03:54.326 DEBUG qtp965307475-44 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
  186. 2015-09-02 01:03:54.326 DEBUG qtp965307475-44 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
  187. 2015-09-02 01:03:54.326 DEBUG qtp965307475-44 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
  188. 2015-09-02 01:03:54.327 DEBUG qtp965307475-44 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
  189. 2015-09-02 01:03:54.359 DEBUG qtp965307475-44 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
  190. 2015-09-02 01:03:54.359 DEBUG qtp965307475-44 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
  191. 2015-09-02 01:03:54.360 DEBUG qtp965307475-44 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
  192. 2015-09-02 01:03:54.360 DEBUG qtp965307475-44 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
  193. 2015-09-02 01:03:54.427 DEBUG qtp965307475-44 org.springframework.jdbc.datasource.DataSourceUtils - - Fetching JDBC Connection from DataSource
  194. 2015-09-02 01:03:54.427 DEBUG qtp965307475-44 org.springframework.jdbc.datasource.DriverManagerDataSource - - Creating new JDBC DriverManager Connection to [jdbc:postgresql://localhost:5432/postgres]
  195. 2015-09-02 01:03:54.436 DEBUG qtp965307475-44 org.springframework.jdbc.datasource.DataSourceUtils - - Returning JDBC Connection to DataSource
  196. 2015-09-02 01:03:54.437 DEBUG qtp965307475-44 org.springframework.jdbc.datasource.DataSourceUtils - - Fetching JDBC Connection from DataSource
  197. 2015-09-02 01:03:54.437 DEBUG qtp965307475-44 org.springframework.jdbc.datasource.DriverManagerDataSource - - Creating new JDBC DriverManager Connection to [jdbc:postgresql://localhost:5432/postgres]
  198. 2015-09-02 01:03:54.447 DEBUG qtp965307475-44 org.springframework.jdbc.datasource.DataSourceUtils - - Returning JDBC Connection to DataSource
  199. 2015-09-02 01:03:54.479 DEBUG qtp965307475-44 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
  200. 2015-09-02 01:03:54.480 DEBUG qtp965307475-44 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
  201. 2015-09-02 01:03:54.480 DEBUG qtp965307475-44 org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler - - Creating new EntityManager for shared EntityManager invocation
  202. 2015-09-02 01:03:54.480 DEBUG qtp965307475-44 org.springframework.orm.jpa.EntityManagerFactoryUtils - - Closing JPA EntityManager
  203. 2015-09-02 01:03:54.512 INFO qtp965307475-44 org.springframework.scheduling.concurrent.ThreadPoolTaskExecutor - - Initializing ExecutorService
  204. 2015-09-02 01:03:54.517 INFO qtp965307475-44 org.springframework.scheduling.concurrent.ThreadPoolTaskExecutor - - Initializing ExecutorService 'taskExecutor'
  205. 2015-09-02 01:03:54.526 DEBUG qtp965307475-44 org.springframework.jdbc.datasource.DataSourceUtils - - Fetching JDBC Connection from DataSource
  206. 2015-09-02 01:03:54.526 DEBUG qtp965307475-44 org.springframework.jdbc.datasource.DriverManagerDataSource - - Creating new JDBC DriverManager Connection to [jdbc:postgresql://localhost:5432/postgres]
  207. 2015-09-02 01:03:54.536 DEBUG qtp965307475-44 org.springframework.jdbc.datasource.DataSourceUtils - - Returning JDBC Connection to DataSource
  208. 2015-09-02 01:03:54.536 INFO qtp965307475-44 org.springframework.batch.core.repository.support.JobRepositoryFactoryBean - - No database type set, using meta data indicating: POSTGRES
  209. 2015-09-02 01:03:54.875 INFO qtp965307475-44 org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter - - Looking for @ControllerAdvice: org.springframework.boot.context.embedded.AnnotationConfigEmbeddedWebApplicationContext@743885b6: startup date [Wed Sep 02 01:03:49 EDT 2015]; root of context hierarchy
  210. 2015-09-02 01:03:54.930 INFO qtp965307475-44 org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - - Mapped "{[/error],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public org.springframework.http.ResponseEntity<java.util.Map<java.lang.String, java.lang.Object>> org.springframework.boot.autoconfigure.web.BasicErrorController.error(javax.servlet.http.HttpServletRequest)
  211. 2015-09-02 01:03:54.930 INFO qtp965307475-44 org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - - Mapped "{[/error],methods=[],params=[],headers=[],consumes=[],produces=[text/html],custom=[]}" onto public org.springframework.web.servlet.ModelAndView org.springframework.boot.autoconfigure.web.BasicErrorController.errorHtml(javax.servlet.http.HttpServletRequest)
  212. 2015-09-02 01:03:54.970 INFO qtp965307475-44 org.springframework.web.servlet.handler.SimpleUrlHandlerMapping - - Mapped URL path [/webjars/**] onto handler of type [class org.springframework.web.servlet.resource.ResourceHttpRequestHandler]
  213. 2015-09-02 01:03:54.970 INFO qtp965307475-44 org.springframework.web.servlet.handler.SimpleUrlHandlerMapping - - Mapped URL path [/**] onto handler of type [class org.springframework.web.servlet.resource.ResourceHttpRequestHandler]
  214. 2015-09-02 01:03:55.022 INFO qtp965307475-44 org.springframework.web.servlet.handler.SimpleUrlHandlerMapping - - Mapped URL path [/**/favicon.ico] onto handler of type [class org.springframework.web.servlet.resource.ResourceHttpRequestHandler]
  215. 2015-09-02 01:03:55.433 INFO qtp965307475-44 org.flywaydb.core.internal.dbsupport.DbSupportFactory - - Database: jdbc:postgresql://localhost:5432/postgres (PostgreSQL 9.4)
  216. 2015-09-02 01:03:55.484 INFO qtp965307475-44 org.flywaydb.core.internal.command.DbMigrate - - Current version of schema "public": 1.0.0.3.2
  217. 2015-09-02 01:03:55.484 WARN qtp965307475-44 org.flywaydb.core.internal.command.DbMigrate - - outOfOrder mode is active. Migration of schema "public" may not be reproducible.
  218. 2015-09-02 01:03:55.485 INFO qtp965307475-44 org.flywaydb.core.internal.command.DbMigrate - - Migrating schema "public" to version 1.0.0.4
  219. 2015-09-02 01:03:55.592 INFO qtp965307475-44 org.flywaydb.core.internal.command.DbMigrate - - Migrating schema "public" to version 1.0.0.4.1
  220. 2015-09-02 01:03:55.594 INFO qtp965307475-44 org.flywaydb.core.internal.dbsupport.JdbcTemplate - - DB: table "heracles_heel_results" does not exist, skipping
  221. 2015-09-02 01:03:55.607 INFO qtp965307475-44 org.flywaydb.core.internal.command.DbMigrate - - Migrating schema "public" to version 1.0.0.4.3
  222. 2015-09-02 01:03:55.628 INFO qtp965307475-44 org.flywaydb.core.internal.command.DbMigrate - - Migrating schema "public" to version 1.0.0.5
  223. 2015-09-02 01:03:55.638 ERROR qtp965307475-44 org.flywaydb.core.internal.command.DbMigrate - - Migration of schema "public" to version 1.0.0.5 failed! Changes successfully rolled back.
  224. 2015-09-02 01:03:55.640 WARN qtp965307475-44 org.springframework.boot.context.embedded.AnnotationConfigEmbeddedWebApplicationContext - - Exception encountered during context initialization - cancelling refresh attempt
  225. org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flyway' defined in class path resource [org/springframework/boot/autoconfigure/flyway/FlywayAutoConfiguration$FlywayConfiguration.class]: Invocation of init method failed; nested exception is org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException:
  226. Migration V1.0.0.5__feasability_tables.sql failed
  227. -------------------------------------------------
  228. SQL State : 42P01
  229. Error Code : 0
  230. Message : ERROR: relation "cohort_definition" does not exist
  231. Location : db/migration/postgresql/V1.0.0.5__feasability_tables.sql (/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/classes/db/migration/postgresql/V1.0.0.5__feasability_tables.sql)
  232. Line : 13
  233. Statement : CREATE TABLE IF NOT EXISTS feasibility_study(
  234. id int NOT NULL,
  235. name varchar(255) NOT NULL,
  236. description varchar(1000) NULL,
  237. index_def_id int NULL,
  238. result_def_id int NULL,
  239. generate_info_id int NULL,
  240. created_by varchar(255) NULL,
  241. created_date Timestamp(3) NULL,
  242. modified_by varchar(255) NULL,
  243. modified_date Timestamp(3) NULL,
  244. CONSTRAINT PK_clinical_trial_protocol PRIMARY KEY (id),
  245. CONSTRAINT FK_feasibility_study_cohort_definition_index FOREIGN KEY(index_def_id)
  246. REFERENCES cohort_definition (id),
  247. CONSTRAINT FK_feasibility_study_cohort_definition_result FOREIGN KEY(result_def_id)
  248. REFERENCES cohort_definition (id),
  249. CONSTRAINT FK_feasibility_study_feas_study_generation_info FOREIGN KEY(generate_info_id)
  250. REFERENCES feas_study_generation_info (study_id)
  251. )
  252.  
  253. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1566)
  254. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539)
  255. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
  256. at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
  257. at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
  258. at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
  259. at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
  260. at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:762)
  261. at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:757)
  262. at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:480)
  263. at org.springframework.boot.context.embedded.EmbeddedWebApplicationContext.refresh(EmbeddedWebApplicationContext.java:118)
  264. at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:691)
  265. at org.springframework.boot.SpringApplication.run(SpringApplication.java:321)
  266. at org.springframework.boot.context.web.SpringBootServletInitializer.run(SpringBootServletInitializer.java:117)
  267. at org.springframework.boot.context.web.SpringBootServletInitializer.createRootApplicationContext(SpringBootServletInitializer.java:108)
  268. at org.springframework.boot.context.web.SpringBootServletInitializer.onStartup(SpringBootServletInitializer.java:68)
  269. at org.springframework.web.SpringServletContainerInitializer.onStartup(SpringServletContainerInitializer.java:175)
  270. at org.eclipse.jetty.plus.annotation.ContainerInitializer.callStartup(ContainerInitializer.java:140)
  271. at org.eclipse.jetty.annotations.ServletContainerInitializersStarter.doStart(ServletContainerInitializersStarter.java:65)
  272. at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
  273. at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:274)
  274. at org.eclipse.jetty.webapp.WebAppContext.startWebapp(WebAppContext.java:1343)
  275. at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1336)
  276. at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:741)
  277. at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:499)
  278. at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
  279. at org.ohdsi.olympus.model.WebApiService.start(WebApiService.java:200)
  280. at org.ohdsi.olympus.controller.WebApiController.start(WebApiController.java:232)
  281. at org.ohdsi.olympus.controller.WebApiController.handleStartSubmission(WebApiController.java:209)
  282. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  283. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  284. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  285. at java.lang.reflect.Method.invoke(Method.java:497)
  286. at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)
  287. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:137)
  288. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110)
  289. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:777)
  290. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:706)
  291. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
  292. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:943)
  293. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:877)
  294. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:966)
  295. at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:868)
  296. at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
  297. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:842)
  298. at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
  299. at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:800)
  300. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1669)
  301. at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:77)
  302. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  303. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
  304. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
  305. at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)
  306. at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)
  307. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  308. at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
  309. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  310. at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)
  311. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  312. at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
  313. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  314. at org.springframework.security.web.authentication.rememberme.RememberMeAuthenticationFilter.doFilter(RememberMeAuthenticationFilter.java:146)
  315. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  316. at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:154)
  317. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  318. at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
  319. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  320. at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:199)
  321. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  322. at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:110)
  323. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  324. at org.springframework.security.web.csrf.CsrfFilter.doFilterInternal(CsrfFilter.java:105)
  325. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  326. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  327. at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
  328. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  329. at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:50)
  330. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  331. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  332. at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)
  333. at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)
  334. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
  335. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
  336. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  337. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
  338. at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:585)
  339. at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
  340. at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:577)
  341. at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:223)
  342. at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1125)
  343. at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515)
  344. at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
  345. at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1059)
  346. at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
  347. at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:215)
  348. at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
  349. at org.eclipse.jetty.server.Server.handle(Server.java:497)
  350. at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:310)
  351. at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:248)
  352. at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540)
  353. at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:620)
  354. at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:540)
  355. at java.lang.Thread.run(Thread.java:745)
  356. Caused by: org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException:
  357. Migration V1.0.0.5__feasability_tables.sql failed
  358. -------------------------------------------------
  359. SQL State : 42P01
  360. Error Code : 0
  361. Message : ERROR: relation "cohort_definition" does not exist
  362. Location : db/migration/postgresql/V1.0.0.5__feasability_tables.sql (/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/classes/db/migration/postgresql/V1.0.0.5__feasability_tables.sql)
  363. Line : 13
  364. Statement : CREATE TABLE IF NOT EXISTS feasibility_study(
  365. id int NOT NULL,
  366. name varchar(255) NOT NULL,
  367. description varchar(1000) NULL,
  368. index_def_id int NULL,
  369. result_def_id int NULL,
  370. generate_info_id int NULL,
  371. created_by varchar(255) NULL,
  372. created_date Timestamp(3) NULL,
  373. modified_by varchar(255) NULL,
  374. modified_date Timestamp(3) NULL,
  375. CONSTRAINT PK_clinical_trial_protocol PRIMARY KEY (id),
  376. CONSTRAINT FK_feasibility_study_cohort_definition_index FOREIGN KEY(index_def_id)
  377. REFERENCES cohort_definition (id),
  378. CONSTRAINT FK_feasibility_study_cohort_definition_result FOREIGN KEY(result_def_id)
  379. REFERENCES cohort_definition (id),
  380. CONSTRAINT FK_feasibility_study_feas_study_generation_info FOREIGN KEY(generate_info_id)
  381. REFERENCES feas_study_generation_info (study_id)
  382. )
  383.  
  384. at org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java:117)
  385. at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.execute(SqlMigrationExecutor.java:71)
  386. at org.flywaydb.core.internal.command.DbMigrate$5.doInTransaction(DbMigrate.java:287)
  387. at org.flywaydb.core.internal.command.DbMigrate$5.doInTransaction(DbMigrate.java:285)
  388. at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72)
  389. at org.flywaydb.core.internal.command.DbMigrate.applyMigration(DbMigrate.java:285)
  390. at org.flywaydb.core.internal.command.DbMigrate.access$800(DbMigrate.java:46)
  391. at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:207)
  392. at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:156)
  393. at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72)
  394. at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:156)
  395. at org.flywaydb.core.Flyway$1.execute(Flyway.java:972)
  396. at org.flywaydb.core.Flyway$1.execute(Flyway.java:919)
  397. at org.flywaydb.core.Flyway.execute(Flyway.java:1320)
  398. at org.flywaydb.core.Flyway.migrate(Flyway.java:919)
  399. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  400. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  401. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  402. at java.lang.reflect.Method.invoke(Method.java:497)
  403. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1694)
  404. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1633)
  405. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1562)
  406. ... 102 more
  407. Caused by: org.postgresql.util.PSQLException: ERROR: relation "cohort_definition" does not exist
  408. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)
  409. at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
  410. at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
  411. at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
  412. at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
  413. at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:366)
  414. at org.flywaydb.core.internal.dbsupport.JdbcTemplate.executeStatement(JdbcTemplate.java:238)
  415. at org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java:114)
  416. ... 123 more
  417. 2015-09-02 01:03:55.646 INFO qtp965307475-44 org.springframework.scheduling.concurrent.ThreadPoolTaskExecutor - - Shutting down ExecutorService 'taskExecutor'
  418. 2015-09-02 01:03:55.652 INFO qtp965307475-44 org.springframework.scheduling.concurrent.ThreadPoolTaskScheduler - - Shutting down ExecutorService 'taskScheduler'
  419. 2015-09-02 01:03:55.652 INFO qtp965307475-44 org.springframework.integration.monitor.IntegrationMBeanExporter - - Unregistering JMX-exposed beans on shutdown
  420. 2015-09-02 01:03:55.653 INFO qtp965307475-44 org.springframework.beans.factory.config.PropertiesFactoryBean - - Loading properties file from URL [jar:file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-integration-core-4.1.1.RELEASE.jar!/META-INF/spring.integration.default.properties]
  421. 2015-09-02 01:03:55.654 INFO qtp965307475-44 org.springframework.scheduling.concurrent.ThreadPoolTaskScheduler - - Initializing ExecutorService 'taskScheduler'
  422. 2015-09-02 01:03:55.656 INFO qtp965307475-44 org.springframework.boot.logging.ClasspathLoggingApplicationListener - - Application failed to start with classpath: [file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/classes/, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/antlr-2.7.7.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/aopalliance-1.0.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/aopalliance-repackaged-2.4.0-b06.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/asm-all-repackaged-2.4.0-b06.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/aspectjrt-1.8.4.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/aspectjweaver-1.8.4.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/bean-validator-2.4.0-b06.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/class-model-2.4.0-b06.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/classmate-1.0.0.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/com.ibm.jbatch-tck-spi-1.0.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/commons-collections-3.2.1.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/commons-dbutils-1.6.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/commons-fileupload-1.3.1.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/commons-io-2.4.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/commons-lang-2.6.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/commons-lang3-3.3.2.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/commons-logging-1.2.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/config-types-2.4.0-b06.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/core-2.4.0-b06.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/disruptor-3.2.1.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/dom4j-1.6.1.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/flyway-core-3.1.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/gs-collections-5.1.0.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/gs-collections-api-5.1.0.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/hibernate-commons-annotations-4.0.5.Final.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/hibernate-core-4.3.7.Final.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/hibernate-entitymanager-4.3.7.Final.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/hibernate-jpa-2.1-api-1.0.0.Final.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/hibernate-validator-5.1.3.Final.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/hk2-2.4.0-b06.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/hk2-api-2.4.0-b06.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/hk2-config-2.4.0-b06.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/hk2-locator-2.4.0-b06.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/hk2-runlevel-2.4.0-b06.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/hk2-utils-2.4.0-b06.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/jackson-annotations-2.4.4.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/jackson-core-2.4.4.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/jackson-databind-2.4.4.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/jackson-jaxrs-base-2.3.2.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/jackson-jaxrs-json-provider-2.3.2.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/jackson-module-jaxb-annotations-2.3.2.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/jandex-1.1.0.Final.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/javassist-3.18.1-GA.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/javax.annotation-api-1.2.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/javax.batch-api-1.0.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/javax.inject-2.4.0-b06.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/javax.transaction-api-1.2.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/javax.ws.rs-api-2.0.1.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/jboss-logging-3.1.3.GA.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/jboss-logging-annotations-1.2.0.Beta1.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/jcl-over-slf4j-1.7.8.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/jersey-client-2.14.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/jersey-common-2.14.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/jersey-container-servlet-2.14.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/jersey-container-servlet-core-2.14.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/jersey-guava-2.14.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/jersey-media-json-jackson-2.14.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/jersey-server-2.14.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/jersey-spring3-2.14.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/jettison-1.2.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/joda-time-2.5.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/json-path-0.9.1.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/json-smart-1.2.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/jsr166e-1.0.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/jul-to-slf4j-1.7.8.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/log4j-1.2.17.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/objenesis-2.1.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/osgi-resource-locator-1.0.1.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/reactor-core-1.1.5.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/slf4j-api-1.7.8.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/slf4j-log4j12-1.7.8.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/snakeyaml-1.14.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-aop-4.1.4.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-aspects-4.1.4.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-batch-admin-domain-2.0.0.M1.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-batch-admin-manager-2.0.0.M1.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-batch-admin-resources-2.0.0.M1.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-batch-core-3.0.3.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-batch-infrastructure-3.0.2.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-batch-integration-3.0.2.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-beans-4.1.4.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-boot-1.2.1.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-boot-autoconfigure-1.2.1.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-boot-starter-1.2.1.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-boot-starter-aop-1.2.1.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-boot-starter-data-jpa-1.2.1.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-boot-starter-jdbc-1.2.1.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-boot-starter-jersey-1.2.1.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-boot-starter-log4j-1.2.1.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-boot-starter-web-1.2.1.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-bridge-2.4.0-b06.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-context-4.1.4.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-context-support-4.1.4.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-core-4.1.4.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-data-commons-1.9.1.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-data-jpa-1.7.1.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-expression-4.1.4.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-hateoas-0.16.0.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-integration-core-4.1.1.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-integration-file-4.1.1.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-integration-http-4.1.1.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-integration-jmx-4.1.1.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-jdbc-4.1.4.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-messaging-4.1.4.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-orm-4.1.4.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-oxm-4.1.4.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-plugin-core-1.1.0.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-retry-1.1.0.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-tx-4.1.4.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-web-4.1.4.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/spring-webmvc-4.1.4.RELEASE.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/SqlRender-1.0.0-20150715.141736-41.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/tiger-types-1.4.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/tomcat-jdbc-8.0.15.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/tomcat-juli-8.0.15.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/validation-api-1.1.0.Final.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/xml-apis-1.0.b2.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/xmlpull-1.1.3.1.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/xpp3_min-1.1.4c.jar, file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/lib/xstream-1.4.7.jar]
  423. 2015-09-02 01:03:55.657 INFO qtp965307475-44 org.springframework.boot.autoconfigure.logging.AutoConfigurationReportLoggingInitializer - -
  424.  
  425. Error starting ApplicationContext. To display the auto-configuration report enabled debug logging (start with --debug)
  426.  
  427.  
  428. 2015-09-02 01:03:55.658 ERROR qtp965307475-44 org.springframework.boot.SpringApplication - - Application startup failed
  429. org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flyway' defined in class path resource [org/springframework/boot/autoconfigure/flyway/FlywayAutoConfiguration$FlywayConfiguration.class]: Invocation of init method failed; nested exception is org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException:
  430. Migration V1.0.0.5__feasability_tables.sql failed
  431. -------------------------------------------------
  432. SQL State : 42P01
  433. Error Code : 0
  434. Message : ERROR: relation "cohort_definition" does not exist
  435. Location : db/migration/postgresql/V1.0.0.5__feasability_tables.sql (/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/classes/db/migration/postgresql/V1.0.0.5__feasability_tables.sql)
  436. Line : 13
  437. Statement : CREATE TABLE IF NOT EXISTS feasibility_study(
  438. id int NOT NULL,
  439. name varchar(255) NOT NULL,
  440. description varchar(1000) NULL,
  441. index_def_id int NULL,
  442. result_def_id int NULL,
  443. generate_info_id int NULL,
  444. created_by varchar(255) NULL,
  445. created_date Timestamp(3) NULL,
  446. modified_by varchar(255) NULL,
  447. modified_date Timestamp(3) NULL,
  448. CONSTRAINT PK_clinical_trial_protocol PRIMARY KEY (id),
  449. CONSTRAINT FK_feasibility_study_cohort_definition_index FOREIGN KEY(index_def_id)
  450. REFERENCES cohort_definition (id),
  451. CONSTRAINT FK_feasibility_study_cohort_definition_result FOREIGN KEY(result_def_id)
  452. REFERENCES cohort_definition (id),
  453. CONSTRAINT FK_feasibility_study_feas_study_generation_info FOREIGN KEY(generate_info_id)
  454. REFERENCES feas_study_generation_info (study_id)
  455. )
  456.  
  457. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1566)
  458. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539)
  459. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
  460. at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
  461. at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
  462. at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
  463. at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
  464. at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:762)
  465. at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:757)
  466. at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:480)
  467. at org.springframework.boot.context.embedded.EmbeddedWebApplicationContext.refresh(EmbeddedWebApplicationContext.java:118)
  468. at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:691)
  469. at org.springframework.boot.SpringApplication.run(SpringApplication.java:321)
  470. at org.springframework.boot.context.web.SpringBootServletInitializer.run(SpringBootServletInitializer.java:117)
  471. at org.springframework.boot.context.web.SpringBootServletInitializer.createRootApplicationContext(SpringBootServletInitializer.java:108)
  472. at org.springframework.boot.context.web.SpringBootServletInitializer.onStartup(SpringBootServletInitializer.java:68)
  473. at org.springframework.web.SpringServletContainerInitializer.onStartup(SpringServletContainerInitializer.java:175)
  474. at org.eclipse.jetty.plus.annotation.ContainerInitializer.callStartup(ContainerInitializer.java:140)
  475. at org.eclipse.jetty.annotations.ServletContainerInitializersStarter.doStart(ServletContainerInitializersStarter.java:65)
  476. at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
  477. at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:274)
  478. at org.eclipse.jetty.webapp.WebAppContext.startWebapp(WebAppContext.java:1343)
  479. at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1336)
  480. at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:741)
  481. at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:499)
  482. at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
  483. at org.ohdsi.olympus.model.WebApiService.start(WebApiService.java:200)
  484. at org.ohdsi.olympus.controller.WebApiController.start(WebApiController.java:232)
  485. at org.ohdsi.olympus.controller.WebApiController.handleStartSubmission(WebApiController.java:209)
  486. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  487. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  488. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  489. at java.lang.reflect.Method.invoke(Method.java:497)
  490. at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)
  491. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:137)
  492. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110)
  493. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:777)
  494. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:706)
  495. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
  496. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:943)
  497. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:877)
  498. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:966)
  499. at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:868)
  500. at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
  501. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:842)
  502. at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
  503. at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:800)
  504. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1669)
  505. at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:77)
  506. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  507. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
  508. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
  509. at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)
  510. at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)
  511. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  512. at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
  513. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  514. at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)
  515. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  516. at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
  517. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  518. at org.springframework.security.web.authentication.rememberme.RememberMeAuthenticationFilter.doFilter(RememberMeAuthenticationFilter.java:146)
  519. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  520. at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:154)
  521. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  522. at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
  523. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  524. at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:199)
  525. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  526. at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:110)
  527. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  528. at org.springframework.security.web.csrf.CsrfFilter.doFilterInternal(CsrfFilter.java:105)
  529. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  530. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  531. at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
  532. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  533. at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:50)
  534. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  535. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  536. at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)
  537. at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)
  538. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
  539. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
  540. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  541. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
  542. at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:585)
  543. at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
  544. at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:577)
  545. at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:223)
  546. at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1125)
  547. at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515)
  548. at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
  549. at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1059)
  550. at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
  551. at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:215)
  552. at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
  553. at org.eclipse.jetty.server.Server.handle(Server.java:497)
  554. at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:310)
  555. at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:248)
  556. at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540)
  557. at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:620)
  558. at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:540)
  559. at java.lang.Thread.run(Thread.java:745)
  560. Caused by: org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException:
  561. Migration V1.0.0.5__feasability_tables.sql failed
  562. -------------------------------------------------
  563. SQL State : 42P01
  564. Error Code : 0
  565. Message : ERROR: relation "cohort_definition" does not exist
  566. Location : db/migration/postgresql/V1.0.0.5__feasability_tables.sql (/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/classes/db/migration/postgresql/V1.0.0.5__feasability_tables.sql)
  567. Line : 13
  568. Statement : CREATE TABLE IF NOT EXISTS feasibility_study(
  569. id int NOT NULL,
  570. name varchar(255) NOT NULL,
  571. description varchar(1000) NULL,
  572. index_def_id int NULL,
  573. result_def_id int NULL,
  574. generate_info_id int NULL,
  575. created_by varchar(255) NULL,
  576. created_date Timestamp(3) NULL,
  577. modified_by varchar(255) NULL,
  578. modified_date Timestamp(3) NULL,
  579. CONSTRAINT PK_clinical_trial_protocol PRIMARY KEY (id),
  580. CONSTRAINT FK_feasibility_study_cohort_definition_index FOREIGN KEY(index_def_id)
  581. REFERENCES cohort_definition (id),
  582. CONSTRAINT FK_feasibility_study_cohort_definition_result FOREIGN KEY(result_def_id)
  583. REFERENCES cohort_definition (id),
  584. CONSTRAINT FK_feasibility_study_feas_study_generation_info FOREIGN KEY(generate_info_id)
  585. REFERENCES feas_study_generation_info (study_id)
  586. )
  587.  
  588. at org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java:117)
  589. at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.execute(SqlMigrationExecutor.java:71)
  590. at org.flywaydb.core.internal.command.DbMigrate$5.doInTransaction(DbMigrate.java:287)
  591. at org.flywaydb.core.internal.command.DbMigrate$5.doInTransaction(DbMigrate.java:285)
  592. at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72)
  593. at org.flywaydb.core.internal.command.DbMigrate.applyMigration(DbMigrate.java:285)
  594. at org.flywaydb.core.internal.command.DbMigrate.access$800(DbMigrate.java:46)
  595. at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:207)
  596. at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:156)
  597. at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72)
  598. at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:156)
  599. at org.flywaydb.core.Flyway$1.execute(Flyway.java:972)
  600. at org.flywaydb.core.Flyway$1.execute(Flyway.java:919)
  601. at org.flywaydb.core.Flyway.execute(Flyway.java:1320)
  602. at org.flywaydb.core.Flyway.migrate(Flyway.java:919)
  603. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  604. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  605. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  606. at java.lang.reflect.Method.invoke(Method.java:497)
  607. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1694)
  608. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1633)
  609. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1562)
  610. ... 102 more
  611. Caused by: org.postgresql.util.PSQLException: ERROR: relation "cohort_definition" does not exist
  612. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)
  613. at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
  614. at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
  615. at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
  616. at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
  617. at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:366)
  618. at org.flywaydb.core.internal.dbsupport.JdbcTemplate.executeStatement(JdbcTemplate.java:238)
  619. at org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java:114)
  620. ... 123 more
  621. 2015-09-02 01:03:55.660 WARN qtp965307475-44 org.eclipse.jetty.annotations.ServletContainerInitializersStarter - -
  622. org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flyway' defined in class path resource [org/springframework/boot/autoconfigure/flyway/FlywayAutoConfiguration$FlywayConfiguration.class]: Invocation of init method failed; nested exception is org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException:
  623. Migration V1.0.0.5__feasability_tables.sql failed
  624. -------------------------------------------------
  625. SQL State : 42P01
  626. Error Code : 0
  627. Message : ERROR: relation "cohort_definition" does not exist
  628. Location : db/migration/postgresql/V1.0.0.5__feasability_tables.sql (/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/classes/db/migration/postgresql/V1.0.0.5__feasability_tables.sql)
  629. Line : 13
  630. Statement : CREATE TABLE IF NOT EXISTS feasibility_study(
  631. id int NOT NULL,
  632. name varchar(255) NOT NULL,
  633. description varchar(1000) NULL,
  634. index_def_id int NULL,
  635. result_def_id int NULL,
  636. generate_info_id int NULL,
  637. created_by varchar(255) NULL,
  638. created_date Timestamp(3) NULL,
  639. modified_by varchar(255) NULL,
  640. modified_date Timestamp(3) NULL,
  641. CONSTRAINT PK_clinical_trial_protocol PRIMARY KEY (id),
  642. CONSTRAINT FK_feasibility_study_cohort_definition_index FOREIGN KEY(index_def_id)
  643. REFERENCES cohort_definition (id),
  644. CONSTRAINT FK_feasibility_study_cohort_definition_result FOREIGN KEY(result_def_id)
  645. REFERENCES cohort_definition (id),
  646. CONSTRAINT FK_feasibility_study_feas_study_generation_info FOREIGN KEY(generate_info_id)
  647. REFERENCES feas_study_generation_info (study_id)
  648. )
  649.  
  650. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1566)
  651. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539)
  652. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
  653. at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
  654. at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
  655. at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
  656. at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
  657. at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:762)
  658. at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:757)
  659. at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:480)
  660. at org.springframework.boot.context.embedded.EmbeddedWebApplicationContext.refresh(EmbeddedWebApplicationContext.java:118)
  661. at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:691)
  662. at org.springframework.boot.SpringApplication.run(SpringApplication.java:321)
  663. at org.springframework.boot.context.web.SpringBootServletInitializer.run(SpringBootServletInitializer.java:117)
  664. at org.springframework.boot.context.web.SpringBootServletInitializer.createRootApplicationContext(SpringBootServletInitializer.java:108)
  665. at org.springframework.boot.context.web.SpringBootServletInitializer.onStartup(SpringBootServletInitializer.java:68)
  666. at org.springframework.web.SpringServletContainerInitializer.onStartup(SpringServletContainerInitializer.java:175)
  667. at org.eclipse.jetty.plus.annotation.ContainerInitializer.callStartup(ContainerInitializer.java:140)
  668. at org.eclipse.jetty.annotations.ServletContainerInitializersStarter.doStart(ServletContainerInitializersStarter.java:65)
  669. at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
  670. at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:274)
  671. at org.eclipse.jetty.webapp.WebAppContext.startWebapp(WebAppContext.java:1343)
  672. at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1336)
  673. at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:741)
  674. at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:499)
  675. at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
  676. at org.ohdsi.olympus.model.WebApiService.start(WebApiService.java:200)
  677. at org.ohdsi.olympus.controller.WebApiController.start(WebApiController.java:232)
  678. at org.ohdsi.olympus.controller.WebApiController.handleStartSubmission(WebApiController.java:209)
  679. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  680. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  681. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  682. at java.lang.reflect.Method.invoke(Method.java:497)
  683. at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)
  684. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:137)
  685. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110)
  686. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:777)
  687. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:706)
  688. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
  689. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:943)
  690. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:877)
  691. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:966)
  692. at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:868)
  693. at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
  694. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:842)
  695. at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
  696. at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:800)
  697. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1669)
  698. at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:77)
  699. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  700. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
  701. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
  702. at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)
  703. at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)
  704. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  705. at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
  706. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  707. at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)
  708. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  709. at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
  710. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  711. at org.springframework.security.web.authentication.rememberme.RememberMeAuthenticationFilter.doFilter(RememberMeAuthenticationFilter.java:146)
  712. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  713. at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:154)
  714. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  715. at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
  716. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  717. at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:199)
  718. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  719. at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:110)
  720. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  721. at org.springframework.security.web.csrf.CsrfFilter.doFilterInternal(CsrfFilter.java:105)
  722. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  723. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  724. at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
  725. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  726. at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:50)
  727. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  728. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  729. at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)
  730. at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)
  731. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
  732. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
  733. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  734. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
  735. at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:585)
  736. at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
  737. at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:577)
  738. at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:223)
  739. at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1125)
  740. at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515)
  741. at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
  742. at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1059)
  743. at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
  744. at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:215)
  745. at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
  746. at org.eclipse.jetty.server.Server.handle(Server.java:497)
  747. at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:310)
  748. at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:248)
  749. at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540)
  750. at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:620)
  751. at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:540)
  752. at java.lang.Thread.run(Thread.java:745)
  753. Caused by: org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException:
  754. Migration V1.0.0.5__feasability_tables.sql failed
  755. -------------------------------------------------
  756. SQL State : 42P01
  757. Error Code : 0
  758. Message : ERROR: relation "cohort_definition" does not exist
  759. Location : db/migration/postgresql/V1.0.0.5__feasability_tables.sql (/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/classes/db/migration/postgresql/V1.0.0.5__feasability_tables.sql)
  760. Line : 13
  761. Statement : CREATE TABLE IF NOT EXISTS feasibility_study(
  762. id int NOT NULL,
  763. name varchar(255) NOT NULL,
  764. description varchar(1000) NULL,
  765. index_def_id int NULL,
  766. result_def_id int NULL,
  767. generate_info_id int NULL,
  768. created_by varchar(255) NULL,
  769. created_date Timestamp(3) NULL,
  770. modified_by varchar(255) NULL,
  771. modified_date Timestamp(3) NULL,
  772. CONSTRAINT PK_clinical_trial_protocol PRIMARY KEY (id),
  773. CONSTRAINT FK_feasibility_study_cohort_definition_index FOREIGN KEY(index_def_id)
  774. REFERENCES cohort_definition (id),
  775. CONSTRAINT FK_feasibility_study_cohort_definition_result FOREIGN KEY(result_def_id)
  776. REFERENCES cohort_definition (id),
  777. CONSTRAINT FK_feasibility_study_feas_study_generation_info FOREIGN KEY(generate_info_id)
  778. REFERENCES feas_study_generation_info (study_id)
  779. )
  780.  
  781. at org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java:117)
  782. at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.execute(SqlMigrationExecutor.java:71)
  783. at org.flywaydb.core.internal.command.DbMigrate$5.doInTransaction(DbMigrate.java:287)
  784. at org.flywaydb.core.internal.command.DbMigrate$5.doInTransaction(DbMigrate.java:285)
  785. at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72)
  786. at org.flywaydb.core.internal.command.DbMigrate.applyMigration(DbMigrate.java:285)
  787. at org.flywaydb.core.internal.command.DbMigrate.access$800(DbMigrate.java:46)
  788. at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:207)
  789. at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:156)
  790. at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72)
  791. at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:156)
  792. at org.flywaydb.core.Flyway$1.execute(Flyway.java:972)
  793. at org.flywaydb.core.Flyway$1.execute(Flyway.java:919)
  794. at org.flywaydb.core.Flyway.execute(Flyway.java:1320)
  795. at org.flywaydb.core.Flyway.migrate(Flyway.java:919)
  796. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  797. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  798. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  799. at java.lang.reflect.Method.invoke(Method.java:497)
  800. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1694)
  801. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1633)
  802. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1562)
  803. ... 102 more
  804. Caused by: org.postgresql.util.PSQLException: ERROR: relation "cohort_definition" does not exist
  805. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)
  806. at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
  807. at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
  808. at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
  809. at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
  810. at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:366)
  811. at org.flywaydb.core.internal.dbsupport.JdbcTemplate.executeStatement(JdbcTemplate.java:238)
  812. at org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java:114)
  813. ... 123 more
  814. 2015-09-02 01:03:55.663 WARN qtp965307475-44 org.eclipse.jetty.util.component.AbstractLifeCycle - - FAILED org.eclipse.jetty.annotations.ServletContainerInitializersStarter@5be2289d: java.lang.RuntimeException: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flyway' defined in class path resource [org/springframework/boot/autoconfigure/flyway/FlywayAutoConfiguration$FlywayConfiguration.class]: Invocation of init method failed; nested exception is org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException:
  815. Migration V1.0.0.5__feasability_tables.sql failed
  816. -------------------------------------------------
  817. SQL State : 42P01
  818. Error Code : 0
  819. Message : ERROR: relation "cohort_definition" does not exist
  820. Location : db/migration/postgresql/V1.0.0.5__feasability_tables.sql (/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/classes/db/migration/postgresql/V1.0.0.5__feasability_tables.sql)
  821. Line : 13
  822. Statement : CREATE TABLE IF NOT EXISTS feasibility_study(
  823. id int NOT NULL,
  824. name varchar(255) NOT NULL,
  825. description varchar(1000) NULL,
  826. index_def_id int NULL,
  827. result_def_id int NULL,
  828. generate_info_id int NULL,
  829. created_by varchar(255) NULL,
  830. created_date Timestamp(3) NULL,
  831. modified_by varchar(255) NULL,
  832. modified_date Timestamp(3) NULL,
  833. CONSTRAINT PK_clinical_trial_protocol PRIMARY KEY (id),
  834. CONSTRAINT FK_feasibility_study_cohort_definition_index FOREIGN KEY(index_def_id)
  835. REFERENCES cohort_definition (id),
  836. CONSTRAINT FK_feasibility_study_cohort_definition_result FOREIGN KEY(result_def_id)
  837. REFERENCES cohort_definition (id),
  838. CONSTRAINT FK_feasibility_study_feas_study_generation_info FOREIGN KEY(generate_info_id)
  839. REFERENCES feas_study_generation_info (study_id)
  840. )
  841.  
  842. java.lang.RuntimeException: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flyway' defined in class path resource [org/springframework/boot/autoconfigure/flyway/FlywayAutoConfiguration$FlywayConfiguration.class]: Invocation of init method failed; nested exception is org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException:
  843. Migration V1.0.0.5__feasability_tables.sql failed
  844. -------------------------------------------------
  845. SQL State : 42P01
  846. Error Code : 0
  847. Message : ERROR: relation "cohort_definition" does not exist
  848. Location : db/migration/postgresql/V1.0.0.5__feasability_tables.sql (/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/classes/db/migration/postgresql/V1.0.0.5__feasability_tables.sql)
  849. Line : 13
  850. Statement : CREATE TABLE IF NOT EXISTS feasibility_study(
  851. id int NOT NULL,
  852. name varchar(255) NOT NULL,
  853. description varchar(1000) NULL,
  854. index_def_id int NULL,
  855. result_def_id int NULL,
  856. generate_info_id int NULL,
  857. created_by varchar(255) NULL,
  858. created_date Timestamp(3) NULL,
  859. modified_by varchar(255) NULL,
  860. modified_date Timestamp(3) NULL,
  861. CONSTRAINT PK_clinical_trial_protocol PRIMARY KEY (id),
  862. CONSTRAINT FK_feasibility_study_cohort_definition_index FOREIGN KEY(index_def_id)
  863. REFERENCES cohort_definition (id),
  864. CONSTRAINT FK_feasibility_study_cohort_definition_result FOREIGN KEY(result_def_id)
  865. REFERENCES cohort_definition (id),
  866. CONSTRAINT FK_feasibility_study_feas_study_generation_info FOREIGN KEY(generate_info_id)
  867. REFERENCES feas_study_generation_info (study_id)
  868. )
  869.  
  870. at org.eclipse.jetty.annotations.ServletContainerInitializersStarter.doStart(ServletContainerInitializersStarter.java:70)
  871. at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
  872. at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:274)
  873. at org.eclipse.jetty.webapp.WebAppContext.startWebapp(WebAppContext.java:1343)
  874. at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1336)
  875. at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:741)
  876. at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:499)
  877. at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
  878. at org.ohdsi.olympus.model.WebApiService.start(WebApiService.java:200)
  879. at org.ohdsi.olympus.controller.WebApiController.start(WebApiController.java:232)
  880. at org.ohdsi.olympus.controller.WebApiController.handleStartSubmission(WebApiController.java:209)
  881. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  882. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  883. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  884. at java.lang.reflect.Method.invoke(Method.java:497)
  885. at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)
  886. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:137)
  887. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110)
  888. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:777)
  889. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:706)
  890. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
  891. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:943)
  892. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:877)
  893. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:966)
  894. at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:868)
  895. at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
  896. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:842)
  897. at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
  898. at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:800)
  899. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1669)
  900. at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:77)
  901. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  902. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
  903. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
  904. at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)
  905. at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)
  906. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  907. at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
  908. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  909. at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)
  910. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  911. at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
  912. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  913. at org.springframework.security.web.authentication.rememberme.RememberMeAuthenticationFilter.doFilter(RememberMeAuthenticationFilter.java:146)
  914. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  915. at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:154)
  916. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  917. at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
  918. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  919. at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:199)
  920. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  921. at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:110)
  922. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  923. at org.springframework.security.web.csrf.CsrfFilter.doFilterInternal(CsrfFilter.java:105)
  924. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  925. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  926. at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
  927. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  928. at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:50)
  929. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  930. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  931. at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)
  932. at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)
  933. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
  934. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
  935. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  936. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
  937. at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:585)
  938. at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
  939. at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:577)
  940. at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:223)
  941. at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1125)
  942. at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515)
  943. at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
  944. at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1059)
  945. at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
  946. at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:215)
  947. at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
  948. at org.eclipse.jetty.server.Server.handle(Server.java:497)
  949. at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:310)
  950. at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:248)
  951. at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540)
  952. at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:620)
  953. at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:540)
  954. at java.lang.Thread.run(Thread.java:745)
  955. Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flyway' defined in class path resource [org/springframework/boot/autoconfigure/flyway/FlywayAutoConfiguration$FlywayConfiguration.class]: Invocation of init method failed; nested exception is org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException:
  956. Migration V1.0.0.5__feasability_tables.sql failed
  957. -------------------------------------------------
  958. SQL State : 42P01
  959. Error Code : 0
  960. Message : ERROR: relation "cohort_definition" does not exist
  961. Location : db/migration/postgresql/V1.0.0.5__feasability_tables.sql (/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/classes/db/migration/postgresql/V1.0.0.5__feasability_tables.sql)
  962. Line : 13
  963. Statement : CREATE TABLE IF NOT EXISTS feasibility_study(
  964. id int NOT NULL,
  965. name varchar(255) NOT NULL,
  966. description varchar(1000) NULL,
  967. index_def_id int NULL,
  968. result_def_id int NULL,
  969. generate_info_id int NULL,
  970. created_by varchar(255) NULL,
  971. created_date Timestamp(3) NULL,
  972. modified_by varchar(255) NULL,
  973. modified_date Timestamp(3) NULL,
  974. CONSTRAINT PK_clinical_trial_protocol PRIMARY KEY (id),
  975. CONSTRAINT FK_feasibility_study_cohort_definition_index FOREIGN KEY(index_def_id)
  976. REFERENCES cohort_definition (id),
  977. CONSTRAINT FK_feasibility_study_cohort_definition_result FOREIGN KEY(result_def_id)
  978. REFERENCES cohort_definition (id),
  979. CONSTRAINT FK_feasibility_study_feas_study_generation_info FOREIGN KEY(generate_info_id)
  980. REFERENCES feas_study_generation_info (study_id)
  981. )
  982.  
  983. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1566)
  984. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539)
  985. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
  986. at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
  987. at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
  988. at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
  989. at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
  990. at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:762)
  991. at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:757)
  992. at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:480)
  993. at org.springframework.boot.context.embedded.EmbeddedWebApplicationContext.refresh(EmbeddedWebApplicationContext.java:118)
  994. at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:691)
  995. at org.springframework.boot.SpringApplication.run(SpringApplication.java:321)
  996. at org.springframework.boot.context.web.SpringBootServletInitializer.run(SpringBootServletInitializer.java:117)
  997. at org.springframework.boot.context.web.SpringBootServletInitializer.createRootApplicationContext(SpringBootServletInitializer.java:108)
  998. at org.springframework.boot.context.web.SpringBootServletInitializer.onStartup(SpringBootServletInitializer.java:68)
  999. at org.springframework.web.SpringServletContainerInitializer.onStartup(SpringServletContainerInitializer.java:175)
  1000. at org.eclipse.jetty.plus.annotation.ContainerInitializer.callStartup(ContainerInitializer.java:140)
  1001. at org.eclipse.jetty.annotations.ServletContainerInitializersStarter.doStart(ServletContainerInitializersStarter.java:65)
  1002. ... 84 more
  1003. Caused by: org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException:
  1004. Migration V1.0.0.5__feasability_tables.sql failed
  1005. -------------------------------------------------
  1006. SQL State : 42P01
  1007. Error Code : 0
  1008. Message : ERROR: relation "cohort_definition" does not exist
  1009. Location : db/migration/postgresql/V1.0.0.5__feasability_tables.sql (/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/classes/db/migration/postgresql/V1.0.0.5__feasability_tables.sql)
  1010. Line : 13
  1011. Statement : CREATE TABLE IF NOT EXISTS feasibility_study(
  1012. id int NOT NULL,
  1013. name varchar(255) NOT NULL,
  1014. description varchar(1000) NULL,
  1015. index_def_id int NULL,
  1016. result_def_id int NULL,
  1017. generate_info_id int NULL,
  1018. created_by varchar(255) NULL,
  1019. created_date Timestamp(3) NULL,
  1020. modified_by varchar(255) NULL,
  1021. modified_date Timestamp(3) NULL,
  1022. CONSTRAINT PK_clinical_trial_protocol PRIMARY KEY (id),
  1023. CONSTRAINT FK_feasibility_study_cohort_definition_index FOREIGN KEY(index_def_id)
  1024. REFERENCES cohort_definition (id),
  1025. CONSTRAINT FK_feasibility_study_cohort_definition_result FOREIGN KEY(result_def_id)
  1026. REFERENCES cohort_definition (id),
  1027. CONSTRAINT FK_feasibility_study_feas_study_generation_info FOREIGN KEY(generate_info_id)
  1028. REFERENCES feas_study_generation_info (study_id)
  1029. )
  1030.  
  1031. at org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java:117)
  1032. at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.execute(SqlMigrationExecutor.java:71)
  1033. at org.flywaydb.core.internal.command.DbMigrate$5.doInTransaction(DbMigrate.java:287)
  1034. at org.flywaydb.core.internal.command.DbMigrate$5.doInTransaction(DbMigrate.java:285)
  1035. at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72)
  1036. at org.flywaydb.core.internal.command.DbMigrate.applyMigration(DbMigrate.java:285)
  1037. at org.flywaydb.core.internal.command.DbMigrate.access$800(DbMigrate.java:46)
  1038. at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:207)
  1039. at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:156)
  1040. at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72)
  1041. at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:156)
  1042. at org.flywaydb.core.Flyway$1.execute(Flyway.java:972)
  1043. at org.flywaydb.core.Flyway$1.execute(Flyway.java:919)
  1044. at org.flywaydb.core.Flyway.execute(Flyway.java:1320)
  1045. at org.flywaydb.core.Flyway.migrate(Flyway.java:919)
  1046. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  1047. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  1048. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  1049. at java.lang.reflect.Method.invoke(Method.java:497)
  1050. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1694)
  1051. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1633)
  1052. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1562)
  1053. ... 102 more
  1054. Caused by: org.postgresql.util.PSQLException: ERROR: relation "cohort_definition" does not exist
  1055. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)
  1056. at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
  1057. at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
  1058. at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
  1059. at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
  1060. at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:366)
  1061. at org.flywaydb.core.internal.dbsupport.JdbcTemplate.executeStatement(JdbcTemplate.java:238)
  1062. at org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java:114)
  1063. ... 123 more
  1064. 2015-09-02 01:03:55.666 WARN qtp965307475-44 org.eclipse.jetty.webapp.WebAppContext - - Failed startup of context o.e.j.w.WebAppContext@5f8a03e3{/WebAPI,file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/,STARTING}{/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/olympus/WebAPI.war}
  1065. java.lang.RuntimeException: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flyway' defined in class path resource [org/springframework/boot/autoconfigure/flyway/FlywayAutoConfiguration$FlywayConfiguration.class]: Invocation of init method failed; nested exception is org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException:
  1066. Migration V1.0.0.5__feasability_tables.sql failed
  1067. -------------------------------------------------
  1068. SQL State : 42P01
  1069. Error Code : 0
  1070. Message : ERROR: relation "cohort_definition" does not exist
  1071. Location : db/migration/postgresql/V1.0.0.5__feasability_tables.sql (/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/classes/db/migration/postgresql/V1.0.0.5__feasability_tables.sql)
  1072. Line : 13
  1073. Statement : CREATE TABLE IF NOT EXISTS feasibility_study(
  1074. id int NOT NULL,
  1075. name varchar(255) NOT NULL,
  1076. description varchar(1000) NULL,
  1077. index_def_id int NULL,
  1078. result_def_id int NULL,
  1079. generate_info_id int NULL,
  1080. created_by varchar(255) NULL,
  1081. created_date Timestamp(3) NULL,
  1082. modified_by varchar(255) NULL,
  1083. modified_date Timestamp(3) NULL,
  1084. CONSTRAINT PK_clinical_trial_protocol PRIMARY KEY (id),
  1085. CONSTRAINT FK_feasibility_study_cohort_definition_index FOREIGN KEY(index_def_id)
  1086. REFERENCES cohort_definition (id),
  1087. CONSTRAINT FK_feasibility_study_cohort_definition_result FOREIGN KEY(result_def_id)
  1088. REFERENCES cohort_definition (id),
  1089. CONSTRAINT FK_feasibility_study_feas_study_generation_info FOREIGN KEY(generate_info_id)
  1090. REFERENCES feas_study_generation_info (study_id)
  1091. )
  1092.  
  1093. at org.eclipse.jetty.annotations.ServletContainerInitializersStarter.doStart(ServletContainerInitializersStarter.java:70)
  1094. at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
  1095. at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:274)
  1096. at org.eclipse.jetty.webapp.WebAppContext.startWebapp(WebAppContext.java:1343)
  1097. at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1336)
  1098. at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:741)
  1099. at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:499)
  1100. at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
  1101. at org.ohdsi.olympus.model.WebApiService.start(WebApiService.java:200)
  1102. at org.ohdsi.olympus.controller.WebApiController.start(WebApiController.java:232)
  1103. at org.ohdsi.olympus.controller.WebApiController.handleStartSubmission(WebApiController.java:209)
  1104. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  1105. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  1106. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  1107. at java.lang.reflect.Method.invoke(Method.java:497)
  1108. at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)
  1109. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:137)
  1110. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110)
  1111. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:777)
  1112. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:706)
  1113. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
  1114. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:943)
  1115. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:877)
  1116. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:966)
  1117. at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:868)
  1118. at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
  1119. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:842)
  1120. at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
  1121. at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:800)
  1122. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1669)
  1123. at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:77)
  1124. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  1125. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
  1126. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
  1127. at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)
  1128. at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)
  1129. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  1130. at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
  1131. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  1132. at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)
  1133. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  1134. at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
  1135. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  1136. at org.springframework.security.web.authentication.rememberme.RememberMeAuthenticationFilter.doFilter(RememberMeAuthenticationFilter.java:146)
  1137. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  1138. at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:154)
  1139. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  1140. at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
  1141. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  1142. at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:199)
  1143. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  1144. at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:110)
  1145. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  1146. at org.springframework.security.web.csrf.CsrfFilter.doFilterInternal(CsrfFilter.java:105)
  1147. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  1148. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  1149. at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
  1150. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  1151. at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:50)
  1152. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  1153. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  1154. at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)
  1155. at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)
  1156. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
  1157. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
  1158. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  1159. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
  1160. at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:585)
  1161. at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
  1162. at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:577)
  1163. at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:223)
  1164. at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1125)
  1165. at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515)
  1166. at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
  1167. at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1059)
  1168. at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
  1169. at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:215)
  1170. at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
  1171. at org.eclipse.jetty.server.Server.handle(Server.java:497)
  1172. at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:310)
  1173. at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:248)
  1174. at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540)
  1175. at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:620)
  1176. at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:540)
  1177. at java.lang.Thread.run(Thread.java:745)
  1178. Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flyway' defined in class path resource [org/springframework/boot/autoconfigure/flyway/FlywayAutoConfiguration$FlywayConfiguration.class]: Invocation of init method failed; nested exception is org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException:
  1179. Migration V1.0.0.5__feasability_tables.sql failed
  1180. -------------------------------------------------
  1181. SQL State : 42P01
  1182. Error Code : 0
  1183. Message : ERROR: relation "cohort_definition" does not exist
  1184. Location : db/migration/postgresql/V1.0.0.5__feasability_tables.sql (/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/classes/db/migration/postgresql/V1.0.0.5__feasability_tables.sql)
  1185. Line : 13
  1186. Statement : CREATE TABLE IF NOT EXISTS feasibility_study(
  1187. id int NOT NULL,
  1188. name varchar(255) NOT NULL,
  1189. description varchar(1000) NULL,
  1190. index_def_id int NULL,
  1191. result_def_id int NULL,
  1192. generate_info_id int NULL,
  1193. created_by varchar(255) NULL,
  1194. created_date Timestamp(3) NULL,
  1195. modified_by varchar(255) NULL,
  1196. modified_date Timestamp(3) NULL,
  1197. CONSTRAINT PK_clinical_trial_protocol PRIMARY KEY (id),
  1198. CONSTRAINT FK_feasibility_study_cohort_definition_index FOREIGN KEY(index_def_id)
  1199. REFERENCES cohort_definition (id),
  1200. CONSTRAINT FK_feasibility_study_cohort_definition_result FOREIGN KEY(result_def_id)
  1201. REFERENCES cohort_definition (id),
  1202. CONSTRAINT FK_feasibility_study_feas_study_generation_info FOREIGN KEY(generate_info_id)
  1203. REFERENCES feas_study_generation_info (study_id)
  1204. )
  1205.  
  1206. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1566)
  1207. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539)
  1208. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
  1209. at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
  1210. at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
  1211. at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
  1212. at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
  1213. at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:762)
  1214. at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:757)
  1215. at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:480)
  1216. at org.springframework.boot.context.embedded.EmbeddedWebApplicationContext.refresh(EmbeddedWebApplicationContext.java:118)
  1217. at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:691)
  1218. at org.springframework.boot.SpringApplication.run(SpringApplication.java:321)
  1219. at org.springframework.boot.context.web.SpringBootServletInitializer.run(SpringBootServletInitializer.java:117)
  1220. at org.springframework.boot.context.web.SpringBootServletInitializer.createRootApplicationContext(SpringBootServletInitializer.java:108)
  1221. at org.springframework.boot.context.web.SpringBootServletInitializer.onStartup(SpringBootServletInitializer.java:68)
  1222. at org.springframework.web.SpringServletContainerInitializer.onStartup(SpringServletContainerInitializer.java:175)
  1223. at org.eclipse.jetty.plus.annotation.ContainerInitializer.callStartup(ContainerInitializer.java:140)
  1224. at org.eclipse.jetty.annotations.ServletContainerInitializersStarter.doStart(ServletContainerInitializersStarter.java:65)
  1225. ... 84 more
  1226. Caused by: org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException:
  1227. Migration V1.0.0.5__feasability_tables.sql failed
  1228. -------------------------------------------------
  1229. SQL State : 42P01
  1230. Error Code : 0
  1231. Message : ERROR: relation "cohort_definition" does not exist
  1232. Location : db/migration/postgresql/V1.0.0.5__feasability_tables.sql (/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/classes/db/migration/postgresql/V1.0.0.5__feasability_tables.sql)
  1233. Line : 13
  1234. Statement : CREATE TABLE IF NOT EXISTS feasibility_study(
  1235. id int NOT NULL,
  1236. name varchar(255) NOT NULL,
  1237. description varchar(1000) NULL,
  1238. index_def_id int NULL,
  1239. result_def_id int NULL,
  1240. generate_info_id int NULL,
  1241. created_by varchar(255) NULL,
  1242. created_date Timestamp(3) NULL,
  1243. modified_by varchar(255) NULL,
  1244. modified_date Timestamp(3) NULL,
  1245. CONSTRAINT PK_clinical_trial_protocol PRIMARY KEY (id),
  1246. CONSTRAINT FK_feasibility_study_cohort_definition_index FOREIGN KEY(index_def_id)
  1247. REFERENCES cohort_definition (id),
  1248. CONSTRAINT FK_feasibility_study_cohort_definition_result FOREIGN KEY(result_def_id)
  1249. REFERENCES cohort_definition (id),
  1250. CONSTRAINT FK_feasibility_study_feas_study_generation_info FOREIGN KEY(generate_info_id)
  1251. REFERENCES feas_study_generation_info (study_id)
  1252. )
  1253.  
  1254. at org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java:117)
  1255. at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.execute(SqlMigrationExecutor.java:71)
  1256. at org.flywaydb.core.internal.command.DbMigrate$5.doInTransaction(DbMigrate.java:287)
  1257. at org.flywaydb.core.internal.command.DbMigrate$5.doInTransaction(DbMigrate.java:285)
  1258. at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72)
  1259. at org.flywaydb.core.internal.command.DbMigrate.applyMigration(DbMigrate.java:285)
  1260. at org.flywaydb.core.internal.command.DbMigrate.access$800(DbMigrate.java:46)
  1261. at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:207)
  1262. at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:156)
  1263. at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72)
  1264. at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:156)
  1265. at org.flywaydb.core.Flyway$1.execute(Flyway.java:972)
  1266. at org.flywaydb.core.Flyway$1.execute(Flyway.java:919)
  1267. at org.flywaydb.core.Flyway.execute(Flyway.java:1320)
  1268. at org.flywaydb.core.Flyway.migrate(Flyway.java:919)
  1269. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  1270. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  1271. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  1272. at java.lang.reflect.Method.invoke(Method.java:497)
  1273. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1694)
  1274. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1633)
  1275. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1562)
  1276. ... 102 more
  1277. Caused by: org.postgresql.util.PSQLException: ERROR: relation "cohort_definition" does not exist
  1278. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)
  1279. at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
  1280. at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
  1281. at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
  1282. at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
  1283. at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:366)
  1284. at org.flywaydb.core.internal.dbsupport.JdbcTemplate.executeStatement(JdbcTemplate.java:238)
  1285. at org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java:114)
  1286. ... 123 more
  1287. 2015-09-02 01:03:55.668 WARN qtp965307475-44 org.eclipse.jetty.util.component.AbstractLifeCycle - - FAILED o.e.j.w.WebAppContext@5f8a03e3{/WebAPI,file:/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/,UNAVAILABLE}{/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/olympus/WebAPI.war}: java.lang.RuntimeException: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flyway' defined in class path resource [org/springframework/boot/autoconfigure/flyway/FlywayAutoConfiguration$FlywayConfiguration.class]: Invocation of init method failed; nested exception is org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException:
  1288. Migration V1.0.0.5__feasability_tables.sql failed
  1289. -------------------------------------------------
  1290. SQL State : 42P01
  1291. Error Code : 0
  1292. Message : ERROR: relation "cohort_definition" does not exist
  1293. Location : db/migration/postgresql/V1.0.0.5__feasability_tables.sql (/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/classes/db/migration/postgresql/V1.0.0.5__feasability_tables.sql)
  1294. Line : 13
  1295. Statement : CREATE TABLE IF NOT EXISTS feasibility_study(
  1296. id int NOT NULL,
  1297. name varchar(255) NOT NULL,
  1298. description varchar(1000) NULL,
  1299. index_def_id int NULL,
  1300. result_def_id int NULL,
  1301. generate_info_id int NULL,
  1302. created_by varchar(255) NULL,
  1303. created_date Timestamp(3) NULL,
  1304. modified_by varchar(255) NULL,
  1305. modified_date Timestamp(3) NULL,
  1306. CONSTRAINT PK_clinical_trial_protocol PRIMARY KEY (id),
  1307. CONSTRAINT FK_feasibility_study_cohort_definition_index FOREIGN KEY(index_def_id)
  1308. REFERENCES cohort_definition (id),
  1309. CONSTRAINT FK_feasibility_study_cohort_definition_result FOREIGN KEY(result_def_id)
  1310. REFERENCES cohort_definition (id),
  1311. CONSTRAINT FK_feasibility_study_feas_study_generation_info FOREIGN KEY(generate_info_id)
  1312. REFERENCES feas_study_generation_info (study_id)
  1313. )
  1314.  
  1315. java.lang.RuntimeException: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flyway' defined in class path resource [org/springframework/boot/autoconfigure/flyway/FlywayAutoConfiguration$FlywayConfiguration.class]: Invocation of init method failed; nested exception is org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException:
  1316. Migration V1.0.0.5__feasability_tables.sql failed
  1317. -------------------------------------------------
  1318. SQL State : 42P01
  1319. Error Code : 0
  1320. Message : ERROR: relation "cohort_definition" does not exist
  1321. Location : db/migration/postgresql/V1.0.0.5__feasability_tables.sql (/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/classes/db/migration/postgresql/V1.0.0.5__feasability_tables.sql)
  1322. Line : 13
  1323. Statement : CREATE TABLE IF NOT EXISTS feasibility_study(
  1324. id int NOT NULL,
  1325. name varchar(255) NOT NULL,
  1326. description varchar(1000) NULL,
  1327. index_def_id int NULL,
  1328. result_def_id int NULL,
  1329. generate_info_id int NULL,
  1330. created_by varchar(255) NULL,
  1331. created_date Timestamp(3) NULL,
  1332. modified_by varchar(255) NULL,
  1333. modified_date Timestamp(3) NULL,
  1334. CONSTRAINT PK_clinical_trial_protocol PRIMARY KEY (id),
  1335. CONSTRAINT FK_feasibility_study_cohort_definition_index FOREIGN KEY(index_def_id)
  1336. REFERENCES cohort_definition (id),
  1337. CONSTRAINT FK_feasibility_study_cohort_definition_result FOREIGN KEY(result_def_id)
  1338. REFERENCES cohort_definition (id),
  1339. CONSTRAINT FK_feasibility_study_feas_study_generation_info FOREIGN KEY(generate_info_id)
  1340. REFERENCES feas_study_generation_info (study_id)
  1341. )
  1342.  
  1343. at org.eclipse.jetty.annotations.ServletContainerInitializersStarter.doStart(ServletContainerInitializersStarter.java:70)
  1344. at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
  1345. at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:274)
  1346. at org.eclipse.jetty.webapp.WebAppContext.startWebapp(WebAppContext.java:1343)
  1347. at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1336)
  1348. at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:741)
  1349. at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:499)
  1350. at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
  1351. at org.ohdsi.olympus.model.WebApiService.start(WebApiService.java:200)
  1352. at org.ohdsi.olympus.controller.WebApiController.start(WebApiController.java:232)
  1353. at org.ohdsi.olympus.controller.WebApiController.handleStartSubmission(WebApiController.java:209)
  1354. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  1355. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  1356. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  1357. at java.lang.reflect.Method.invoke(Method.java:497)
  1358. at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)
  1359. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:137)
  1360. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110)
  1361. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:777)
  1362. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:706)
  1363. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
  1364. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:943)
  1365. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:877)
  1366. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:966)
  1367. at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:868)
  1368. at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
  1369. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:842)
  1370. at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
  1371. at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:800)
  1372. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1669)
  1373. at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:77)
  1374. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  1375. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
  1376. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
  1377. at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)
  1378. at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)
  1379. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  1380. at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
  1381. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  1382. at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)
  1383. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  1384. at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
  1385. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  1386. at org.springframework.security.web.authentication.rememberme.RememberMeAuthenticationFilter.doFilter(RememberMeAuthenticationFilter.java:146)
  1387. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  1388. at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:154)
  1389. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  1390. at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
  1391. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  1392. at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:199)
  1393. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  1394. at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:110)
  1395. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  1396. at org.springframework.security.web.csrf.CsrfFilter.doFilterInternal(CsrfFilter.java:105)
  1397. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  1398. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  1399. at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
  1400. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  1401. at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:50)
  1402. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  1403. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  1404. at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)
  1405. at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)
  1406. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
  1407. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
  1408. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  1409. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
  1410. at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:585)
  1411. at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
  1412. at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:577)
  1413. at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:223)
  1414. at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1125)
  1415. at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515)
  1416. at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
  1417. at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1059)
  1418. at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
  1419. at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:215)
  1420. at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
  1421. at org.eclipse.jetty.server.Server.handle(Server.java:497)
  1422. at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:310)
  1423. at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:248)
  1424. at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540)
  1425. at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:620)
  1426. at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:540)
  1427. at java.lang.Thread.run(Thread.java:745)
  1428. Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flyway' defined in class path resource [org/springframework/boot/autoconfigure/flyway/FlywayAutoConfiguration$FlywayConfiguration.class]: Invocation of init method failed; nested exception is org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException:
  1429. Migration V1.0.0.5__feasability_tables.sql failed
  1430. -------------------------------------------------
  1431. SQL State : 42P01
  1432. Error Code : 0
  1433. Message : ERROR: relation "cohort_definition" does not exist
  1434. Location : db/migration/postgresql/V1.0.0.5__feasability_tables.sql (/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/classes/db/migration/postgresql/V1.0.0.5__feasability_tables.sql)
  1435. Line : 13
  1436. Statement : CREATE TABLE IF NOT EXISTS feasibility_study(
  1437. id int NOT NULL,
  1438. name varchar(255) NOT NULL,
  1439. description varchar(1000) NULL,
  1440. index_def_id int NULL,
  1441. result_def_id int NULL,
  1442. generate_info_id int NULL,
  1443. created_by varchar(255) NULL,
  1444. created_date Timestamp(3) NULL,
  1445. modified_by varchar(255) NULL,
  1446. modified_date Timestamp(3) NULL,
  1447. CONSTRAINT PK_clinical_trial_protocol PRIMARY KEY (id),
  1448. CONSTRAINT FK_feasibility_study_cohort_definition_index FOREIGN KEY(index_def_id)
  1449. REFERENCES cohort_definition (id),
  1450. CONSTRAINT FK_feasibility_study_cohort_definition_result FOREIGN KEY(result_def_id)
  1451. REFERENCES cohort_definition (id),
  1452. CONSTRAINT FK_feasibility_study_feas_study_generation_info FOREIGN KEY(generate_info_id)
  1453. REFERENCES feas_study_generation_info (study_id)
  1454. )
  1455.  
  1456. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1566)
  1457. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539)
  1458. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
  1459. at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
  1460. at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
  1461. at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
  1462. at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
  1463. at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:762)
  1464. at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:757)
  1465. at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:480)
  1466. at org.springframework.boot.context.embedded.EmbeddedWebApplicationContext.refresh(EmbeddedWebApplicationContext.java:118)
  1467. at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:691)
  1468. at org.springframework.boot.SpringApplication.run(SpringApplication.java:321)
  1469. at org.springframework.boot.context.web.SpringBootServletInitializer.run(SpringBootServletInitializer.java:117)
  1470. at org.springframework.boot.context.web.SpringBootServletInitializer.createRootApplicationContext(SpringBootServletInitializer.java:108)
  1471. at org.springframework.boot.context.web.SpringBootServletInitializer.onStartup(SpringBootServletInitializer.java:68)
  1472. at org.springframework.web.SpringServletContainerInitializer.onStartup(SpringServletContainerInitializer.java:175)
  1473. at org.eclipse.jetty.plus.annotation.ContainerInitializer.callStartup(ContainerInitializer.java:140)
  1474. at org.eclipse.jetty.annotations.ServletContainerInitializersStarter.doStart(ServletContainerInitializersStarter.java:65)
  1475. ... 84 more
  1476. Caused by: org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException:
  1477. Migration V1.0.0.5__feasability_tables.sql failed
  1478. -------------------------------------------------
  1479. SQL State : 42P01
  1480. Error Code : 0
  1481. Message : ERROR: relation "cohort_definition" does not exist
  1482. Location : db/migration/postgresql/V1.0.0.5__feasability_tables.sql (/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/classes/db/migration/postgresql/V1.0.0.5__feasability_tables.sql)
  1483. Line : 13
  1484. Statement : CREATE TABLE IF NOT EXISTS feasibility_study(
  1485. id int NOT NULL,
  1486. name varchar(255) NOT NULL,
  1487. description varchar(1000) NULL,
  1488. index_def_id int NULL,
  1489. result_def_id int NULL,
  1490. generate_info_id int NULL,
  1491. created_by varchar(255) NULL,
  1492. created_date Timestamp(3) NULL,
  1493. modified_by varchar(255) NULL,
  1494. modified_date Timestamp(3) NULL,
  1495. CONSTRAINT PK_clinical_trial_protocol PRIMARY KEY (id),
  1496. CONSTRAINT FK_feasibility_study_cohort_definition_index FOREIGN KEY(index_def_id)
  1497. REFERENCES cohort_definition (id),
  1498. CONSTRAINT FK_feasibility_study_cohort_definition_result FOREIGN KEY(result_def_id)
  1499. REFERENCES cohort_definition (id),
  1500. CONSTRAINT FK_feasibility_study_feas_study_generation_info FOREIGN KEY(generate_info_id)
  1501. REFERENCES feas_study_generation_info (study_id)
  1502. )
  1503.  
  1504. at org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java:117)
  1505. at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.execute(SqlMigrationExecutor.java:71)
  1506. at org.flywaydb.core.internal.command.DbMigrate$5.doInTransaction(DbMigrate.java:287)
  1507. at org.flywaydb.core.internal.command.DbMigrate$5.doInTransaction(DbMigrate.java:285)
  1508. at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72)
  1509. at org.flywaydb.core.internal.command.DbMigrate.applyMigration(DbMigrate.java:285)
  1510. at org.flywaydb.core.internal.command.DbMigrate.access$800(DbMigrate.java:46)
  1511. at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:207)
  1512. at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:156)
  1513. at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72)
  1514. at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:156)
  1515. at org.flywaydb.core.Flyway$1.execute(Flyway.java:972)
  1516. at org.flywaydb.core.Flyway$1.execute(Flyway.java:919)
  1517. at org.flywaydb.core.Flyway.execute(Flyway.java:1320)
  1518. at org.flywaydb.core.Flyway.migrate(Flyway.java:919)
  1519. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  1520. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  1521. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  1522. at java.lang.reflect.Method.invoke(Method.java:497)
  1523. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1694)
  1524. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1633)
  1525. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1562)
  1526. ... 102 more
  1527. Caused by: org.postgresql.util.PSQLException: ERROR: relation "cohort_definition" does not exist
  1528. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)
  1529. at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
  1530. at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
  1531. at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
  1532. at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
  1533. at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:366)
  1534. at org.flywaydb.core.internal.dbsupport.JdbcTemplate.executeStatement(JdbcTemplate.java:238)
  1535. at org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java:114)
  1536. ... 123 more
  1537. 2015-09-02 01:03:55.671 ERROR qtp965307475-44 org.ohdsi.olympus.controller.WebApiController - - WebAPI was not able to start up successfully, please check your configuration. (org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flyway' defined in class path resource [org/springframework/boot/autoconfigure/flyway/FlywayAutoConfiguration$FlywayConfiguration.class]: Invocation of init method failed; nested exception is org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException:
  1538. Migration V1.0.0.5__feasability_tables.sql failed
  1539. -------------------------------------------------
  1540. SQL State : 42P01
  1541. Error Code : 0
  1542. Message : ERROR: relation "cohort_definition" does not exist
  1543. Location : db/migration/postgresql/V1.0.0.5__feasability_tables.sql (/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/classes/db/migration/postgresql/V1.0.0.5__feasability_tables.sql)
  1544. Line : 13
  1545. Statement : CREATE TABLE IF NOT EXISTS feasibility_study(
  1546. id int NOT NULL,
  1547. name varchar(255) NOT NULL,
  1548. description varchar(1000) NULL,
  1549. index_def_id int NULL,
  1550. result_def_id int NULL,
  1551. generate_info_id int NULL,
  1552. created_by varchar(255) NULL,
  1553. created_date Timestamp(3) NULL,
  1554. modified_by varchar(255) NULL,
  1555. modified_date Timestamp(3) NULL,
  1556. CONSTRAINT PK_clinical_trial_protocol PRIMARY KEY (id),
  1557. CONSTRAINT FK_feasibility_study_cohort_definition_index FOREIGN KEY(index_def_id)
  1558. REFERENCES cohort_definition (id),
  1559. CONSTRAINT FK_feasibility_study_cohort_definition_result FOREIGN KEY(result_def_id)
  1560. REFERENCES cohort_definition (id),
  1561. CONSTRAINT FK_feasibility_study_feas_study_generation_info FOREIGN KEY(generate_info_id)
  1562. REFERENCES feas_study_generation_info (study_id)
  1563. )
  1564. )
  1565. java.lang.RuntimeException: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flyway' defined in class path resource [org/springframework/boot/autoconfigure/flyway/FlywayAutoConfiguration$FlywayConfiguration.class]: Invocation of init method failed; nested exception is org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException:
  1566. Migration V1.0.0.5__feasability_tables.sql failed
  1567. -------------------------------------------------
  1568. SQL State : 42P01
  1569. Error Code : 0
  1570. Message : ERROR: relation "cohort_definition" does not exist
  1571. Location : db/migration/postgresql/V1.0.0.5__feasability_tables.sql (/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/classes/db/migration/postgresql/V1.0.0.5__feasability_tables.sql)
  1572. Line : 13
  1573. Statement : CREATE TABLE IF NOT EXISTS feasibility_study(
  1574. id int NOT NULL,
  1575. name varchar(255) NOT NULL,
  1576. description varchar(1000) NULL,
  1577. index_def_id int NULL,
  1578. result_def_id int NULL,
  1579. generate_info_id int NULL,
  1580. created_by varchar(255) NULL,
  1581. created_date Timestamp(3) NULL,
  1582. modified_by varchar(255) NULL,
  1583. modified_date Timestamp(3) NULL,
  1584. CONSTRAINT PK_clinical_trial_protocol PRIMARY KEY (id),
  1585. CONSTRAINT FK_feasibility_study_cohort_definition_index FOREIGN KEY(index_def_id)
  1586. REFERENCES cohort_definition (id),
  1587. CONSTRAINT FK_feasibility_study_cohort_definition_result FOREIGN KEY(result_def_id)
  1588. REFERENCES cohort_definition (id),
  1589. CONSTRAINT FK_feasibility_study_feas_study_generation_info FOREIGN KEY(generate_info_id)
  1590. REFERENCES feas_study_generation_info (study_id)
  1591. )
  1592.  
  1593. at org.eclipse.jetty.annotations.ServletContainerInitializersStarter.doStart(ServletContainerInitializersStarter.java:70)
  1594. at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
  1595. at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:274)
  1596. at org.eclipse.jetty.webapp.WebAppContext.startWebapp(WebAppContext.java:1343)
  1597. at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1336)
  1598. at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:741)
  1599. at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:499)
  1600. at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
  1601. at org.ohdsi.olympus.model.WebApiService.start(WebApiService.java:200)
  1602. at org.ohdsi.olympus.controller.WebApiController.start(WebApiController.java:232)
  1603. at org.ohdsi.olympus.controller.WebApiController.handleStartSubmission(WebApiController.java:209)
  1604. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  1605. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  1606. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  1607. at java.lang.reflect.Method.invoke(Method.java:497)
  1608. at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)
  1609. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:137)
  1610. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110)
  1611. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:777)
  1612. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:706)
  1613. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
  1614. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:943)
  1615. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:877)
  1616. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:966)
  1617. at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:868)
  1618. at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
  1619. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:842)
  1620. at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
  1621. at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:800)
  1622. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1669)
  1623. at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:77)
  1624. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  1625. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
  1626. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
  1627. at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)
  1628. at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)
  1629. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  1630. at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
  1631. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  1632. at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)
  1633. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  1634. at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
  1635. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  1636. at org.springframework.security.web.authentication.rememberme.RememberMeAuthenticationFilter.doFilter(RememberMeAuthenticationFilter.java:146)
  1637. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  1638. at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:154)
  1639. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  1640. at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
  1641. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  1642. at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:199)
  1643. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  1644. at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:110)
  1645. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  1646. at org.springframework.security.web.csrf.CsrfFilter.doFilterInternal(CsrfFilter.java:105)
  1647. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  1648. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  1649. at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
  1650. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  1651. at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:50)
  1652. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  1653. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  1654. at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)
  1655. at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)
  1656. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
  1657. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
  1658. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  1659. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
  1660. at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:585)
  1661. at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
  1662. at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:577)
  1663. at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:223)
  1664. at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1125)
  1665. at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515)
  1666. at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
  1667. at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1059)
  1668. at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
  1669. at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:215)
  1670. at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
  1671. at org.eclipse.jetty.server.Server.handle(Server.java:497)
  1672. at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:310)
  1673. at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:248)
  1674. at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540)
  1675. at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:620)
  1676. at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:540)
  1677. at java.lang.Thread.run(Thread.java:745)
  1678. Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flyway' defined in class path resource [org/springframework/boot/autoconfigure/flyway/FlywayAutoConfiguration$FlywayConfiguration.class]: Invocation of init method failed; nested exception is org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException:
  1679. Migration V1.0.0.5__feasability_tables.sql failed
  1680. -------------------------------------------------
  1681. SQL State : 42P01
  1682. Error Code : 0
  1683. Message : ERROR: relation "cohort_definition" does not exist
  1684. Location : db/migration/postgresql/V1.0.0.5__feasability_tables.sql (/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/classes/db/migration/postgresql/V1.0.0.5__feasability_tables.sql)
  1685. Line : 13
  1686. Statement : CREATE TABLE IF NOT EXISTS feasibility_study(
  1687. id int NOT NULL,
  1688. name varchar(255) NOT NULL,
  1689. description varchar(1000) NULL,
  1690. index_def_id int NULL,
  1691. result_def_id int NULL,
  1692. generate_info_id int NULL,
  1693. created_by varchar(255) NULL,
  1694. created_date Timestamp(3) NULL,
  1695. modified_by varchar(255) NULL,
  1696. modified_date Timestamp(3) NULL,
  1697. CONSTRAINT PK_clinical_trial_protocol PRIMARY KEY (id),
  1698. CONSTRAINT FK_feasibility_study_cohort_definition_index FOREIGN KEY(index_def_id)
  1699. REFERENCES cohort_definition (id),
  1700. CONSTRAINT FK_feasibility_study_cohort_definition_result FOREIGN KEY(result_def_id)
  1701. REFERENCES cohort_definition (id),
  1702. CONSTRAINT FK_feasibility_study_feas_study_generation_info FOREIGN KEY(generate_info_id)
  1703. REFERENCES feas_study_generation_info (study_id)
  1704. )
  1705.  
  1706. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1566)
  1707. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539)
  1708. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
  1709. at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
  1710. at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
  1711. at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
  1712. at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
  1713. at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:762)
  1714. at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:757)
  1715. at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:480)
  1716. at org.springframework.boot.context.embedded.EmbeddedWebApplicationContext.refresh(EmbeddedWebApplicationContext.java:118)
  1717. at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:691)
  1718. at org.springframework.boot.SpringApplication.run(SpringApplication.java:321)
  1719. at org.springframework.boot.context.web.SpringBootServletInitializer.run(SpringBootServletInitializer.java:117)
  1720. at org.springframework.boot.context.web.SpringBootServletInitializer.createRootApplicationContext(SpringBootServletInitializer.java:108)
  1721. at org.springframework.boot.context.web.SpringBootServletInitializer.onStartup(SpringBootServletInitializer.java:68)
  1722. at org.springframework.web.SpringServletContainerInitializer.onStartup(SpringServletContainerInitializer.java:175)
  1723. at org.eclipse.jetty.plus.annotation.ContainerInitializer.callStartup(ContainerInitializer.java:140)
  1724. at org.eclipse.jetty.annotations.ServletContainerInitializersStarter.doStart(ServletContainerInitializersStarter.java:65)
  1725. ... 84 more
  1726. Caused by: org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException:
  1727. Migration V1.0.0.5__feasability_tables.sql failed
  1728. -------------------------------------------------
  1729. SQL State : 42P01
  1730. Error Code : 0
  1731. Message : ERROR: relation "cohort_definition" does not exist
  1732. Location : db/migration/postgresql/V1.0.0.5__feasability_tables.sql (/private/var/folders/vy/3m9ltvyd3zn8qds2vj4wpvwh0000gp/T/jetty-0.0.0.0-20000-WebAPI.war-_WebAPI-any-/webapp/WEB-INF/classes/db/migration/postgresql/V1.0.0.5__feasability_tables.sql)
  1733. Line : 13
  1734. Statement : CREATE TABLE IF NOT EXISTS feasibility_study(
  1735. id int NOT NULL,
  1736. name varchar(255) NOT NULL,
  1737. description varchar(1000) NULL,
  1738. index_def_id int NULL,
  1739. result_def_id int NULL,
  1740. generate_info_id int NULL,
  1741. created_by varchar(255) NULL,
  1742. created_date Timestamp(3) NULL,
  1743. modified_by varchar(255) NULL,
  1744. modified_date Timestamp(3) NULL,
  1745. CONSTRAINT PK_clinical_trial_protocol PRIMARY KEY (id),
  1746. CONSTRAINT FK_feasibility_study_cohort_definition_index FOREIGN KEY(index_def_id)
  1747. REFERENCES cohort_definition (id),
  1748. CONSTRAINT FK_feasibility_study_cohort_definition_result FOREIGN KEY(result_def_id)
  1749. REFERENCES cohort_definition (id),
  1750. CONSTRAINT FK_feasibility_study_feas_study_generation_info FOREIGN KEY(generate_info_id)
  1751. REFERENCES feas_study_generation_info (study_id)
  1752. )
  1753.  
  1754. at org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java:117)
  1755. at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.execute(SqlMigrationExecutor.java:71)
  1756. at org.flywaydb.core.internal.command.DbMigrate$5.doInTransaction(DbMigrate.java:287)
  1757. at org.flywaydb.core.internal.command.DbMigrate$5.doInTransaction(DbMigrate.java:285)
  1758. at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72)
  1759. at org.flywaydb.core.internal.command.DbMigrate.applyMigration(DbMigrate.java:285)
  1760. at org.flywaydb.core.internal.command.DbMigrate.access$800(DbMigrate.java:46)
  1761. at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:207)
  1762. at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:156)
  1763. at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72)
  1764. at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:156)
  1765. at org.flywaydb.core.Flyway$1.execute(Flyway.java:972)
  1766. at org.flywaydb.core.Flyway$1.execute(Flyway.java:919)
  1767. at org.flywaydb.core.Flyway.execute(Flyway.java:1320)
  1768. at org.flywaydb.core.Flyway.migrate(Flyway.java:919)
  1769. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  1770. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  1771. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  1772. at java.lang.reflect.Method.invoke(Method.java:497)
  1773. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1694)
  1774. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1633)
  1775. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1562)
  1776. ... 102 more
  1777. Caused by: org.postgresql.util.PSQLException: ERROR: relation "cohort_definition" does not exist
  1778. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)
  1779. at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
  1780. at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
  1781. at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
  1782. at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
  1783. at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:366)
  1784. at org.flywaydb.core.internal.dbsupport.JdbcTemplate.executeStatement(JdbcTemplate.java:238)
  1785. at org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java:114)
  1786. ... 123 more
  1787. 2015-09-02 01:03:55.673 DEBUG qtp965307475-44 org.ohdsi.olympus.controller.WebApiController - - Get config
Advertisement
Add Comment
Please, Sign In to add comment