AdminUI reports : The statement was aborted because it would have caused a duplicate key value

book

Article ID: 132089

calendar_today

Updated On:

Products

CA Single Sign On Secure Proxy Server (SiteMinder) AXIOMATICS POLICY SERVER CA Single Sign On SOA Security Manager (SiteMinder) CA Single Sign-On

Issue/Introduction

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 ?

Environment

Release: MSPPSF99000-12.51-Single Sign-On-Agent for Oracle PeopleSoft-MSP
Component:

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.