[JS2-833] associations between portal and remote principal are not removed

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.1.2
• Fix Version/s: 2.1.3, 2.2.0
• Component/s: SSO
• Assignee: Ate Douma
• Reporter: Ate Douma
• Created: 19/Dec/07 12:20
• Updated: 04/Oct/11 21:08
• Resolved: 19/Dec/07 12:38

Description

Following description copied from JS1-563 (the Jetspeed-1 which was accidentally created while this concerns Jetspeed-2):

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

• relates to: JS1-563 associations between portal and remote principal are not removed