[rt-users] Issue while creating a ticket

[Stephen Turner]

At Monday 6/27/2005 10:54 AM, Ahalya_Nathan at mudnebr.com wrote:

>Hi all,
>I am getting this error while creating a ticket. Has anyone faced such a 
>problem till now?
>
>[Mon Jun 27 14:27:31 2005] [warning]: DBD::Oracle::st execute failed: 
>ORA-00001: unique constraint (RT.TICKETS_KEY) violated (DBD ERROR: 
>OCIStmtExecute) [for Statement "INSERT INTO Tickets

Ahalya,

Sounds like your sequences are messed up - the sequence that's used to 
generate ticket ids needs to be set higher than the highest existing ticket id.

Also, if you have this problem on the tickets table it's very possible you 
have it on other tables too - you should chekc.

Steve