Blanca Mendoza created FINERACT-2594:
----------------------------------------
Summary: ERROR: Updating or deleting on "m_permission" violates
foreign key
Key: FINERACT-2594
URL: https://issues.apache.org/jira/browse/FINERACT-2594
Project: Apache Fineract
Issue Type: Bug
Reporter: Blanca Mendoza
fineract-server-1 | ... 6 common frames omitted
fineract-server-1 | Caused by: liquibase.exception.LiquibaseException:
liquibase.exception.MigrationFailedException: Migration failed for changeset
db/changelog/tenant/parts/0231_remove_clientcharge_inactivate_permissions.xml::1::ashharahmadkhan:
fineract-server-1 | Reason: liquibase.exception.DatabaseException: ERROR:
update o delete en «m_permission» viola la llave foránea «fk8dedb048103b544b»
en la tabla «m_role_permission»
fineract-server-1 | Detail: La llave (id)=(672) todavía es referida desde la
tabla «m_role_permission». [Failed SQL: (0) DELETE FROM public.m_permission
WHERE code='INACTIVATE_CLIENTCHARGE']
fineract-server-1 | at
liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:155)
fineract-server-1 | at
liquibase.command.core.AbstractUpdateCommandStep.lambda$run$0(AbstractUpdateCommandStep.java:114)
fineract-server-1 | at liquibase.Scope.lambda$child$0(Scope.java:216)
fineract-server-1 | at liquibase.Scope.child(Scope.java:225)
fineract-server-1 | at liquibase.Scope.child(Scope.java:215)
fineract-server-1 | at liquibase.Scope.child(Scope.java:194)
fineract-server-1 | at
liquibase.command.core.AbstractUpdateCommandStep.run(AbstractUpdateCommandStep.java:112)
fineract-server-1 | at
liquibase.command.core.UpdateCommandStep.run(UpdateCommandStep.java:100)
fineract-server-1 | at
liquibase.command.CommandScope.lambda$execute$6(CommandScope.java:263)
fineract-server-1 | ... 24 common frames omitted
fineract-server-1 | Caused by: liquibase.exception.MigrationFailedException:
Migration failed for changeset
db/changelog/tenant/parts/0231_remove_clientcharge_inactivate_permissions.xml::1::ashharahmadkhan:
fineract-server-1 | Reason: liquibase.exception.DatabaseException: ERROR:
update o delete en «m_permission» viola la llave foránea «fk8dedb048103b544b»
en la tabla «m_role_permission»
fineract-server-1 | Detail: La llave (id)=(672) todavía es referida desde la
tabla «m_role_permission». [Failed SQL: (0) DELETE FROM public.m_permission
WHERE code='INACTIVATE_CLIENTCHARGE']
fineract-server-1 | at
liquibase.changelog.ChangeSet.execute(ChangeSet.java:873)
fineract-server-1 | at
liquibase.changelog.visitor.UpdateVisitor.executeAcceptedChange(UpdateVisitor.java:127)
fineract-server-1 | at
liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:71)
fineract-server-1 | at
liquibase.changelog.ChangeLogIterator.lambda$run$0(ChangeLogIterator.java:133)
fineract-server-1 | at liquibase.Scope.lambda$child$0(Scope.java:216)
fineract-server-1 | at liquibase.Scope.child(Scope.java:225)
fineract-server-1 | at liquibase.Scope.child(Scope.java:215)
fineract-server-1 | at liquibase.Scope.child(Scope.java:194)
fineract-server-1 | at
liquibase.changelog.ChangeLogIterator.lambda$run$1(ChangeLogIterator.java:122)
fineract-server-1 | at liquibase.Scope.lambda$child$0(Scope.java:216)
fineract-server-1 | at liquibase.Scope.child(Scope.java:225)
fineract-server-1 | at liquibase.Scope.child(Scope.java:215)
fineract-server-1 | at liquibase.Scope.child(Scope.java:194)
fineract-server-1 | at liquibase.Scope.child(Scope.java:282)
fineract-server-1 | at liquibase.Scope.child(Scope.java:286)
fineract-server-1 | at
liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:91)
fineract-server-1 | ... 32 common frames omitted
fineract-server-1 | Caused by: liquibase.exception.DatabaseException: ERROR:
update o delete en «m_permission» viola la llave foránea «fk8dedb048103b544b»
en la tabla «m_role_permission»
fineract-server-1 | Detail: La llave (id)=(672) todavía es referida desde la
tabla «m_role_permission». [Failed SQL: (0) DELETE FROM public.m_permission
WHERE code='INACTIVATE_CLIENTCHARGE']
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
