[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