You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-user@portals.apache.org by massimo malvestio <ma...@cardinis.com> on 2006/11/02 18:05:16 UTC

jetspeed 2 remove remote principal exception

Hi all!
Before writing this mail I checked on Jira and userlist but I didn't 
find anything about what I'm going to ask. If I'm on error please pardon me.

Platform: 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

Expected behaviour
System should add association for the user

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'.

This is not a proof of concept, because it can happen that I have to add 
a user, I delete her and later I had to re-add her, maybe a hiring - 
discharge - hiring cycle.
It seems that associations are not truly removed, but only hidden.

Moreover I think that would be correct that when I remove a user, all 
remote association are removed, or not?
Thanks all for answers.

-- 
Massimo Malvestio
Software Developer
massimo.malvestio@cardinis.com
_______________________________________________
CARDINIS Solutions SpA
Your Governance Solutions
via San Crispino, 46    I-35129 Padova - Italy
tel.(+39) 049.7803370/8072095
fax (+39) 049.7800824
www.cardinis.com

---
Questo messaggio è strettamente riservato ai destinatari specificati.
Se è ricevuto per errore si prega di avvisare il mittente e di cancellarlo
dal proprio sistema.
-
This message is specifically addressed to the recipient(s).
Should you receive it by mistake, please notify the sender and delete it
from your system. 


---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-user-help@portals.apache.org


Re: jetspeed 2 remove remote principal exception

Posted by massimo malvestio <ma...@cardinis.com>.
> That sounds like a bug in the SSO component
> Please create a JIRA issue
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
> For additional commands, e-mail: jetspeed-user-help@portals.apache.org
1) I' have recreated the same bug on another deployment.
2) If it can help, the jar has been downloaded 2006/04/14
3) Bug has been discovered by my coworker Umberto Mantello

-- 
Massimo Malvestio
Software Developer
massimo.malvestio@cardinis.com
_______________________________________________
CARDINIS Solutions SpA
Your Governance Solutions
via San Crispino, 46    I-35129 Padova - Italy
tel.(+39) 049.7803370/8072095
fax (+39) 049.7800824
www.cardinis.com

---
Questo messaggio è strettamente riservato ai destinatari specificati.
Se è ricevuto per errore si prega di avvisare il mittente e di cancellarlo
dal proprio sistema.
-
This message is specifically addressed to the recipient(s).
Should you receive it by mistake, please notify the sender and delete it
from your system. 


---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-user-help@portals.apache.org


Re: jetspeed 2 remove remote principal exception

Posted by David Sean Taylor <da...@bluesunrise.com>.
massimo malvestio wrote:
> Hi all!
> Before writing this mail I checked on Jira and userlist but I didn't 
> find anything about what I'm going to ask. If I'm on error please pardon 
> me.
> 
> Platform: 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
> 
> Expected behaviour
> System should add association for the user
> 
> 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'.
> 
That sounds like a bug in the SSO component
Please create a JIRA issue

---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-user-help@portals.apache.org