[
https://issues.apache.org/jira/browse/FINERACT-2594?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Adam Saghy updated FINERACT-2594:
---------------------------------
Labels: beginner beginner-friendly (was: )
> 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
> Priority: Major
> Labels: beginner, beginner-friendly
>
>
> 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)
