Blanca Mendoza created FINERACT-2595:
----------------------------------------
Summary: 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
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)
