API tools faq
paste
Guest User

Untitled

a guest
Jun 19th, 2013
77
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 12.41 KB | None | 0 0
raw download clone embed print report
  1. SEVERE 19/06/13 1:41 PM:liquibase: Change Set liquibase-update-to-latest.xml::20110819-1455-insert-u
  2. nknown-encounter-role::raff failed. Error: Error executing SQL INSERT INTO encounter_role (creator,
  3. date_created, description, name, retired, uuid) VALUES (1, '2011-08-18 14:00:00.0', 'Unknown encoun
  4. ter role for legacy providers with no encounter role set', 'Unknown', FALSE, 'a0b03050-c99b-11e0-957
  5. 2-0800200c9a66'): Referential integrity constraint violation: "ENCOUNTER_ROLE_CREATOR_FK: PUBLIC.ENC
  6. OUNTER_ROLE FOREIGN KEY(CREATOR) REFERENCES PUBLIC.USERS(USER_ID)"; SQL statement:
  7. INSERT INTO encounter_role (creator, date_created, description, name, retired, uuid) VALUES (1, '201
  8. 1-08-18 14:00:00.0', 'Unknown encounter role for legacy providers with no encounter role set', 'Unkn
  9. own', FALSE, 'a0b03050-c99b-11e0-9572-0800200c9a66') [23002-135]
  10. liquibase.exception.DatabaseException: Error executing SQL INSERT INTO encounter_role (creator, date
  11. _created, description, name, retired, uuid) VALUES (1, '2011-08-18 14:00:00.0', 'Unknown encounter r
  12. ole for legacy providers with no encounter role set', 'Unknown', FALSE, 'a0b03050-c99b-11e0-9572-080
  13. 0200c9a66'): Referential integrity constraint violation: "ENCOUNTER_ROLE_CREATOR_FK: PUBLIC.ENCOUNTE
  14. R_ROLE FOREIGN KEY(CREATOR) REFERENCES PUBLIC.USERS(USER_ID)"; SQL statement:
  15. INSERT INTO encounter_role (creator, date_created, description, name, retired, uuid) VALUES (1, '201
  16. 1-08-18 14:00:00.0', 'Unknown encounter role for legacy providers with no encounter role set', 'Unkn
  17. own', FALSE, 'a0b03050-c99b-11e0-9572-0800200c9a66') [23002-135]
  18. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)
  19. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)
  20. at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1091)
  21. at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:1075)
  22. at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)
  23. at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27)
  24. at org.openmrs.util.DatabaseUpdater$1OpenmrsUpdateVisitor.visit(DatabaseUpdater.java:202)
  25. at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)
  26. at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:230)
  27. at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:167)
  28. at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:152)
  29. at org.openmrs.web.filter.initialization.InitializationFilter$InitializationCompletion$1.run
  30. (InitializationFilter.java:1538)
  31. at java.lang.Thread.run(Thread.java:722)
  32. Caused by: org.h2.jdbc.JdbcSQLException: Referential integrity constraint violation: "ENCOUNTER_ROLE
  33. _CREATOR_FK: PUBLIC.ENCOUNTER_ROLE FOREIGN KEY(CREATOR) REFERENCES PUBLIC.USERS(USER_ID)"; SQL state
  34. ment:
  35. INSERT INTO encounter_role (creator, date_created, description, name, retired, uuid) VALUES (1, '201
  36. 1-08-18 14:00:00.0', 'Unknown encounter role for legacy providers with no encounter role set', 'Unkn
  37. own', FALSE, 'a0b03050-c99b-11e0-9572-0800200c9a66') [23002-135]
  38. at org.h2.message.DbException.getJdbcSQLException(DbException.java:327)
  39. at org.h2.message.DbException.get(DbException.java:167)
  40. at org.h2.message.DbException.get(DbException.java:144)
  41. at org.h2.constraint.ConstraintReferential.checkRowOwnTable(ConstraintReferential.java:329)
  42. at org.h2.constraint.ConstraintReferential.checkRow(ConstraintReferential.java:271)
  43. at org.h2.table.Table.fireConstraints(Table.java:788)
  44. at org.h2.table.Table.fireAfterRow(Table.java:805)
  45. at org.h2.command.dml.Insert.insertRows(Insert.java:122)
  46. at org.h2.command.dml.Insert.update(Insert.java:82)
  47. at org.h2.command.CommandContainer.update(CommandContainer.java:70)
  48. at org.h2.command.Command.executeUpdate(Command.java:199)
  49. at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:176)
  50. at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:151)
  51. at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.
  52. java:92)
  53. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
  54. ... 12 more
  55. INFO 19/06/13 1:41 PM:liquibase: Successfully released change log lock
  56. WARN - InitializationFilter$InitializationCompletion$1.run(1544) |2013-06-19 13:41:16,356| Error whi
  57. le trying to update to the latest database version
  58. org.openmrs.util.DatabaseUpdateException: There was an error while updating the database to the late
  59. st. file: liquibase-update-to-latest.xml. Error: Migration failed for change set liquibase-update-to
  60. -latest.xml::20110819-1455-insert-unknown-encounter-role::raff:
  61. Reason: liquibase.exception.DatabaseException: Error executing SQL INSERT INTO encounter_role (
  62. creator, date_created, description, name, retired, uuid) VALUES (1, '2011-08-18 14:00:00.0', 'Unknow
  63. n encounter role for legacy providers with no encounter role set', 'Unknown', FALSE, 'a0b03050-c99b-
  64. 11e0-9572-0800200c9a66'): Referential integrity constraint violation: "ENCOUNTER_ROLE_CREATOR_FK: PU
  65. BLIC.ENCOUNTER_ROLE FOREIGN KEY(CREATOR) REFERENCES PUBLIC.USERS(USER_ID)"; SQL statement:
  66. INSERT INTO encounter_role (creator, date_created, description, name, retired, uuid) VALUES (1, '201
  67. 1-08-18 14:00:00.0', 'Unknown encounter role for legacy providers with no encounter role set', 'Unkn
  68. own', FALSE, 'a0b03050-c99b-11e0-9572-0800200c9a66') [23002-135]:
  69. Caused By: Error executing SQL INSERT INTO encounter_role (creator, date_created, descript
  70. ion, name, retired, uuid) VALUES (1, '2011-08-18 14:00:00.0', 'Unknown encounter role for legacy pro
  71. viders with no encounter role set', 'Unknown', FALSE, 'a0b03050-c99b-11e0-9572-0800200c9a66'): Refer
  72. ential integrity constraint violation: "ENCOUNTER_ROLE_CREATOR_FK: PUBLIC.ENCOUNTER_ROLE FOREIGN KEY
  73. (CREATOR) REFERENCES PUBLIC.USERS(USER_ID)"; SQL statement:
  74. INSERT INTO encounter_role (creator, date_created, description, name, retired, uuid) VALUES (1, '201
  75. 1-08-18 14:00:00.0', 'Unknown encounter role for legacy providers with no encounter role set', 'Unkn
  76. own', FALSE, 'a0b03050-c99b-11e0-9572-0800200c9a66') [23002-135]:
  77. Caused By: Referential integrity constraint violation: "ENCOUNTER_ROLE_CREATOR_FK: PUBLIC.
  78. ENCOUNTER_ROLE FOREIGN KEY(CREATOR) REFERENCES PUBLIC.USERS(USER_ID)"; SQL statement:
  79. INSERT INTO encounter_role (creator, date_created, description, name, retired, uuid) VALUES (1, '201
  80. 1-08-18 14:00:00.0', 'Unknown encounter role for legacy providers with no encounter role set', 'Unkn
  81. own', FALSE, 'a0b03050-c99b-11e0-9572-0800200c9a66') [23002-135]
  82. at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:155)
  83. at org.openmrs.web.filter.initialization.InitializationFilter$InitializationCompletion$1.run
  84. (InitializationFilter.java:1538)
  85. at java.lang.Thread.run(Thread.java:722)
  86. Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set liquibase-u
  87. pdate-to-latest.xml::20110819-1455-insert-unknown-encounter-role::raff:
  88. Reason: liquibase.exception.DatabaseException: Error executing SQL INSERT INTO encounter_role (
  89. creator, date_created, description, name, retired, uuid) VALUES (1, '2011-08-18 14:00:00.0', 'Unknow
  90. n encounter role for legacy providers with no encounter role set', 'Unknown', FALSE, 'a0b03050-c99b-
  91. 11e0-9572-0800200c9a66'): Referential integrity constraint violation: "ENCOUNTER_ROLE_CREATOR_FK: PU
  92. BLIC.ENCOUNTER_ROLE FOREIGN KEY(CREATOR) REFERENCES PUBLIC.USERS(USER_ID)"; SQL statement:
  93. INSERT INTO encounter_role (creator, date_created, description, name, retired, uuid) VALUES (1, '201
  94. 1-08-18 14:00:00.0', 'Unknown encounter role for legacy providers with no encounter role set', 'Unkn
  95. own', FALSE, 'a0b03050-c99b-11e0-9572-0800200c9a66') [23002-135]:
  96. Caused By: Error executing SQL INSERT INTO encounter_role (creator, date_created, descript
  97. ion, name, retired, uuid) VALUES (1, '2011-08-18 14:00:00.0', 'Unknown encounter role for legacy pro
  98. viders with no encounter role set', 'Unknown', FALSE, 'a0b03050-c99b-11e0-9572-0800200c9a66'): Refer
  99. ential integrity constraint violation: "ENCOUNTER_ROLE_CREATOR_FK: PUBLIC.ENCOUNTER_ROLE FOREIGN KEY
  100. (CREATOR) REFERENCES PUBLIC.USERS(USER_ID)"; SQL statement:
  101. INSERT INTO encounter_role (creator, date_created, description, name, retired, uuid) VALUES (1, '201
  102. 1-08-18 14:00:00.0', 'Unknown encounter role for legacy providers with no encounter role set', 'Unkn
  103. own', FALSE, 'a0b03050-c99b-11e0-9572-0800200c9a66') [23002-135]:
  104. Caused By: Referential integrity constraint violation: "ENCOUNTER_ROLE_CREATOR_FK: PUBLIC.
  105. ENCOUNTER_ROLE FOREIGN KEY(CREATOR) REFERENCES PUBLIC.USERS(USER_ID)"; SQL statement:
  106. INSERT INTO encounter_role (creator, date_created, description, name, retired, uuid) VALUES (1, '201
  107. 1-08-18 14:00:00.0', 'Unknown encounter role for legacy providers with no encounter role set', 'Unkn
  108. own', FALSE, 'a0b03050-c99b-11e0-9572-0800200c9a66') [23002-135]
  109. at liquibase.changelog.ChangeSet.execute(ChangeSet.java:347)
  110. at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27)
  111. at org.openmrs.util.DatabaseUpdater$1OpenmrsUpdateVisitor.visit(DatabaseUpdater.java:202)
  112. at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)
  113. at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:230)
  114. at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:167)
  115. at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:152)
  116. ... 2 more
  117. Caused by: liquibase.exception.DatabaseException: Error executing SQL INSERT INTO encounter_role (cr
  118. eator, date_created, description, name, retired, uuid) VALUES (1, '2011-08-18 14:00:00.0', 'Unknown
  119. encounter role for legacy providers with no encounter role set', 'Unknown', FALSE, 'a0b03050-c99b-11
  120. e0-9572-0800200c9a66'): Referential integrity constraint violation: "ENCOUNTER_ROLE_CREATOR_FK: PUBL
  121. IC.ENCOUNTER_ROLE FOREIGN KEY(CREATOR) REFERENCES PUBLIC.USERS(USER_ID)"; SQL statement:
  122. INSERT INTO encounter_role (creator, date_created, description, name, retired, uuid) VALUES (1, '201
  123. 1-08-18 14:00:00.0', 'Unknown encounter role for legacy providers with no encounter role set', 'Unkn
  124. own', FALSE, 'a0b03050-c99b-11e0-9572-0800200c9a66') [23002-135]
  125. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)
  126. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)
  127. at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1091)
  128. at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:1075)
  129. at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)
  130. ... 8 more
  131. Caused by: org.h2.jdbc.JdbcSQLException: Referential integrity constraint violation: "ENCOUNTER_ROLE
  132. _CREATOR_FK: PUBLIC.ENCOUNTER_ROLE FOREIGN KEY(CREATOR) REFERENCES PUBLIC.USERS(USER_ID)"; SQL state
  133. ment:
  134. INSERT INTO encounter_role (creator, date_created, description, name, retired, uuid) VALUES (1, '201
  135. 1-08-18 14:00:00.0', 'Unknown encounter role for legacy providers with no encounter role set', 'Unkn
  136. own', FALSE, 'a0b03050-c99b-11e0-9572-0800200c9a66') [23002-135]
  137. at org.h2.message.DbException.getJdbcSQLException(DbException.java:327)
  138. at org.h2.message.DbException.get(DbException.java:167)
  139. at org.h2.message.DbException.get(DbException.java:144)
  140. at org.h2.constraint.ConstraintReferential.checkRowOwnTable(ConstraintReferential.java:329)
  141. at org.h2.constraint.ConstraintReferential.checkRow(ConstraintReferential.java:271)
  142. at org.h2.table.Table.fireConstraints(Table.java:788)
  143. at org.h2.table.Table.fireAfterRow(Table.java:805)
  144. at org.h2.command.dml.Insert.insertRows(Insert.java:122)
  145. at org.h2.command.dml.Insert.update(Insert.java:82)
  146. at org.h2.command.CommandContainer.update(CommandContainer.java:70)
  147. at org.h2.command.Command.executeUpdate(Command.java:199)
  148. at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:176)
  149. at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:151)
  150. at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.
  151. java:92)
  152. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
  153. ... 12 more
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!