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

Version 3

    Verified Product Versions

    Service Desk 2016.x


    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



    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




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