[JS1-563] associations between portal and remote principal are not removed

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Invalid
• Component/s: Security
• Environment: Jetspeed 2
• Assignee: Unassigned
• Reporter: cardinis solutions spa
• Created: 03/Nov/06 08:38
• Updated: 19/Dec/07 12:23
• Resolved: 19/Dec/07 12:23

Description

Steps to repro
1) add user to portal
2) add remote association
3) remove association
4) remove user
5) add deleted user
6) add remote association

After each step a logout - login has been made

Expected behaviour
System should add association for the principal

Observed behaviour
Following exception:
Could not add credentials: org.apache.jetspeed.sso.SSOException: Failed
to store site info in
database.org.springframework.dao.DataIntegrityViolationException: (OJB
operation): data integrity violated by SQL ''; nested exception is
org.apache.derby.impl.jdbc.EmbedSQLException: The statement was aborted
because it would have caused a duplicate key value in a unique or
primary key constraint or unique index identified by
'SQL060615102425631' defined on 'SECURITY_PRINCIPAL'.

Issue Links

• is related to: JS2-833 associations between portal and remote principal are not removed