[
https://issues.apache.org/jira/browse/SYNCOPE-1131?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Francesco Chicchiriccò resolved SYNCOPE-1131.
---------------------------------------------
Resolution: Fixed
> Cannot delete resources owned by realms
> ---------------------------------------
>
> Key: SYNCOPE-1131
> URL: https://issues.apache.org/jira/browse/SYNCOPE-1131
> Project: Syncope
> Issue Type: Bug
> Components: core
> Affects Versions: 2.0.3
> Reporter: Francesco Chicchiriccò
> Assignee: Francesco Chicchiriccò
> Fix For: 2.0.4, 2.1.0
>
>
> When attempting to delete a resource assigned to one or more realms, an error
> is reported:
> {code}
> Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: ERROR: update
> or delete on table "externalresource" violates foreign key constraint
> "realm_externalresource_resource_id_fkey" on table "realm_externalresource"
> Detail: Key (id)=(XXXX) is still referenced from table
> "realm_externalresource". {prepstmnt 1989356175 DELETE FROM ExternalResource
> WHERE id = ?} [code=0, state=23503]
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
