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:
[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