API tools faq
paste
Advertisement
k-joseph

Untitled

k-joseph
Jan 16th, 2014
52
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 11.06 KB | None | 0 0
raw download clone embed print report
  1. Database1_9To1_10UpgradeTest.shouldMigrateDrugOrders
  2. shouldMigrateDrugOrders(org.openmrs.util.databasechange.Database1_9To1_10UpgradeTest)
  3. java.io.IOException: liquibase.exception.MigrationFailedException: Migration failed for change set liquibase-update-to-latest.xml::201401151532-TRUNK-4202::k-joseph:
  4. Reason: liquibase.exception.DatabaseException: Error executing SQL INSERT INTO provider(person_id, identifier, creator, date_created, retired, uuid)
  5. SELECT (SELECT orderer FROM orders WHERE orderer NOT IN (SELECT person_id FROM provider)),
  6. CONCAT( "prov: ", SUBSTRING((SELECT uuid FROM person where person_id = (select orderer from orders)), 5)) , 1, CURRENT_TIMESTAMP , false, UUID()
  7. FROM orders
  8. WHERE orderer NOT IN (SELECT person_id FROM provider): Function "UUID" not found; SQL statement:
  9. INSERT INTO provider(person_id, identifier, creator, date_created, retired, uuid)
  10. SELECT (SELECT orderer FROM orders WHERE orderer NOT IN (SELECT person_id FROM provider)),
  11. CONCAT( "prov: ", SUBSTRING((SELECT uuid FROM person where person_id = (select orderer from orders)), 5)) , 1, CURRENT_TIMESTAMP , false, UUID()
  12. FROM orders
  13. WHERE orderer NOT IN (SELECT person_id FROM provider) [90022-135]:
  14. Caused By: Error executing SQL INSERT INTO provider(person_id, identifier, creator, date_created, retired, uuid)
  15. SELECT (SELECT orderer FROM orders WHERE orderer NOT IN (SELECT person_id FROM provider)),
  16. CONCAT( "prov: ", SUBSTRING((SELECT uuid FROM person where person_id = (select orderer from orders)), 5)) , 1, CURRENT_TIMESTAMP , false, UUID()
  17. FROM orders
  18. WHERE orderer NOT IN (SELECT person_id FROM provider): Function "UUID" not found; SQL statement:
  19. INSERT INTO provider(person_id, identifier, creator, date_created, retired, uuid)
  20. SELECT (SELECT orderer FROM orders WHERE orderer NOT IN (SELECT person_id FROM provider)),
  21. CONCAT( "prov: ", SUBSTRING((SELECT uuid FROM person where person_id = (select orderer from orders)), 5)) , 1, CURRENT_TIMESTAMP , false, UUID()
  22. FROM orders
  23. WHERE orderer NOT IN (SELECT person_id FROM provider) [90022-135]:
  24. Caused By: Function "UUID" not found; SQL statement:
  25. INSERT INTO provider(person_id, identifier, creator, date_created, retired, uuid)
  26. SELECT (SELECT orderer FROM orders WHERE orderer NOT IN (SELECT person_id FROM provider)),
  27. CONCAT( "prov: ", SUBSTRING((SELECT uuid FROM person where person_id = (select orderer from orders)), 5)) , 1, CURRENT_TIMESTAMP , false, UUID()
  28. FROM orders
  29. WHERE orderer NOT IN (SELECT person_id FROM provider) [90022-135]
  30. at org.openmrs.util.databasechange.DatabaseUpgradeTestUtil.upgrade(DatabaseUpgradeTestUtil.java:219)
  31. at org.openmrs.util.databasechange.Database1_9To1_10UpgradeTest.shouldMigrateDrugOrders(Database1_9To1_10UpgradeTest.java:87)
  32. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  33. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  34. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  35. at java.lang.reflect.Method.invoke(Method.java:616)
  36. at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:47)
  37. at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
  38. at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:44)
  39. at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
  40. at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
  41. at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27)
  42. at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:271)
  43. at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:70)
  44. at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:50)
  45. at org.junit.runners.ParentRunner$3.run(ParentRunner.java:238)
  46. at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:63)
  47. at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:236)
  48. at org.junit.runners.ParentRunner.access$000(ParentRunner.java:53)
  49. at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:229)
  50. at org.junit.runners.ParentRunner.run(ParentRunner.java:309)
  51. at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:50)
  52. at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
  53. at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467)
  54. at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)
  55. at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)
  56. at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)
  57. Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set liquibase-update-to-latest.xml::201401151532-TRUNK-4202::k-joseph:
  58. Reason: liquibase.exception.DatabaseException: Error executing SQL INSERT INTO provider(person_id, identifier, creator, date_created, retired, uuid)
  59. SELECT (SELECT orderer FROM orders WHERE orderer NOT IN (SELECT person_id FROM provider)),
  60. CONCAT( "prov: ", SUBSTRING((SELECT uuid FROM person where person_id = (select orderer from orders)), 5)) , 1, CURRENT_TIMESTAMP , false, UUID()
  61. FROM orders
  62. WHERE orderer NOT IN (SELECT person_id FROM provider): Function "UUID" not found; SQL statement:
  63. INSERT INTO provider(person_id, identifier, creator, date_created, retired, uuid)
  64. SELECT (SELECT orderer FROM orders WHERE orderer NOT IN (SELECT person_id FROM provider)),
  65. CONCAT( "prov: ", SUBSTRING((SELECT uuid FROM person where person_id = (select orderer from orders)), 5)) , 1, CURRENT_TIMESTAMP , false, UUID()
  66. FROM orders
  67. WHERE orderer NOT IN (SELECT person_id FROM provider) [90022-135]:
  68. Caused By: Error executing SQL INSERT INTO provider(person_id, identifier, creator, date_created, retired, uuid)
  69. SELECT (SELECT orderer FROM orders WHERE orderer NOT IN (SELECT person_id FROM provider)),
  70. CONCAT( "prov: ", SUBSTRING((SELECT uuid FROM person where person_id = (select orderer from orders)), 5)) , 1, CURRENT_TIMESTAMP , false, UUID()
  71. FROM orders
  72. WHERE orderer NOT IN (SELECT person_id FROM provider): Function "UUID" not found; SQL statement:
  73. INSERT INTO provider(person_id, identifier, creator, date_created, retired, uuid)
  74. SELECT (SELECT orderer FROM orders WHERE orderer NOT IN (SELECT person_id FROM provider)),
  75. CONCAT( "prov: ", SUBSTRING((SELECT uuid FROM person where person_id = (select orderer from orders)), 5)) , 1, CURRENT_TIMESTAMP , false, UUID()
  76. FROM orders
  77. WHERE orderer NOT IN (SELECT person_id FROM provider) [90022-135]:
  78. Caused By: Function "UUID" not found; SQL statement:
  79. INSERT INTO provider(person_id, identifier, creator, date_created, retired, uuid)
  80. SELECT (SELECT orderer FROM orders WHERE orderer NOT IN (SELECT person_id FROM provider)),
  81. CONCAT( "prov: ", SUBSTRING((SELECT uuid FROM person where person_id = (select orderer from orders)), 5)) , 1, CURRENT_TIMESTAMP , false, UUID()
  82. FROM orders
  83. WHERE orderer NOT IN (SELECT person_id FROM provider) [90022-135]
  84. at liquibase.changelog.ChangeSet.execute(ChangeSet.java:347)
  85. at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27)
  86. at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)
  87. at liquibase.Liquibase.update(Liquibase.java:114)
  88. at org.openmrs.util.databasechange.DatabaseUpgradeTestUtil.upgrade(DatabaseUpgradeTestUtil.java:214)
  89. ... 26 more
  90. Caused by: liquibase.exception.DatabaseException: Error executing SQL INSERT INTO provider(person_id, identifier, creator, date_created, retired, uuid)
  91. SELECT (SELECT orderer FROM orders WHERE orderer NOT IN (SELECT person_id FROM provider)),
  92. CONCAT( "prov: ", SUBSTRING((SELECT uuid FROM person where person_id = (select orderer from orders)), 5)) , 1, CURRENT_TIMESTAMP , false, UUID()
  93. FROM orders
  94. WHERE orderer NOT IN (SELECT person_id FROM provider): Function "UUID" not found; SQL statement:
  95. INSERT INTO provider(person_id, identifier, creator, date_created, retired, uuid)
  96. SELECT (SELECT orderer FROM orders WHERE orderer NOT IN (SELECT person_id FROM provider)),
  97. CONCAT( "prov: ", SUBSTRING((SELECT uuid FROM person where person_id = (select orderer from orders)), 5)) , 1, CURRENT_TIMESTAMP , false, UUID()
  98. FROM orders
  99. WHERE orderer NOT IN (SELECT person_id FROM provider) [90022-135]
  100. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)
  101. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)
  102. at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1091)
  103. at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:1075)
  104. at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)
  105. ... 30 more
  106. Caused by: org.h2.jdbc.JdbcSQLException: Function "UUID" not found; SQL statement:
  107. INSERT INTO provider(person_id, identifier, creator, date_created, retired, uuid)
  108. SELECT (SELECT orderer FROM orders WHERE orderer NOT IN (SELECT person_id FROM provider)),
  109. CONCAT( "prov: ", SUBSTRING((SELECT uuid FROM person where person_id = (select orderer from orders)), 5)) , 1, CURRENT_TIMESTAMP , false, UUID()
  110. FROM orders
  111. WHERE orderer NOT IN (SELECT person_id FROM provider) [90022-135]
  112. at org.h2.message.DbException.getJdbcSQLException(DbException.java:327)
  113. at org.h2.message.DbException.get(DbException.java:167)
  114. at org.h2.message.DbException.get(DbException.java:144)
  115. at org.h2.command.Parser.readJavaFunction(Parser.java:1947)
  116. at org.h2.command.Parser.readFunction(Parser.java:1991)
  117. at org.h2.command.Parser.readTerm(Parser.java:2291)
  118. at org.h2.command.Parser.readFactor(Parser.java:1873)
  119. at org.h2.command.Parser.readSum(Parser.java:1860)
  120. at org.h2.command.Parser.readConcat(Parser.java:1833)
  121. at org.h2.command.Parser.readCondition(Parser.java:1707)
  122. at org.h2.command.Parser.readAnd(Parser.java:1688)
  123. at org.h2.command.Parser.readExpression(Parser.java:1680)
  124. at org.h2.command.Parser.parseSelectSimpleSelectPart(Parser.java:1595)
  125. at org.h2.command.Parser.parseSelectSimple(Parser.java:1625)
  126. at org.h2.command.Parser.parseSelectSub(Parser.java:1530)
  127. at org.h2.command.Parser.parseSelectUnion(Parser.java:1375)
  128. at org.h2.command.Parser.parseSelect(Parser.java:1363)
  129. at org.h2.command.Parser.parseInsert(Parser.java:943)
  130. at org.h2.command.Parser.parsePrepared(Parser.java:365)
  131. at org.h2.command.Parser.parse(Parser.java:278)
  132. at org.h2.command.Parser.parse(Parser.java:250)
  133. at org.h2.command.Parser.prepareCommand(Parser.java:222)
  134. at org.h2.engine.Session.prepareLocal(Session.java:420)
  135. at org.h2.engine.Session.prepareCommand(Session.java:381)
  136. at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1071)
  137. at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:163)
  138. at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:151)
  139. at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92)
  140. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
  141. ... 34 more
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!