[rt-users] RT error using API in program

Jesse Vincent jesse at bestpractical.com
Tue Dec 23 12:35:35 EST 2008




On Mon, Dec 01, 2008 at 01:07:24PM -0800, Kenneth Crocker wrote:
> To all,
> 
> 
> 	We are writing a program to move an old legacy system into RT using 
> Perl/API. When we try to create a ticket we get an error on "creator".
> 
> 	There appears to be a bug in the API. Normal behavior when I call 
> $ticket->Create() is for it to convert LDAP style strings in the 
> argument hash into the corresponding numeric ids before doing the actual 
> database insert. If you look at the following, you will see that it does 
> so in several cases, eg  "Owner", "Queue",  but fails to do so in the 
> case of field "Creator", trying to insert 'DMuirduchann' instead of the 
> corresponding numeric. I thought this might be because DMuirduchann is 
> not a pre-existing user, but replacing DMuirduchann with FCHanny, which 
> it correctly translates for other fields, yields the same error. See 
> following:


Creator and  LastUpdatedBy are expected to be ids, not user names.

> 
> 
> [Tue Nov 25 19:53:42 2008] [warning]: DBD::Oracle::st execute failed: 
> ORA-01722: invalid number (DBD ERROR: error possibly near <*> indicator a
> t char 242 in 'INSERT INTO Tickets (Status, Queue, Started, Type, 
> InitialPriority, Starts, id, LastUpdated, Subject, FinalPriority, 
> Creator, Ow
> ner, LastUpdatedBy, Resolved, Created, Priority, Due) VALUES (:p1, :p2, 
> :p3, :p4, :p5, :p6, :p7, :p8, :p9, :p10, :<*>p11, :p12, :p13, :p14, :p1
> 5, :p16, :p17)') [for Statement "INSERT INTO Tickets (Status, Queue, 
> Started, Type, InitialPriority, Starts, id, LastUpdated, Subject, FinalPri
> ority, Creator, Owner, LastUpdatedBy, Resolved, Created, Priority, Due) 
> VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)" with ParamV
> alues: :p5='5', :p12='9824', :p8='2008-01-04 12:00:00', :p14='1970-01-01 
> 00:00:00', :p10='1', :p13='1', :p16='5', :p2='50252', :p3='2007-11-28
> 12:00:00', :p6='1970-01-01 00:00:00', :p15='2007-11-28 12:00:00', 
> :p1='open', :p7='57389', :p17='1970-01-01 00:00:00', :p4='ticket', 
> :p9='Chg R
> eq 17830: Data Conflict error', :p11='DMuirduchann'] at 
> /apps/rt/rt/perl/lib/5.8.5/DBIx/SearchBuilder/Handle.pm line 505. 
> (/apps/rt/rt/perl/lib
> /5.8.5/DBIx/SearchBuilder/Handle.pm:505)
> 
> 
> Kenn
> LBNL
> 
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
> 
> 
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com
> 

-- 



More information about the rt-users mailing list