"ORA-00001: unique constraint (OOTB_EN.INDEX$TPS_LIC_AUDIT_ITEM$T) violated" error when changing group etc

Version 3

    Verified Product Versions

    LANDESK Service Desk 2016.x

    Problem

    On a Oracle Environment, when changing the group in console or amending a users Group in administration you see the follow error upon save:

     

    ORA-00001: unique constraint (OOTB_EN.INDEX$TPS_LIC_AUDIT_ITEM$T) violated

    Answer

     

    Please have the below script run by your Oracle DB administrator against your DB, ensuring a full backup has been done and everyone is logged out of the system.  Where possible test on a test system before applying to live.

     

     

    DROP INDEX index$tps_lic_audit_item$t ON tps_licence_audit_item;

    CREATE INDEX index$tps_lic_audit_item$t ON tps_licence_audit_item(tps_title);

     

    Note: If the above script errors with the message "ORA-00955: name is already used by an existing object", then use this script:

     

    DROP INDEX index$tps_lic_audit_item$t;

    CREATE INDEX index$tps_lic_audit_item$t ON tps_licence_audit_item(tps_title);

     

    This was recorded as Problem: 3350 which was fixed in version 7.3.1

     

     

    Environment

    ITBM 7.2.4 onwards

    Oracle 10g

     

     

    Please refer to this document if you are receiving a different error message but doing the same thing ie.  Changing group etc...

    http://community.landesk.com/support/docs/DOC-4217