[rt-users] Issue while creating a ticket

Ahalya_Nathan at mudnebr.com Ahalya_Nathan at mudnebr.com
Mon Jun 27 10:54:20 EDT 2005


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>


More information about the rt-users mailing list