Re: [rt-users] warning message on set ReferTo

2014-12-25 Thread Payam Poursaied
.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

2014-12-25 Thread Alex Peters
 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

2014-12-17 Thread Payam Poursaied
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

2014-12-17 Thread Alex Peters
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)