Issue:
We're running AdminUI, and when we try to access to any Task panel,
then the AdminUI reports error in the browser :
Error: 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 'FK_TASKSESSION12_5_TASKSESSION12_5' defined on
'TASKSESSION12_5'.
Server.log :
Caused by: java.sql.SQLException: 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 'FK_TASKSESSION12_5_TASKSESSION12_5' defined on 'TASKSESSION12_5'.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
How can we solve this ?
Resolution:
On the AdminUI :
Rename /server/default/data/derby/siteminder/taskpersistence;
On the Policy Server run :
# Xpsregclient <policy_server_name> -adminui -su
Restart the Policy server and AdminUI to solve the issue.
KB : KB000132089