Shredder error

All,

Having finally purged my db of deleted tickets, I am now trying to delete the users who now have no tickets assigned to them. However shredder is failing with rt 3.8.2:

[root@samba sbin]# ./rt-shredder --plugin "Users=no_tickets,1;status,any;replace_relations,Nobody;limit,5"
SQL dump file is '/opt/httpd/rt3/sbin/20091014T232306-0001.sql’
Next objects would be deleted:
RT::User-110031 object
RT::User-1080297 object
RT::User-911624 object
RT::User-352 object
RT::User-430 object
Do you want to proceed? [y/N] y
Couldn’t wipeout object: Can’t call method “new” on an undefined value at /opt/httpd/rt3/sbin/…/lib/RT/Transaction_Overlay.pm line 1031, line 1.

Anyone any ideas?

Cheers,
David

David,

Some users may be referred to by transaction history of a ticket because
they sent in corresponance or were the original requestor or owner.
Those kind of relationships shouldn’t be deleted because it will cause
an error in yoiur history display.

Kenn
LBNLOn 10/14/2009 4:57 PM, David Hobley wrote:

All,

Having finally purged my db of deleted tickets, I am now trying to
delete the users who now have no tickets assigned to them. However
shredder is failing with rt 3.8.2:

[root@samba sbin]# ./rt-shredder --plugin
“Users=no_tickets,1;status,any;replace_relations,Nobody;limit,5”
SQL dump file is ‘/opt/httpd/rt3/sbin/20091014T232306-0001.sql’
Next objects would be deleted:
RT::User-110031 object
RT::User-1080297 object
RT::User-911624 object
RT::User-352 object
RT::User-430 object
Do you want to proceed? [y/N] y
Couldn’t wipeout object: Can’t call method “new” on an undefined value
at /opt/httpd/rt3/sbin/…/lib/RT/Transaction_Overlay.pm line 1031,
line 1.

Anyone any ideas?


Cheers,
David


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

Some users may be referred to by transaction history of a ticket
because they sent in corresponance or were the original requestor or
owner. Those kind of relationships shouldn’t be deleted because it
will cause an error in yoiur history display.
Isn’t that what replace_relations is supposed to fix?

Regards,

Howard

Howard,

I thought the “replace-relations” was for links to other tickets. If it
offers an opportunity to enter a replacement User ID, then I’m sure it’s OK.

Kenn
LBNLOn 10/15/2009 9:01 AM, Howard Jones wrote:

On 15/10/2009 16:41, Ken Crocker wrote:

Some users may be referred to by transaction history of a ticket
because they sent in corresponance or were the original requestor or
owner. Those kind of relationships shouldn’t be deleted because it
will cause an error in yoiur history display.

Isn’t that what replace_relations is supposed to fix?

Regards,

Howard


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

I thought this was the case; in which case I am still no closer to working out why it is crashing for me.

Does anyone have any suggestions as to how I can get to the bottom of this?

Couldn’t wipeout object: Can’t call method “new” on an undefined value at /opt/httpd/rt3/sbin/…/lib/RT/Transaction_Overlay.pm line 1031, line 1.

Cheers,
David----- Original Message -----
From: “Ken Crocker” kfcrocker@lbl.gov
To: “Howard Jones” howie@thingy.com
Cc: rt-users@lists.bestpractical.com
Sent: Friday, 16 October, 2009 3:14:26 AM GMT +10:00 Brisbane
Subject: Re: [rt-users] shredder error

Howard,

I thought the “replace-relations” was for links to other tickets. If it offers an opportunity to enter a replacement User ID, then I’m sure it’s OK.

Kenn
LBNL

On 10/15/2009 9:01 AM, Howard Jones wrote:

On 15/10/2009 16:41, Ken Crocker wrote:

Some users may be referred to by transaction history of a ticket
because they sent in corresponance or were the original requestor or
owner. Those kind of relationships shouldn’t be deleted because it
will cause an error in yoiur history display. Isn’t that what replace_relations is supposed to fix?

Regards,

Howard
_______________________________________________ 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
_______________________________________________ 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

Cheers,
David Hobley

IT Manager
Creators of Miessence, MiVitality and MiEnviron

Phone: +61 (7) 5582 7020
Fax: +61 (7) 5539 6719
USA Fax 1800 840 0827
Email : david.hobley@mionegroup.com
Website: www.mionegroup.com