Getting the following error when trying to change the status of the CSR and saving it:
Unable to insert into CSR_QUEUE_HIST.ORA-00001:unique constraint (STAT>CSR_QUEUE_HIST_PK1) violated
RESOLUTION:
Run the two queries again against the CSR_QUEUE_HIST table and if the condition is as described below, update the sequence using the MaxID+1. (i.e. if your MaxID is 240, then enter 241 in Stat)
1. Run the sql below against the stat db:
a. SELECT MAX(ID) FROM CSR_QUEUE_HIST;
b. SELECT last_number from user_sequences where sequence_name = 'CSR_QUEUE_HIST_SEQ1';
2. Take a look at the results from queries (a)MaxID & (b)LastNumber. Query (b) results should be larger then query (a). For example, if the MaxID return 240 and LastNumber return 220 then use step #3 to drop/recreate the sequence. (i.e. if your MaxID is 240, enter 241 for "START WITH."
3. DROP SEQUENCE STAT.CSR_QUEUE_HIST_SEQ1;
CREATE SEQUENCE STAT.CSR_QUEUE_HIST_SEQ1
START WITH <MaxID+1>
MAXVALUE 999999999999999999999999999
MINVALUE 1
NOCYCLE
NOCACHE
NOORDER
Open a CSR and monitor the History tab to see if there are updated information.
