Re: [rt-users] warning message on set ReferTo
.ApplicableTransTypes LIKE '%Any%') AND (main.Disabled = '0') ' at /usr/local/lib/perl5/site_perl/5.14.2/DBIx/SearchBuilder/Handle.pm line 602. DBIx::SearchBuilder::Handle::SimpleQuery(RT::Handle=HASH(0x802572660), SELECT COUNT(DISTINCT main.id) FROM Scrips main JOIN ObjectSc...) called at /usr/local/lib/perl5/site_perl/5.14.2/DBIx/SearchBuilder.pm line 295 DBIx::SearchBuilder::_DoCount(RT::Scrips=HASH(0x80dd41c18)) called at /opt/rt4/lib//RT/SearchBuilder.pm line 996 RT::SearchBuilder::_DoCount(RT::Scrips=HASH(0x80dd41c18)) called at /usr/local/lib/perl5/site_perl/5.14.2/DBIx/SearchBuilder.pm line 1471 DBIx::SearchBuilder::Count(RT::Scrips=HASH(0x80dd41c18)) called at /opt/rt4/lib//RT/Scrips.pm line 495 RT::Scrips::_FindScrips(RT::Scrips=HASH(0x80dd41c18), Stage, TransactionBatch, Type, AddLink) called at /opt/rt4/lib//RT/Scrips.pm line 343 RT::Scrips::Prepare(RT::Scrips=HASH(0x80dd41c18), Type, AddLink, TransactionObj, RT::Transaction=HASH(0x80deae7b0), Ticket, undef, TicketObj, RT::Ticket=HASH(0x80dd41600), ...) called at /opt/rt4/lib//RT/Scrips.pm line 291 RT::Scrips::Apply(RT::Scrips=HASH(0x80dd41c18), Stage, TransactionBatch, TicketObj, RT::Ticket=HASH(0x80dd41600), TransactionObj, RT::Transaction=HASH(0x80deae7b0), Type, AddLink, ...) called at /opt/rt4/lib//RT/Ticket.pm line 2598 RT::Ticket::_ApplyTransactionBatch(RT::Ticket=HASH(0x80dd41600)) called at /opt/rt4/lib//RT/Ticket.pm line 2569 RT::Ticket::ApplyTransactionBatch(RT::Ticket=HASH(0x80dd41600)) called at /opt/rt4/lib//RT/Ticket.pm line 2639 RT::Ticket::DESTROY(RT::Ticket=HASH(0x80dd41600)) called at 02.pl line 149 eval {...} called at 02.pl line 149 (/usr/local/lib/perl5/site_perl/5.14.2/Carp.pm:169) [82765] [Thu Dec 25 04:19:52 2014] [warning]: RT::Handle=HASH(0x802572648) couldn't execute the query 'SELECT * FROM Tickets WHERE id = ?' at /usr/local/lib/perl5/site_perl/5.14.2/DBIx/SearchBuilder/Handle.pm line 602. DBIx::SearchBuilder::Handle::SimpleQuery(RT::Handle=HASH(0x802572648), SELECT * FROM Tickets WHERE id = ?, 3330370) called at /usr/local/lib/perl5/site_perl/5.14.2/DBIx/SearchBuilder/Record.pm line 1234 DBIx::SearchBuilder::Record::_LoadFromSQL(RT::Ticket=HASH(0x80beca300), SELECT * FROM Tickets WHERE id = ?, 3330370) called at /usr/local/lib/perl5/site_perl/5.14.2/DBIx/SearchBuilder/Record.pm line 1153 DBIx::SearchBuilder::Record::LoadByCols(RT::Ticket=HASH(0x80beca300), id, 3330370) called at /usr/local/lib/perl5/site_perl/5.14.2/DBIx/SearchBuilder/Record/Cachable.pm line 120 DBIx::SearchBuilder::Record::Cachable::LoadByCols(RT::Ticket=HASH(0x80beca300), id, 3330370) called at /opt/rt4/lib//RT/Record.pm line 396 RT::Record::LoadByCols(RT::Ticket=HASH(0x80beca300), id, 3330370) called at /usr/local/lib/perl5/site_perl/5.14.2/DBIx/SearchBuilder/Record.pm line 1168 DBIx::SearchBuilder::Record::LoadById(RT::Ticket=HASH(0x80beca300), 3330370) called at /opt/rt4/lib//RT/Ticket.pm line 146 RT::Ticket::Load(RT::Ticket=HASH(0x80beca300), 3330370) called at /opt/rt4/lib//RT/Ticket.pm line 2581 RT::Ticket::_ApplyTransactionBatch(RT::Ticket=HASH(0x80becab88)) called at /opt/rt4/lib//RT/Ticket.pm line 2569 RT::Ticket::ApplyTransactionBatch(RT::Ticket=HASH(0x80becab88)) called at /opt/rt4/lib//RT/Ticket.pm line 2639 RT::Ticket::DESTROY(RT::Ticket=HASH(0x80becab88)) called at 02.pl line 149 eval {...} called at 02.pl line 149 (/usr/local/lib/perl5/site_perl/5.14.2/Carp.pm:169) [82765] [Thu Dec 25 04:19:52 2014] [warning]: TransactionBatch was fired on a ticket that no longer exists; unable to run scrips! Call -ApplyTransactionBatch before shredding the ticket, for consistent results. (/opt/rt4/lib//RT/Ticket.pm:2588) From: Alex Peters [mailto:a...@peters.net] Sent: Wednesday, December 17, 2014 2:31 PM To: Payam Poursaied; rt-users@lists.bestpractical.com mailto:rt-users@lists.bestpractical.com Subject: Re: [rt-users] warning message on set ReferTo I can't see any obvious problems based on your error messages. There seems to be a typo in the code. Is that directly copied from your script? Have you considered enabling debugging from within your script? On Thu, 18 Dec 2014 5:04 am Payam Poursaied m...@payam124.com mailto:m...@payam124.com wrote: Hi All I have created a script which has below command to create a link $Ticket-AddLink(Type='RefersTo',Target=$pticket_id,RecordTransactiosn=0) ; When I run the script ReferTo link created, but I got below warning as well. RT version 4.2.8 And line 149 of 02.pl http://02.pl is exit line. Any idea? [85829] [Wed Dec 17 07:14:20 2014] [warning]: RT::Handle=HASH(0x802572648) couldn't execute the query 'SELECT * FROM Tickets WHERE id = ?' at /usr/local/lib/perl5/site_perl/5.14.2/DBIx/SearchBuilder/Handle.pm line 602. DBIx::SearchBuilder::Handle
Re: [rt-users] warning message on set ReferTo
results. (/opt/rt4/lib//RT/Ticket.pm:2588) *From:* Alex Peters [mailto:a...@peters.net a...@peters.net] *Sent:* Wednesday, December 17, 2014 2:31 PM *To:* Payam Poursaied; rt-users@lists.bestpractical.com *Subject:* Re: [rt-users] warning message on set ReferTo I can't see any obvious problems based on your error messages. There seems to be a typo in the code. Is that directly copied from your script? Have you considered enabling debugging from within your script? On Thu, 18 Dec 2014 5:04 am Payam Poursaied m...@payam124.com wrote: Hi All I have created a script which has below command to create a link $Ticket-AddLink(Type='RefersTo',Target=$pticket_id,RecordTransactiosn=0) ; When I run the script ReferTo link created, but I got below warning as well. RT version 4.2.8 And line 149 of 02.pl is exit line. Any idea? [85829] [Wed Dec 17 07:14:20 2014] [warning]: RT::Handle=HASH(0x802572648) couldn't execute the query 'SELECT * FROM Tickets WHERE id = ?' at /usr/local/lib/perl5/site_perl/5.14.2/DBIx/SearchBuilder/Handle.pm line 602. DBIx::SearchBuilder::Handle::SimpleQuery(RT::Handle=HASH(0x802572648), SELECT * FROM Tickets WHERE id = ?, 3311056) called at /usr/local/lib/perl5/site_perl/5.14.2/DBIx/SearchBuilder/Record.pm line 1234 DBIx::SearchBuilder::Record::_LoadFromSQL(RT::Ticket=HASH(0x80e255cf0), SELECT * FROM Tickets WHERE id = ?, 3311056) called at /usr/local/lib/perl5/site_perl/5.14.2/DBIx/SearchBuilder/Record.pm line 1153 DBIx::SearchBuilder::Record::LoadByCols(RT::Ticket=HASH(0x80e255cf0), id, 3311056) called at /usr/local/lib/perl5/site_perl/5.14.2/DBIx/SearchBuilder/Record/Cachable.pm line 120 DBIx::SearchBuilder::Record::Cachable::LoadByCols(RT::Ticket=HASH(0x80e255cf 0), id, 3311056) called at /opt/rt4/lib//RT/Record.pm line 396 RT::Record::LoadByCols(RT::Ticket=HASH(0x80e255cf0), id, 3311056) called at /usr/local/lib/perl5/site_perl/5.14.2/DBIx/SearchBuilder/Record.pm line 1168 DBIx::SearchBuilder::Record::LoadById(RT::Ticket=HASH(0x80e255cf0), 3311056) called at /opt/rt4/lib//RT/Ticket.pm line 146 RT::Ticket::Load(RT::Ticket=HASH(0x80e255cf0), 3311056) called at /opt/rt4/lib//RT/Ticket.pm line 2581 RT::Ticket::_ApplyTransactionBatch(RT::Ticket=HASH(0x80dd1a9f0)) called at /opt/rt4/lib//RT/Ticket.pm line 2569 RT::Ticket::ApplyTransactionBatch(RT::Ticket=HASH(0x80dd1a9f0)) called at /opt/rt4/lib//RT/Ticket.pm line 2639 RT::Ticket::DESTROY(RT::Ticket=HASH(0x80dd1a9f0)) called at 02.pl line 149 eval {...} called at 02.pl line 149 (/usr/local/lib/perl5/site_perl/5.14.2/Carp.pm:169)
[rt-users] warning message on set ReferTo
Hi All I have created a script which has below command to create a link $Ticket-AddLink(Type='RefersTo',Target=$pticket_id,RecordTransactiosn=0) ; When I run the script ReferTo link created, but I got below warning as well. RT version 4.2.8 And line 149 of 02.pl is exit line. Any idea? [85829] [Wed Dec 17 07:14:20 2014] [warning]: RT::Handle=HASH(0x802572648) couldn't execute the query 'SELECT * FROM Tickets WHERE id = ?' at /usr/local/lib/perl5/site_perl/5.14.2/DBIx/SearchBuilder/Handle.pm line 602. DBIx::SearchBuilder::Handle::SimpleQuery(RT::Handle=HASH(0x802572648), SELECT * FROM Tickets WHERE id = ?, 3311056) called at /usr/local/lib/perl5/site_perl/5.14.2/DBIx/SearchBuilder/Record.pm line 1234 DBIx::SearchBuilder::Record::_LoadFromSQL(RT::Ticket=HASH(0x80e255cf0), SELECT * FROM Tickets WHERE id = ?, 3311056) called at /usr/local/lib/perl5/site_perl/5.14.2/DBIx/SearchBuilder/Record.pm line 1153 DBIx::SearchBuilder::Record::LoadByCols(RT::Ticket=HASH(0x80e255cf0), id, 3311056) called at /usr/local/lib/perl5/site_perl/5.14.2/DBIx/SearchBuilder/Record/Cachable.pm line 120 DBIx::SearchBuilder::Record::Cachable::LoadByCols(RT::Ticket=HASH(0x80e255cf 0), id, 3311056) called at /opt/rt4/lib//RT/Record.pm line 396 RT::Record::LoadByCols(RT::Ticket=HASH(0x80e255cf0), id, 3311056) called at /usr/local/lib/perl5/site_perl/5.14.2/DBIx/SearchBuilder/Record.pm line 1168 DBIx::SearchBuilder::Record::LoadById(RT::Ticket=HASH(0x80e255cf0), 3311056) called at /opt/rt4/lib//RT/Ticket.pm line 146 RT::Ticket::Load(RT::Ticket=HASH(0x80e255cf0), 3311056) called at /opt/rt4/lib//RT/Ticket.pm line 2581 RT::Ticket::_ApplyTransactionBatch(RT::Ticket=HASH(0x80dd1a9f0)) called at /opt/rt4/lib//RT/Ticket.pm line 2569 RT::Ticket::ApplyTransactionBatch(RT::Ticket=HASH(0x80dd1a9f0)) called at /opt/rt4/lib//RT/Ticket.pm line 2639 RT::Ticket::DESTROY(RT::Ticket=HASH(0x80dd1a9f0)) called at 02.pl line 149 eval {...} called at 02.pl line 149 (/usr/local/lib/perl5/site_perl/5.14.2/Carp.pm:169)
Re: [rt-users] warning message on set ReferTo
I can't see any obvious problems based on your error messages. There seems to be a typo in the code. Is that directly copied from your script? Have you considered enabling debugging from within your script? On Thu, 18 Dec 2014 5:04 am Payam Poursaied m...@payam124.com wrote: Hi All I have created a script which has below command to create a link $Ticket-AddLink(Type='RefersTo',Target=$pticket_id, RecordTransactiosn=0) ; When I run the script ReferTo link created, but I got below warning as well. RT version 4.2.8 And line 149 of 02.pl is exit line. Any idea? [85829] [Wed Dec 17 07:14:20 2014] [warning]: RT::Handle=HASH(0x802572648) couldn't execute the query 'SELECT * FROM Tickets WHERE id = ?' at /usr/local/lib/perl5/site_perl/5.14.2/DBIx/SearchBuilder/Handle.pm line 602. DBIx::SearchBuilder::Handle::SimpleQuery(RT::Handle=HASH(0x802572648), SELECT * FROM Tickets WHERE id = ?, 3311056) called at /usr/local/lib/perl5/site_perl/5.14.2/DBIx/SearchBuilder/Record.pm line 1234 DBIx::SearchBuilder::Record::_LoadFromSQL(RT::Ticket=HASH(0x80e255cf0), SELECT * FROM Tickets WHERE id = ?, 3311056) called at /usr/local/lib/perl5/site_perl/5.14.2/DBIx/SearchBuilder/Record.pm line 1153 DBIx::SearchBuilder::Record::LoadByCols(RT::Ticket=HASH(0x80e255cf0), id, 3311056) called at /usr/local/lib/perl5/site_perl/5.14.2/DBIx/SearchBuilder/Record/Cachable. pm line 120 DBIx::SearchBuilder::Record::Cachable::LoadByCols(RT:: Ticket=HASH(0x80e255cf 0), id, 3311056) called at /opt/rt4/lib//RT/Record.pm line 396 RT::Record::LoadByCols(RT::Ticket=HASH(0x80e255cf0), id, 3311056) called at /usr/local/lib/perl5/site_perl/5.14.2/DBIx/ SearchBuilder/Record.pm line 1168 DBIx::SearchBuilder::Record::LoadById(RT::Ticket=HASH( 0x80e255cf0), 3311056) called at /opt/rt4/lib//RT/Ticket.pm line 146 RT::Ticket::Load(RT::Ticket=HASH(0x80e255cf0), 3311056) called at /opt/rt4/lib//RT/Ticket.pm line 2581 RT::Ticket::_ApplyTransactionBatch(RT::Ticket=HASH(0x80dd1a9f0)) called at /opt/rt4/lib//RT/Ticket.pm line 2569 RT::Ticket::ApplyTransactionBatch(RT::Ticket=HASH(0x80dd1a9f0)) called at /opt/rt4/lib//RT/Ticket.pm line 2639 RT::Ticket::DESTROY(RT::Ticket=HASH(0x80dd1a9f0)) called at 02.pl line 149 eval {...} called at 02.pl line 149 (/usr/local/lib/perl5/site_perl/5.14.2/Carp.pm:169)