Weird things with RTx::Shredder

I seem to be getting odd results searching in the GUI for RTx::Shredder
(same results from command line). For example, if I search for email
*@domain.com mailto:*@domain.com , I only get 6 users returned wheras
I have about 100 users with a domain.com email address. If I search for
a specific email address, usually, I get nothing returned at all.
Nothing in any error logs either.

And with the Asset Tracker extension (AT), I get a reasonable list of
results but with what look like object class names:

RTx::AssetTracker::Asset-620
RTx::AssetTracker::Asset-621
RTx::AssetTracker::Asset-622
RTx::AssetTracker::Asset-623
RTx::AssetTracker::Asset-624

if I try to wipe any of these out, I get a Perl error

Couldn’t wipeout object: Undefined Objects argument
Trace begun at /usr/local/rt/local/lib/RTx/Shredder.pm line 212

This only happens with Assets. It’s a fairly clean install of RT 3.4.5,
AT 1.2.3 and the latest RTx::Shredder from CPAN. I’ve uninstalled and
re-installed AT and RTx::Shredder to no avail. Any similar experiences?

PK

Philip Kime
NOPS Systems Architect
310 401 0407

I seem to be getting odd results searching in the GUI for RTx::Shredder
(same results from command line). For example, if I search for email
*@domain.com, I only get 6 users returned wheras I have about 100 users with
a domain.com email address. If I search for a specific email address,
usually, I get nothing returned at all. Nothing in any error logs either.
Could you turn on SQL statements log? and send me queries?

Also what DB are you using? Is it development version of the shredder
or stable one?

And with the Asset Tracker extension (AT), I get a reasonable list of
results but with what look like object class names:

RTx::AssetTracker::Asset-620
RTx::AssetTracker::Asset-621
RTx::AssetTracker::Asset-622
RTx::AssetTracker::Asset-623
RTx::AssetTracker::Asset-624

if I try to wipe any of these out, I get a Perl error

Couldn’t wipeout object: Undefined Objects argument
Trace begun at /usr/local/rt/local/lib/RTx/Shredder.pm line
212

This only happens with Assets. It’s a fairly clean install of RT 3.4.5, AT
1.2.3 and the latest RTx::Shredder from CPAN. I’ve uninstalled and
re-installed AT and RTx::Shredder to no avail. Any similar experiences?

PK


Philip Kime
NOPS Systems Architect
310 401 0407


The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

We’re hiring! Come hack Perl for Best Practical:
Careers — Best Practical Solutions

Best regards, Ruslan.

I’m using shredder version 0.03_03 and Mysql 5.0.18.

Do mean turn on RT logging or MySQL SQL logging? You want raw SQL
statements and not the TicketSQL query?
Raw SQL. RT can report it (see config) and you can do it from mysql config too.
IIRC Stephen reported something similar on Oracle, but I couldn’t
reproduce this.

I fixed the AT shredding problem -
RTx::Shredder::Dependencies::_PushDependencies was expecting a named arg
of “TargetObjects” but the AT plugin was passing “TargetObjs” - did this
name change in any version of Shredder? If so, we should tell Todd
Chapman as he needs to update the Asset Shredding code on the AT Wiki.
Yep, there were major overview of the API. And this was changed.

PK

-----Original Message-----
From: Ruslan Zakirov [mailto:ruslan.zakirov@gmail.com]
Sent: 16 May 2006 19:01
To: Philip Kime
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Weird things with RTx::Shredder

I seem to be getting odd results searching in the GUI for
RTx::Shredder (same results from command line). For example, if I
search for email *@domain.com, I only get 6 users returned wheras I
have about 100 users with a domain.com email address. If I search for
a specific email address, usually, I get nothing returned at all.
Nothing in any error logs either.
Could you turn on SQL statements log? and send me queries?

Also what DB are you using? Is it development version of the shredder or
stable one?

And with the Asset Tracker extension (AT), I get a reasonable list of
results but with what look like object class names:

RTx::AssetTracker::Asset-620
RTx::AssetTracker::Asset-621
RTx::AssetTracker::Asset-622
RTx::AssetTracker::Asset-623
RTx::AssetTracker::Asset-624

