Advertisement
jmpango

Exception running OpenClinica

Aug 3rd, 2011
296
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 13.21 KB | None | 0 0
  1. SEVERE: Exception sending context initialized event to listener instance of class org.springframework.web.context.ContextLoaderListener
  2. org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in URL [jar:file:/C:/Users/Jonathan/.m2/repository/org/akaza/openclinica/OpenClinica-core/SNAPSHOT/OpenClinica-core-SNAPSHOT.jar!/org/akaza/openclinica/applicationContext-core-db.xml]: Invocati
  3. on of init method failed; nested exception is liquibase.exception.MigrationFailedException: Migration failed for change set migration/amethyst/2010-08-24-5724.xml::2010-05-27-5724-1::jamuna:
  4. Reason: liquibase.exception.JDBCException: Error executing SQL CREATE VIEW dn_age_days AS SELECT dn.discrepancy_note_id, 'now'::text::date - (( SELECT discrepancy_note.date_created
  5. FROM discrepancy_note
  6. WHERE discrepancy_note.parent_dn_id = dn.discrepancy_note_id AND discrepancy_note.discrepancy_note_id = (( SELECT max(discrepancy_note.discrepancy_note_id) AS max
  7. FROM discrepancy_note
  8. WHERE discrepancy_note.parent_dn_id = dn.discrepancy_note_id AND dn.resolution_status_id <> 4 AND dn.resolution_status_id <> 5)))) AS days, (( SELECT discrepancy_note.date_created FROM discrepancy_note WHERE discrepancy_note.parent_dn_id = dn.discrepancy_note_id AND
  9. discrepancy_note.discrepancy_note_id = (( SELECT max(discrepancy_note.discrepancy_note_id) AS max FROM discrepancy_note WHERE discrepancy_note.parent_dn_id = dn.discrepancy_note_id)))) - dn.date_created AS age FROM discrepancy_note dn WHERE dn.parent_dn_id IS N
  10. ULL;
  11. ALTER TABLE dn_age_days OWNER TO clinica;:
  12. Caused By: Error executing SQL CREATE VIEW dn_age_days AS SELECT dn.discrepancy_note_id, 'now'::text::date - (( SELECT discrepancy_note.date_created
  13. FROM discrepancy_note
  14. WHERE discrepancy_note.parent_dn_id = dn.discrepancy_note_id AND discrepancy_note.discrepancy_note_id = (( SELECT max(discrepancy_note.discrepancy_note_id) AS max
  15. FROM discrepancy_note
  16. WHERE discrepancy_note.parent_dn_id = dn.discrepancy_note_id AND dn.resolution_status_id <> 4 AND dn.resolution_status_id <> 5)))) AS days, (( SELECT discrepancy_note.date_created FROM discrepancy_note WHERE discrepancy_note.parent_dn_id = dn.discrepancy_note_id AND
  17. discrepancy_note.discrepancy_note_id = (( SELECT max(discrepancy_note.discrepancy_note_id) AS max FROM discrepancy_note WHERE discrepancy_note.parent_dn_id = dn.discrepancy_note_id)))) - dn.date_created AS age FROM discrepancy_note dn WHERE dn.parent_dn_id IS N
  18. ULL;
  19. ALTER TABLE dn_age_days OWNER TO clinica;:
  20. Caused By: ERROR: role "clinica" does not exist
  21. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1420)
  22. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
  23. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
  24. at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)
  25. at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
  26. at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)
  27. at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)
  28. at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:580)
  29. at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:895)
  30. at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:425)
  31. at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:276)
  32. at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:197)
  33. at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)
  34. at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4135)
  35. at org.apache.catalina.core.StandardContext.start(StandardContext.java:4630)
  36. at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
  37. at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)
  38. at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
  39. at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:445)
  40. at org.apache.catalina.startup.Embedded.start(Embedded.java:825)
  41. at org.codehaus.mojo.tomcat.AbstractRunMojo.startContainer(AbstractRunMojo.java:558)
  42. at org.codehaus.mojo.tomcat.AbstractRunMojo.execute(AbstractRunMojo.java:255)
  43. at org.apache.maven.plugin.DefaultPluginManager.executeMojo(DefaultPluginManager.java:490)
  44. at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoals(DefaultLifecycleExecutor.java:694)
  45. at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeStandaloneGoal(DefaultLifecycleExecutor.java:569)
  46. at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoal(DefaultLifecycleExecutor.java:539)
  47. at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoalAndHandleFailures(DefaultLifecycleExecutor.java:387)
  48. at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeTaskSegments(DefaultLifecycleExecutor.java:348)
  49. at org.apache.maven.lifecycle.DefaultLifecycleExecutor.execute(DefaultLifecycleExecutor.java:180)
  50. at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:328)
  51. at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:138)
  52. at org.apache.maven.cli.MavenCli.main(MavenCli.java:362)
  53. at org.apache.maven.cli.compat.CompatibleMain.main(CompatibleMain.java:60)
  54. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  55. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  56. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  57. at java.lang.reflect.Method.invoke(Method.java:597)
  58. at org.codehaus.classworlds.Launcher.launchEnhanced(Launcher.java:315)
  59. at org.codehaus.classworlds.Launcher.launch(Launcher.java:255)
  60. at org.codehaus.classworlds.Launcher.mainWithExitCode(Launcher.java:430)
  61. at org.codehaus.classworlds.Launcher.main(Launcher.java:375)
  62. Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set migration/amethyst/2010-08-24-5724.xml::2010-05-27-5724-1::jamuna:
  63. Reason: liquibase.exception.JDBCException: Error executing SQL CREATE VIEW dn_age_days AS SELECT dn.discrepancy_note_id, 'now'::text::date - (( SELECT discrepancy_note.date_created
  64. FROM discrepancy_note
  65. WHERE discrepancy_note.parent_dn_id = dn.discrepancy_note_id AND discrepancy_note.discrepancy_note_id = (( SELECT max(discrepancy_note.discrepancy_note_id) AS max
  66. FROM discrepancy_note
  67. WHERE discrepancy_note.parent_dn_id = dn.discrepancy_note_id AND dn.resolution_status_id <> 4 AND dn.resolution_status_id <> 5)))) AS days, (( SELECT discrepancy_note.date_created FROM discrepancy_note WHERE discrepancy_note.parent_dn_id = dn.discrepancy_note_id AND
  68. discrepancy_note.discrepancy_note_id = (( SELECT max(discrepancy_note.discrepancy_note_id) AS max FROM discrepancy_note WHERE discrepancy_note.parent_dn_id = dn.discrepancy_note_id)))) - dn.date_created AS age FROM discrepancy_note dn WHERE dn.parent_dn_id IS N
  69. ULL;
  70. ALTER TABLE dn_age_days OWNER TO clinica;:
  71. Caused By: Error executing SQL CREATE VIEW dn_age_days AS SELECT dn.discrepancy_note_id, 'now'::text::date - (( SELECT discrepancy_note.date_created
  72. FROM discrepancy_note
  73. WHERE discrepancy_note.parent_dn_id = dn.discrepancy_note_id AND discrepancy_note.discrepancy_note_id = (( SELECT max(discrepancy_note.discrepancy_note_id) AS max
  74. FROM discrepancy_note
  75. WHERE discrepancy_note.parent_dn_id = dn.discrepancy_note_id AND dn.resolution_status_id <> 4 AND dn.resolution_status_id <> 5)))) AS days, (( SELECT discrepancy_note.date_created FROM discrepancy_note WHERE discrepancy_note.parent_dn_id = dn.discrepancy_note_id AND
  76. discrepancy_note.discrepancy_note_id = (( SELECT max(discrepancy_note.discrepancy_note_id) AS max FROM discrepancy_note WHERE discrepancy_note.parent_dn_id = dn.discrepancy_note_id)))) - dn.date_created AS age FROM discrepancy_note dn WHERE dn.parent_dn_id IS N
  77. ULL;
  78. ALTER TABLE dn_age_days OWNER TO clinica;:
  79. Caused By: ERROR: role "clinica" does not exist
  80. at liquibase.ChangeSet.execute(ChangeSet.java:260)
  81. at liquibase.parser.visitor.UpdateVisitor.visit(UpdateVisitor.java:26)
  82. at liquibase.parser.ChangeLogIterator.run(ChangeLogIterator.java:41)
  83. at liquibase.Liquibase.update(Liquibase.java:112)
  84. at liquibase.spring.SpringLiquibase.afterPropertiesSet(SpringLiquibase.java:214)
  85. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1477)
  86. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1417)
  87. ... 40 more
  88. Caused by: liquibase.exception.JDBCException: Error executing SQL CREATE VIEW dn_age_days AS SELECT dn.discrepancy_note_id, 'now'::text::date - (( SELECT discrepancy_note.date_created
  89. FROM discrepancy_note
  90. WHERE discrepancy_note.parent_dn_id = dn.discrepancy_note_id AND discrepancy_note.discrepancy_note_id = (( SELECT max(discrepancy_note.discrepancy_note_id) AS max
  91. FROM discrepancy_note
  92. WHERE discrepancy_note.parent_dn_id = dn.discrepancy_note_id AND dn.resolution_status_id <> 4 AND dn.resolution_status_id <> 5)))) AS days, (( SELECT discrepancy_note.date_created FROM discrepancy_note WHERE discrepancy_note.parent_dn_id = dn.discrepancy_note_id AND
  93. discrepancy_note.discrepancy_note_id = (( SELECT max(discrepancy_note.discrepancy_note_id) AS max FROM discrepancy_note WHERE discrepancy_note.parent_dn_id = dn.discrepancy_note_id)))) - dn.date_created AS age FROM discrepancy_note dn WHERE dn.parent_dn_id IS N
  94. ULL;
  95. ALTER TABLE dn_age_days OWNER TO clinica;
  96. at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:55)
  97. at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:86)
  98. at liquibase.change.AbstractChange.execute(AbstractChange.java:247)
  99. at liquibase.change.AbstractChange.executeStatements(AbstractChange.java:93)
  100. at liquibase.ChangeSet.execute(ChangeSet.java:236)
  101. ... 46 more
  102. Caused by: org.postgresql.util.PSQLException: ERROR: role "clinica" does not exist
  103. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1512)
  104. at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1297)
  105. at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
  106. at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:430)
  107. at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:332)
  108. at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:324)
  109. at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
  110. at liquibase.database.template.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:78)
  111. at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:48)
  112. ... 50 more
  113. Aug 3, 2011 9:25:02 AM org.apache.catalina.core.StandardContext start
  114. SEVERE: Error listenerStart
  115. Aug 3, 2011 9:25:02 AM org.apache.catalina.core.StandardContext start
  116. SEVERE: Context [/OpenClinica-ws] startup failed due to previous errors
  117. Aug 3, 2011 9:25:02 AM org.apache.catalina.core.ApplicationContext log
  118. INFO: Closing Spring root WebApplicationContext
  119. Aug 3, 2011 9:25:02 AM org.apache.catalina.loader.WebappClassLoader clearReferencesJdbc
  120. SEVERE: The web application [/OpenClinica-ws] registered the JBDC driver [org.postgresql.Driver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.
  121. Aug 3, 2011 9:25:02 AM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
  122. SEVERE: The web application [/OpenClinica-ws] appears to have started a thread named [Timer-0] but has failed to stop it. This is very likely to create a memory leak.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement