API tools faq
paste
Advertisement
k-joseph

Untitled

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