[
https://issues.apache.org/jira/browse/SYNCOPE-1131?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16064982#comment-16064982
]
ASF subversion and git services commented on SYNCOPE-1131:
----------------------------------------------------------
Commit cfb6c638d570536233743cca16a5498dcceea6ce in syncope's branch
refs/heads/master from [~ilgrosso]
[ https://git-wip-us.apache.org/repos/asf?p=syncope.git;h=cfb6c63 ]
[SYNCOPE-1131] Missing resource removal before delete (for realms)
> 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)
