You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@syncope.apache.org by "Francesco Chicchiriccò (JIRA)" <ji...@apache.org> on 2017/06/27 15:09:00 UTC

[jira] [Created] (SYNCOPE-1131) Cannot delete resources owned by realms

Francesco Chicchiriccò created SYNCOPE-1131:
-----------------------------------------------

             Summary: 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)