if I try to wipe any of these out, I get a Perl error

Couldn’t wipeout object: Undefined Objects argument Trace begun at
/usr/local/rt/local/lib/RTx/Shredder.pm line
212

This only happens with Assets. It’s a fairly clean install of RT
3.4.5, AT
1.2.3 and the latest RTx::Shredder from CPAN. I’ve uninstalled and
re-installed AT and RTx::Shredder to no avail. Any similar
experiences?

PK


Philip Kime
NOPS Systems Architect
310 401 0407


The rt-users Archives

Community help: http://wiki.bestpractical.com Commercial support:
sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

We’re hiring! Come hack Perl for Best Practical:
Careers — Best Practical Solutions


Best regards, Ruslan.

Best regards, Ruslan.

Heh, I’ve realized what’s wrong with it.

This code control search on the ‘disabled’ property of a user record
and by default as stated in the docs shredder searches for disabled
users, but with the plugin option ‘status’ you can change this
behaviour. Try value of ‘any’.On 5/18/06, Philip Kime pkime@shopzilla.com wrote:

I changed line 98 of $rtroot/local/lib/RTx/Shredder/Plugin/Users.pm

From

VALUE => ‘0’,

To

VALUE => ‘1’,

And now it works fine.

PK

-----Original Message-----
From: Ruslan Zakirov [mailto:ruslan.zakirov@gmail.com]
Sent: 16 May 2006 20:08
To: Philip Kime
Cc: RT users; Todd Chapman
Subject: Re: [rt-users] Weird things with RTx::Shredder

On 5/17/06, Philip Kime pkime@shopzilla.com wrote:

I’m using shredder version 0.03_03 and Mysql 5.0.18.

Do mean turn on RT logging or MySQL SQL logging? You want raw SQL
statements and not the TicketSQL query?
Raw SQL. RT can report it (see config) and you can do it from mysql
config too.
IIRC Stephen reported something similar on Oracle, but I couldn’t
reproduce this.

I fixed the AT shredding problem -
RTx::Shredder::Dependencies::_PushDependencies was expecting a named
arg of “TargetObjects” but the AT plugin was passing “TargetObjs” -
did this name change in any version of Shredder? If so, we should tell

Todd Chapman as he needs to update the Asset Shredding code on the AT
Wiki.
Yep, there were major overview of the API. And this was changed.

PK

-----Original Message-----
From: Ruslan Zakirov [mailto:ruslan.zakirov@gmail.com]
Sent: 16 May 2006 19:01
To: Philip Kime
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Weird things with RTx::Shredder

On 5/17/06, Philip Kime pkime@shopzilla.com wrote:

I seem to be getting odd results searching in the GUI for
RTx::Shredder (same results from command line). For example, if I
search for email *@domain.com, I only get 6 users returned wheras I
have about 100 users with a domain.com email address. If I search
for a specific email address, usually, I get nothing returned at
all.
Nothing in any error logs either.
Could you turn on SQL statements log? and send me queries?

Also what DB are you using? Is it development version of the shredder
or stable one?

And with the Asset Tracker extension (AT), I get a reasonable list
of results but with what look like object class names:

RTx::AssetTracker::Asset-620
RTx::AssetTracker::Asset-621
RTx::AssetTracker::Asset-622
RTx::AssetTracker::Asset-623
RTx::AssetTracker::Asset-624

if I try to wipe any of these out, I get a Perl error

Couldn’t wipeout object: Undefined Objects argument Trace begun at
/usr/local/rt/local/lib/RTx/Shredder.pm line
212

This only happens with Assets. It’s a fairly clean install of RT
3.4.5, AT
1.2.3 and the latest RTx::Shredder from CPAN. I’ve uninstalled and
re-installed AT and RTx::Shredder to no avail. Any similar
experiences?

PK


Philip Kime
NOPS Systems Architect
310 401 0407


The rt-users Archives

Community help: http://wiki.bestpractical.com Commercial support:
sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

We’re hiring! Come hack Perl for Best Practical:
Careers — Best Practical Solutions


Best regards, Ruslan.


Best regards, Ruslan.

Best regards, Ruslan.