Symantec Access Management

Tech Tip : CA Single Sign-On : AdminUI reports : The statement was aborted because it would have caused a duplicate key value

  • 1.  Tech Tip : CA Single Sign-On : AdminUI reports : The statement was aborted because it would have caused a duplicate key value

    Posted 05-13-2019 04:55 AM

    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