[rt-users] Issue while creating a ticket

[Ahalya_Nathan at mudnebr.com]

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 (Status, Queue, 
Started, Type, InitialPriority, Starts, id, LastUpdated, Subject, 
FinalPriority, Creator, Owner, LastUpdatedBy, Resolved, Created, Priority, 
Due) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)" with 
ParamValues: :p5='91', :p12='3919', :p8='2005-06-27 14:27:31', 
:p14='1970-01-01 00:00:00', :p10='99', :p13='3919', :p16='91', :p2='54', 
:p3='1970-01-01 00:00:00', :p6='1970-01-01 00:00:00', :p15='2005-06-27 
14:27:31', :p1='new', :p7='150', :p17='2005-06-28 14:27:31', :p4='ticket', 
:p9='Test', :p11='3919'] at 
/usr/local/lib/perl5/site_perl/5.8.6/DBIx/SearchBuilder/Handle.pm line 
480, <GEN17> line 105.
 (/usr/local/rt/lib/RT.pm:277)
[Mon Jun 27 14:27:31 2005] [warning]: RT::Handle=HASH(0xacb2a50) couldn't 
execute the query 'INSERT INTO Tickets (Status, Queue, Started, Type, 
InitialPriority, Starts, id, LastUpdated, Subject, FinalPriority, Creator, 
Owner, LastUpdatedBy, Resolved, Created, Priority, Due) VALUES (?, ?, ?, 
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' at 
/usr/local/lib/perl5/site_perl/5.8.6/DBIx/SearchBuilder/Handle.pm line 
494, <GEN17> line 105.
 (/usr/local/rt/lib/RT.pm:277)
[Mon Jun 27 14:27:31 2005] [crit]: Couldn't create a ticket: Object could 
not be created (/usr/local/rt/lib/RT/Ticket_Overlay.pm:590)

Regards,
Ahalya Nathan
Senior Programmer / Analyst
Information Technology, Metropolitan Utilities District 
(402) 449-8218 phone
(402) 449-8131 fax
ahalya_nathan at mudnebr.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20050627/4b9c6987/attachment.htm>