[
https://issues.apache.org/jira/browse/SYNCOPE-1131?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16064981#comment-16064981
]
ASF subversion and git services commented on SYNCOPE-1131:
----------------------------------------------------------
Commit 16cf99b5354efdc36a7f519a66fc12005dd8b892 in syncope's branch
refs/heads/2_0_X from [~ilgrosso]
[ https://git-wip-us.apache.org/repos/asf?p=syncope.git;h=16cf99b ]
[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)
