[
https://issues.apache.org/jira/browse/FINERACT-2595?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Adam Saghy resolved FINERACT-2595.
----------------------------------
Fix Version/s: 1.15.0
Resolution: Fixed
> ERROR: Update or delete on "m_permission" violates foreign key
> "fk8dedb048103b544b" in table "m_role_permission"
> ----------------------------------------------------------------------------------------------------------------
>
> Key: FINERACT-2595
> URL: https://issues.apache.org/jira/browse/FINERACT-2595
> Project: Apache Fineract
> Issue Type: Bug
> Reporter: Blanca Mendoza
> Priority: Major
> Fix For: 1.15.0
>
>
> 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)=(678) todavía es referida desde
> la tabla «m_role_permission». [Failed SQL: (0) DELETE FROM
> public.m_permission WHERE code='INACTIVATE_CLIENTCHARGE_CHECKER']
> fineract-server-1 | at
> liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:520)
> fineract-server-1 | at
> liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:85)
> fineract-server-1 | at
> liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:188)
> fineract-server-1 | at
> liquibase.executor.AbstractExecutor.execute(AbstractExecutor.java:148)
> fineract-server-1 | at
> liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1198)
> fineract-server-1 | at
> liquibase.changelog.ChangeSet.execute(ChangeSet.java:816)
> fineract-server-1 | ... 47 common frames omitted
> fineract-server-1 | Caused by: org.postgresql.util.PSQLException: 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)=(678) todavía es referida desde
> la tabla «m_role_permission».
> fineract-server-1 | at
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2846)
> fineract-server-1 | at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2531)
> fineract-server-1 | at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:429)
> fineract-server-1 | at
> org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:526)
> fineract-server-1 | at
> org.postgresql.jdbc.PgStatement.execute(PgStatement.java:436)
> fineract-server-1 | at
> org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:358)
> fineract-server-1 | at
> org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:343)
> fineract-server-1 | at
> org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:319)
> fineract-server-1 | at
> org.postgresql.jdbc.PgStatement.execute(PgStatement.java:314)
> fineract-server-1 | at
> com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:95)
> fineract-server-1 | at
> com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java)
> fineract-server-1 | at
> liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:512)
> fineract-server-1 | ... 52 common frames omitted
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
