API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Aug 29th, 2016
65
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.89 KB | None | 0 0
raw download clone embed print report
  1. SEVERE 29.08.16 21:52: liquibase: assemblyChangelog.xml: /opt/R1/share/n2o-liquibase/liquibase/db/changelog/201606301800_init_sickdoc.xml::n_init_table_sickdoc.rf_position_link::dbilalov: Change Set /opt/R1/share/n2o-liquibase/liquibase/db/changelog/201606301800_init_sickdoc.xml::n_init_table_sickdoc.rf_position_link::dbilalov failed. Error: ERROR: null value in column "position_role_id" violates not-null constraint
  2. Подробности: Failing row contains (3, null). [Failed SQL: INSERT INTO sickdoc.rf_position_link VALUES (
  3. (select id from sickdoc.rf_position_name where lower(name) = 'терап'),
  4. coalesce((select id from pim_position_role where lower(name) = 'врач-терапевт' and (to_dt is null or to_dt >= current_date)),
  5. (select id from pim_position_role where lower(name) = 'врач-терапевт' limit 1)) )]
  6. liquibase.exception.DatabaseException: ERROR: null value in column "position_role_id" violates not-null constraint
  7. Подробности: Failing row contains (3, null). [Failed SQL: INSERT INTO sickdoc.rf_position_link VALUES (
  8. (select id from sickdoc.rf_position_name where lower(name) = 'терап'),
  9. coalesce((select id from pim_position_role where lower(name) = 'врач-терапевт' and (to_dt is null or to_dt >= current_date)),
  10. (select id from pim_position_role where lower(name) = 'врач-терапевт' limit 1)) )]
  11. at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:316)
  12. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
  13. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:122)
  14. at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1247)
  15. at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1230)
  16. at liquibase.changelog.ChangeSet.execute(ChangeSet.java:548)
  17. at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:51)
  18. at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:73)
  19. at liquibase.Liquibase.update(Liquibase.java:210)
  20. at liquibase.Liquibase.update(Liquibase.java:190)
  21. at liquibase.integration.commandline.Main.doMigration(Main.java:1096)
  22. at liquibase.integration.commandline.Main.run(Main.java:180)
  23. at liquibase.integration.commandline.Main.main(Main.java:99)
  24. Caused by: org.postgresql.util.PSQLException: ERROR: null value in column "position_role_id" violates not-null constraint
  25. Подробности: Failing row contains (3, null).
  26. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2161)
  27. at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1890)
  28. at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
  29. at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:560)
  30. at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:403)
  31. at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:395)
  32. at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:314)
  33. ... 12 more
  34. INFO 29.08.16 21:52: liquibase: /opt/R1/share/n2o-liquibase/liquibase/db/changelog/201606301800_init_sickdoc.xml::n_init_table_sickdoc.rf_position_link::dbilalov: Successfully released change log lock
  35. Unexpected error running Liquibase: ERROR: null value in column "position_role_id" violates not-null constraint
  36. Подробности: Failing row contains (3, null). [Failed SQL: INSERT INTO sickdoc.rf_position_link VALUES (
  37. (select id from sickdoc.rf_position_name where lower(name) = 'терап'),
  38. coalesce((select id from pim_position_role where lower(name) = 'врач-терапевт' and (to_dt is null or to_dt >= current_date)),
  39. (select id from pim_position_role where lower(name) = 'врач-терапевт' limit 1)) )]
  40.  
  41. SEVERE 29.08.16 21:52: liquibase: /opt/R1/share/n2o-liquibase/liquibase/db/changelog/201606301800_init_sickdoc.xml::n_init_table_sickdoc.rf_position_link::dbilalov: ERROR: null value in column "position_role_id" violates not-null constraint
  42. Подробности: Failing row contains (3, null). [Failed SQL: INSERT INTO sickdoc.rf_position_link VALUES (
  43. (select id from sickdoc.rf_position_name where lower(name) = 'терап'),
  44. coalesce((select id from pim_position_role where lower(name) = 'врач-терапевт' and (to_dt is null or to_dt >= current_date)),
  45. (select id from pim_position_role where lower(name) = 'врач-терапевт' limit 1)) )]
  46. liquibase.exception.MigrationFailedException: Migration failed for change set /opt/R1/share/n2o-liquibase/liquibase/db/changelog/201606301800_init_sickdoc.xml::n_init_table_sickdoc.rf_position_link::dbilalov:
  47. Reason: liquibase.exception.DatabaseException: ERROR: null value in column "position_role_id" violates not-null constraint
  48. Подробности: Failing row contains (3, null). [Failed SQL: INSERT INTO sickdoc.rf_position_link VALUES (
  49. (select id from sickdoc.rf_position_name where lower(name) = 'терап'),
  50. coalesce((select id from pim_position_role where lower(name) = 'врач-терапевт' and (to_dt is null or to_dt >= current_date)),
  51. (select id from pim_position_role where lower(name) = 'врач-терапевт' limit 1)) )]
  52. at liquibase.changelog.ChangeSet.execute(ChangeSet.java:584)
  53. at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:51)
  54. at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:73)
  55. at liquibase.Liquibase.update(Liquibase.java:210)
  56. at liquibase.Liquibase.update(Liquibase.java:190)
  57. at liquibase.integration.commandline.Main.doMigration(Main.java:1096)
  58. at liquibase.integration.commandline.Main.run(Main.java:180)
  59. at liquibase.integration.commandline.Main.main(Main.java:99)
  60. Caused by: liquibase.exception.DatabaseException: ERROR: null value in column "position_role_id" violates not-null constraint
  61. Подробности: Failing row contains (3, null). [Failed SQL: INSERT INTO sickdoc.rf_position_link VALUES (
  62. (select id from sickdoc.rf_position_name where lower(name) = 'терап'),
  63. coalesce((select id from pim_position_role where lower(name) = 'врач-терапевт' and (to_dt is null or to_dt >= current_date)),
  64. (select id from pim_position_role where lower(name) = 'врач-терапевт' limit 1)) )]
  65. at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:316)
  66. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
  67. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:122)
  68. at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1247)
  69. at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1230)
  70. at liquibase.changelog.ChangeSet.execute(ChangeSet.java:548)
  71. ... 7 more
  72. Caused by: org.postgresql.util.PSQLException: ERROR: null value in column "position_role_id" violates not-null constraint
  73. Подробности: Failing row contains (3, null).
  74. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2161)
  75. at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1890)
  76. at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
  77. at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:560)
  78. at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:403)
  79. at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:395)
  80. at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:314)
  81. ... 12 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!