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)

Reply via email to