Problems with rt-shredder / rt-validator

Hello!

RT3.8.4/mysql5/ScientificLinux 5 (RHEL-Clone)

I try to erease an old tickets from our RT, but this fails with the
message “Couldn’t wipeout object: Can’t call method “IsLocal” on an
undefined value at /opt/rt3/sbin/…/lib/RT/URI.pm line 249, line
1.”

I tried rt-validator. But this don’t help, the ticket can’t be
wipeout afterwards. *

If I try to open the ticket in the Web-UI, the Link-Box is missing
instead there is the message Can’t call method “Object” on an undefined
value at /opt/rt3/bin/…/lib/RT/URI.pm line 232"

I found one record in the Links table which referenced this ticket
(as LocalBase). I deleted this record, but the problem remains. *

(* on a test machine, with copy of the production data)

Any ideas what I can do to repair the DB?

best regards!

sven

I try to erease an old tickets from our RT, but this fails with the
message “Couldn’t wipeout object: Can’t call method “IsLocal” on an
undefined value at /opt/rt3/sbin/…/lib/RT/URI.pm line 249, line
1.”

I tried rt-validator. But this don’t help, the ticket can’t be
wipeout afterwards. *

If I try to open the ticket in the Web-UI, the Link-Box is missing
instead there is the message Can’t call method “Object” on an undefined
value at /opt/rt3/bin/…/lib/RT/URI.pm line 232"

I found one record in the Links table which referenced this ticket
(as LocalBase). I deleted this record, but the problem remains. *

(* on a test machine, with copy of the production data)

Any ideas what I can do to repair the DB?

Did you search LocalTarget and LocalBase, or just LocalBase?

It might be instructive to see the deleted link record, but if the
error still shows up it implies that there is still a Link hiding.

-kevin

Hi Sven,

rt-validator lacks some checks regarding links and probably doesn’t
catch many cases regarding Links table.On Thu, Sep 10, 2009 at 12:35 PM, Sven Sternbergersven.sternberger@desy.de wrote:

Hello!

RT3.8.4/mysql5/ScientificLinux 5 (RHEL-Clone)

I try to erease an old tickets from our RT, but this fails with the
message “Couldn’t wipeout object: Can’t call method “IsLocal” on an
undefined value at /opt/rt3/sbin/…/lib/RT/URI.pm line 249, line
1.”

I tried rt-validator. But this don’t help, the ticket can’t be
wipeout afterwards. *

If I try to open the ticket in the Web-UI, the Link-Box is missing
instead there is the message Can’t call method “Object” on an undefined
value at /opt/rt3/bin/…/lib/RT/URI.pm line 232"

I found one record in the Links table which referenced this ticket
(as LocalBase). I deleted this record, but the problem remains. *

(* on a test machine, with copy of the production data)

Any ideas what I can do to repair the DB?

best regards!

sven


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

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

Best regards, Ruslan.

Hello!

Did you search LocalTarget and LocalBase, or just LocalBase?
both

It might be instructive to see the deleted link record, but if the
error still shows up it implies that there is still a Link hiding.
mysql> select * from Links where LocalBase=228186 or LocalTarget=228186;
| id | Base | Target | Type |
LocalTarget | LocalBase | LastUpdatedBy | LastUpdated | Creator
| Created |
| 14381 | fsck.com-rt://desy.de/ticket/228186 | NULL | DependsOn |
0 | 228186 | 1 | 2007-07-30 12:21:58 | 1 |
2007-07-30 12:21:58 |

I configured the debug mode, but I don’t get any output when I display
the ticket. I just realized that the display stops exactly at the Link
section. So there is no history afterwards.

When I try to wipeout the ticket via Web-UI Shredder I always get:

[Fri Sep 11 08:48:09 2009] [warning]: RT::CachedGroupMember-2483006
wiped out (/opt/rt3/bin/…/lib/RT/Shredder/Record.pm:236)
[Fri Sep 11 08:48:10 2009] [warning]: RT::CachedGroupMember-2483007
wiped out (/opt/rt3/bin/…/lib/RT/Shredder/Record.pm:236)
[Fri Sep 11 08:48:10 2009] [warning]: RT::GroupMember-849693 wiped out
(/opt/rt3/bin/…/lib/RT/Shredder/Record.pm:236)
[Fri Sep 11 08:48:11 2009] [warning]: RT::CachedGroupMember-2483000
wiped out (/opt/rt3/bin/…/lib/RT/Shredder/Record.pm:236)
[Fri Sep 11 08:48:11 2009] [warning]: RT::Transaction-1113090 wiped out
(/opt/rt3/bin/…/lib/RT/Shredder/Record.pm:236)
[Fri Sep 11 08:48:11 2009] [warning]: RT::Group-842057 wiped out
(/opt/rt3/bin/…/lib/RT/Shredder/Record.pm:236)
[Fri Sep 11 08:48:12 2009] [warning]: RT::Principal-842057 wiped out
(/opt/rt3/bin/…/lib/RT/Shredder/Record.pm:236)
[Fri Sep 11 08:48:13 2009] [warning]: RT::CachedGroupMember-2483004
wiped out (/opt/rt3/bin/…/lib/RT/Shredder/Record.pm:236)
[Fri Sep 11 08:48:14 2009] [warning]: RT::CachedGroupMember-2483005
wiped out (/opt/rt3/bin/…/lib/RT/Shredder/Record.pm:236)
[Fri Sep 11 08:48:14 2009] [warning]: RT::GroupMember-849692 wiped out
(/opt/rt3/bin/…/lib/RT/Shredder/Record.pm:236)
[Fri Sep 11 08:48:15 2009] [warning]: RT::CachedGroupMember-2483001
wiped out (/opt/rt3/bin/…/lib/RT/Shredder/Record.pm:236)
[Fri Sep 11 08:48:15 2009] [warning]: RT::Transaction-1113091 wiped out
(/opt/rt3/bin/…/lib/RT/Shredder/Record.pm:236)
[Fri Sep 11 08:48:15 2009] [warning]: RT::Group-842058 wiped out
(/opt/rt3/bin/…/lib/RT/Shredder/Record.pm:236)
[Fri Sep 11 08:48:15 2009] [warning]: RT::Principal-842058 wiped out
(/opt/rt3/bin/…/lib/RT/Shredder/Record.pm:236)
[Fri Sep 11 08:48:16 2009] [warning]: RT::CachedGroupMember-2483002
wiped out (/opt/rt3/bin/…/lib/RT/Shredder/Record.pm:236)
[Fri Sep 11 08:48:16 2009] [warning]: RT::Transaction-1113092 wiped out
(/opt/rt3/bin/…/lib/RT/Shredder/Record.pm:236)
[Fri Sep 11 08:48:16 2009] [warning]: RT::Group-842059 wiped out
(/opt/rt3/bin/…/lib/RT/Shredder/Record.pm:236)
[Fri Sep 11 08:48:16 2009] [warning]: RT::Principal-842059 wiped out
(/opt/rt3/bin/…/lib/RT/Shredder/Record.pm:236)
[Fri Sep 11 08:48:17 2009] [warning]: RT::CachedGroupMember-2483003
wiped out (/opt/rt3/bin/…/lib/RT/Shredder/Record.pm:236)
[Fri Sep 11 08:48:17 2009] [warning]: RT::Transaction-1113093 wiped out
(/opt/rt3/bin/…/lib/RT/Shredder/Record.pm:236)
[Fri Sep 11 08:48:17 2009] [warning]: RT::Group-842060 wiped out
(/opt/rt3/bin/…/lib/RT/Shredder/Record.pm:236)
[Fri Sep 11 08:48:17 2009] [warning]: RT::Principal-842060 wiped out
(/opt/rt3/bin/…/lib/RT/Shredder/Record.pm:236)
[Fri Sep 11 08:48:17 2009] [warning]: RT::Attachment-621573 wiped out
(/opt/rt3/bin/…/lib/RT/Shredder/Record.pm:236)
[Fri Sep 11 08:48:17 2009] [warning]: RT::Transaction-1113094 wiped out
(/opt/rt3/bin/…/lib/RT/Shredder/Record.pm:236)
[Fri Sep 11 08:48:18 2009] [warning]: RT::Transaction-1172242 wiped out
(/opt/rt3/bin/…/lib/RT/Shredder/Record.pm:236)
[Fri Sep 11 08:48:18 2009] [warning]: RT::Transaction-2149578 wiped out
(/opt/rt3/bin/…/lib/RT/Shredder/Record.pm:236)
[Fri Sep 11 08:48:18 2009] [warning]: RT::Transaction-2149579 wiped out
(/opt/rt3/bin/…/lib/RT/Shredder/Record.pm:236)
[Fri Sep 11 08:48:18 2009] [warning]: RT::Transaction-2149581 wiped out
(/opt/rt3/bin/…/lib/RT/Shredder/Record.pm:236)
[Fri Sep 11 08:48:18 2009] [warning]: RT::Transaction-2149583 wiped out
(/opt/rt3/bin/…/lib/RT/Shredder/Record.pm:236)
[Fri Sep 11 08:48:18 2009] [warning]: RT::Transaction-2149585 wiped out
(/opt/rt3/bin/…/lib/RT/Shredder/Record.pm:236)
[Fri Sep 11 08:48:18 2009] [warning]: RT::Transaction-2149587 wiped out
(/opt/rt3/bin/…/lib/RT/Shredder/Record.pm:236)
[Fri Sep 11 08:48:18 2009] [warning]: RT::Transaction-2149589 wiped out
(/opt/rt3/bin/…/lib/RT/Shredder/Record.pm:236)
[Fri Sep 11 08:48:18 2009] [warning]: RT::Transaction-2149591 wiped out
(/opt/rt3/bin/…/lib/RT/Shredder/Record.pm:236)
[Fri Sep 11 08:48:18 2009] [warning]: RT::Transaction-2149593 wiped out
(/opt/rt3/bin/…/lib/RT/Shredder/Record.pm:236)

Best regards!

sven

Hello!

I’m still interested to get rid of the ticket.

Now with rt3.8.6 I still get

/opt/rt3/sbin/rt-shredder --plugin "Tickets=query,Status =‘deleted’

AND id=228186;limit,100"
SQL dump file is '/root/20091110T124735-0001.sql’
Next 1 objects would be deleted:
RT::Ticket-228186 object
Do you want to proceed? [y/N] y
Couldn’t wipeout object: Can’t call method “IsLocal” on an undefined
value at /opt/rt3/sbin/…/lib/RT/URI.pm line 249, line 1.

/root/20091110T124735-0001.sql:
INSERT INTO
CachedGroupMembers(disabled,groupid,id,immediateparentid,memberid,via) VALUES(‘0’,‘842057’,‘2483006’,‘842057’,‘22064’,‘2483006’);
INSERT INTO
CachedGroupMembers(disabled,groupid,id,immediateparentid,memberid,via) VALUES(‘0’,‘842057’,‘2483007’,‘842057’,‘22064’,‘2483000’);
INSERT INTO GroupMembers(groupid,id,memberid)
VALUES(‘842057’,‘849693’,‘22064’);
INSERT INTO
CachedGroupMembers(disabled,groupid,id,immediateparentid,memberid,via) VALUES(‘0’,‘842057’,‘2483000’,‘842057’,‘842057’,‘2483000’);
INSERT INTO
Transactions(created,creator,data,field,id,newreference,newvalue,objectid,objecttype,oldreference,oldvalue,referencetype,timetaken,type) VALUES(‘2007-07-30 12:21:57’,‘1’,NULL,NULL,‘1113090’,NULL,NULL,‘842057’,‘RT::Group’,NULL,NULL,NULL,‘0’,‘Create’);
INSERT INTO
Groups(description,domain,id,instance,name,type)
VALUES(NULL,‘RT::Ticket-Role’,‘842057’,‘228186’,NULL,‘Requestor’);
INSERT INTO Principals(disabled,id,objectid,principaltype)
VALUES(‘0’,‘842057’,‘842057’,‘Group’);
INSERT INTO
CachedGroupMembers(disabled,groupid,id,immediateparentid,memberid,via) VALUES(‘0’,‘842058’,‘2483004’,‘842058’,‘10’,‘2483004’);
INSERT INTO
CachedGroupMembers(disabled,groupid,id,immediateparentid,memberid,via) VALUES(‘0’,‘842058’,‘2483005’,‘842058’,‘10’,‘2483001’);
INSERT INTO GroupMembers(groupid,id,memberid)
VALUES(‘842058’,‘849692’,‘10’);
INSERT INTO
CachedGroupMembers(disabled,groupid,id,immediateparentid,memberid,via) VALUES(‘0’,‘842058’,‘2483001’,‘842058’,‘842058’,‘2483001’);
INSERT INTO
Transactions(created,creator,data,field,id,newreference,newvalue,objectid,objecttype,oldreference,oldvalue,referencetype,timetaken,type) VALUES(‘2007-07-30 12:21:57’,‘1’,NULL,NULL,‘1113091’,NULL,NULL,‘842058’,‘RT::Group’,NULL,NULL,NULL,‘0’,‘Create’);
INSERT INTO
Groups(description,domain,id,instance,name,type)
VALUES(NULL,‘RT::Ticket-Role’,‘842058’,‘228186’,NULL,‘Owner’);
INSERT INTO Principals(disabled,id,objectid,principaltype)
VALUES(‘0’,‘842058’,‘842058’,‘Group’);
INSERT INTO
CachedGroupMembers(disabled,groupid,id,immediateparentid,memberid,via) VALUES(‘0’,‘842059’,‘2483002’,‘842059’,‘842059’,‘2483002’);
INSERT INTO
Transactions(created,creator,data,field,id,newreference,newvalue,objectid,objecttype,oldreference,oldvalue,referencetype,timetaken,type) VALUES(‘2007-07-30 12:21:57’,‘1’,NULL,NULL,‘1113092’,NULL,NULL,‘842059’,‘RT::Group’,NULL,NULL,NULL,‘0’,‘Create’);
INSERT INTO
Groups(description,domain,id,instance,name,type)
VALUES(NULL,‘RT::Ticket-Role’,‘842059’,‘228186’,NULL,‘Cc’);
INSERT INTO Principals(disabled,id,objectid,principaltype)
VALUES(‘0’,‘842059’,‘842059’,‘Group’);
INSERT INTO
CachedGroupMembers(disabled,groupid,id,immediateparentid,memberid,via) VALUES(‘0’,‘842060’,‘2483003’,‘842060’,‘842060’,‘2483003’);
INSERT INTO
Transactions(created,creator,data,field,id,newreference,newvalue,objectid,objecttype,oldreference,oldvalue,referencetype,timetaken,type) VALUES(‘2007-07-30 12:21:57’,‘1’,NULL,NULL,‘1113093’,NULL,NULL,‘842060’,‘RT::Group’,NULL,NULL,NULL,‘0’,‘Create’);
INSERT INTO
Groups(description,domain,id,instance,name,type)
VALUES(NULL,‘RT::Ticket-Role’,‘842060’,‘228186’,NULL,‘AdminCc’);
INSERT INTO Principals(disabled,id,objectid,principaltype)
VALUES(‘0’,‘842060’,‘842060’,‘Group’);
INSERT INTO
Attachments(content,contentencoding,contenttype,created,creator,filename,headers,id,messageid,parent,subject,transactionid) VALUES(‘xxxx’,‘none’,‘text/plain’,‘2007-07-30 12:21:57’,‘1’,NULL,‘Content-Type: text/plain\nContent-Disposition: inline\nContent-Transfer-Encoding: binary\nMIME-Version: 1.0\nX-Mailer: MIME-tools 5.420 (Entity 5.420)\n’,‘621573’,’’,‘0’,’’,‘1113094’);
INSERT INTO
Transactions(created,creator,data,field,id,newreference,newvalue,objectid,objecttype,oldreference,oldvalue,referencetype,timetaken,type) VALUES(‘2007-07-30 12:21:57’,‘1’,NULL,NULL,‘1113094’,NULL,NULL,‘228186’,‘RT::Ticket’,NULL,NULL,NULL,‘0’,‘Create’);
INSERT INTO
Transactions(created,creator,data,field,id,newreference,newvalue,objectid,objecttype,oldreference,oldvalue,referencetype,timetaken,type) VALUES(‘2007-09-18 14:15:43’,‘22064’,NULL,‘Status’,‘1172242’,NULL,‘deleted’,‘228186’,‘RT::Ticket’,NULL,‘new’,NULL,‘0’,‘Status’);
INSERT INTO
Transactions(created,creator,data,field,id,newreference,newvalue,objectid,objecttype,oldreference,oldvalue,referencetype,timetaken,type) VALUES(‘2009-09-10 14:13:25’,‘22064’,NULL,‘Status’,‘2215411’,NULL,‘open’,‘228186’,‘RT::Ticket’,NULL,‘deleted’,NULL,‘0’,‘Status’);
INSERT INTO
Transactions(created,creator,data,field,id,newreference,newvalue,objectid,objecttype,oldreference,oldvalue,referencetype,timetaken,type) VALUES(‘2009-09-10 14:13:45’,‘22064’,NULL,‘Status’,‘2215414’,NULL,‘deleted’,‘228186’,‘RT::Ticket’,NULL,‘open’,NULL,‘0’,‘Status’);On Thu, 2009-09-10 at 20:09 +0400, Ruslan Zakirov wrote:

Hi Sven,

rt-validator lacks some checks regarding links and probably doesn’t
catch many cases regarding Links table.

On Thu, Sep 10, 2009 at 12:35 PM, Sven Sternbergersven.sternberger@desy.de wrote:

Hello!

RT3.8.4/mysql5/ScientificLinux 5 (RHEL-Clone)

I try to erease an old tickets from our RT, but this fails with the
message “Couldn’t wipeout object: Can’t call method “IsLocal” on an
undefined value at /opt/rt3/sbin/…/lib/RT/URI.pm line 249, line
1.”

I tried rt-validator. But this don’t help, the ticket can’t be
wipeout afterwards. *

If I try to open the ticket in the Web-UI, the Link-Box is missing
instead there is the message Can’t call method “Object” on an undefined
value at /opt/rt3/bin/…/lib/RT/URI.pm line 232"

I found one record in the Links table which referenced this ticket
(as LocalBase). I deleted this record, but the problem remains. *

(* on a test machine, with copy of the production data)

Any ideas what I can do to repair the DB?

best regards!

sven


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

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

Hi Sven,
i remember this problem at our installation some years ago, a hint from Ruz was to check inside the link table for this ticket number and fix the problem directly here (hopefully i remember correctly)

@Ruz: I think this solved the problem for us, several hundret years ago :wink:
@Sven: Wie siehts mit nem Treffen Anfang Dezember bei Euch aus?

Torsten

Kuehne + Nagel (AG & Co.) KG, Geschaeftsleitung: Hans-Georg Brinkmann (Vors.), Dirk Blesius (Stellv.), Reiner Heiken (Stellv.), Bruno Mang, Alfred Manke, Christian Marnetté (Stellv.), Mark Reinhardt (Stellv.), Jens Wollesen, Rainer Wunn, Sitz: Bremen, Registergericht: Bremen, HRA 21928, USt-IdNr.: DE 812773878, Persoenlich haftende Gesellschaft: Kuehne & Nagel A.G., Sitz: Contern/Luxemburg Geschaeftsfuehrender Verwaltungsrat: Klaus-Michael Kuehne

-----Urspruengliche Nachricht-----Von: rt-users-bounces@lists.bestpractical.com [mailto:rt-users-bounces@lists.bestpractical.com] Im Auftrag von Sven Sternberger
Gesendet: Dienstag, 10. November 2009 13:57
An: Ruslan Zakirov
Cc: rt-users@lists.bestpractical.com
Betreff: Re: [rt-users] Problems with rt-shredder / rt-validator

Hello!

I’m still interested to get rid of the ticket.

Now with rt3.8.6 I still get

/opt/rt3/sbin/rt-shredder --plugin "Tickets=query,Status =‘deleted’

AND id=228186;limit,100"
SQL dump file is '/root/20091110T124735-0001.sql’
Next 1 objects would be deleted:
RT::Ticket-228186 object
Do you want to proceed? [y/N] y
Couldn’t wipeout object: Can’t call method “IsLocal” on an undefined value at /opt/rt3/sbin/…/lib/RT/URI.pm line 249, line 1.

/root/20091110T124735-0001.sql:
INSERT INTO
CachedGroupMembers(disabled,groupid,id,immediateparentid,memberid,via) VALUES(‘0’,‘842057’,‘2483006’,‘842057’,‘22064’,‘2483006’);
INSERT INTO
CachedGroupMembers(disabled,groupid,id,immediateparentid,memberid,via) VALUES(‘0’,‘842057’,‘2483007’,‘842057’,‘22064’,‘2483000’);
INSERT INTO GroupMembers(groupid,id,memberid)
VALUES(‘842057’,‘849693’,‘22064’);
INSERT INTO
CachedGroupMembers(disabled,groupid,id,immediateparentid,memberid,via) VALUES(‘0’,‘842057’,‘2483000’,‘842057’,‘842057’,‘2483000’);
INSERT INTO
Transactions(created,creator,data,field,id,newreference,newvalue,objectid,objecttype,oldreference,oldvalue,referencetype,timetaken,type) VALUES(‘2007-07-30 12:21:57’,‘1’,NULL,NULL,‘1113090’,NULL,NULL,‘842057’,‘RT::Group’,NULL,NULL,NULL,‘0’,‘Create’);
INSERT INTO
Groups(description,domain,id,instance,name,type)
VALUES(NULL,‘RT::Ticket-Role’,‘842057’,‘228186’,NULL,‘Requestor’);
INSERT INTO Principals(disabled,id,objectid,principaltype)
VALUES(‘0’,‘842057’,‘842057’,‘Group’);
INSERT INTO
CachedGroupMembers(disabled,groupid,id,immediateparentid,memberid,via) VALUES(‘0’,‘842058’,‘2483004’,‘842058’,‘10’,‘2483004’);
INSERT INTO
CachedGroupMembers(disabled,groupid,id,immediateparentid,memberid,via) VALUES(‘0’,‘842058’,‘2483005’,‘842058’,‘10’,‘2483001’);
INSERT INTO GroupMembers(groupid,id,memberid)
VALUES(‘842058’,‘849692’,‘10’);
INSERT INTO
CachedGroupMembers(disabled,groupid,id,immediateparentid,memberid,via) VALUES(‘0’,‘842058’,‘2483001’,‘842058’,‘842058’,‘2483001’);
INSERT INTO
Transactions(created,creator,data,field,id,newreference,newvalue,objectid,objecttype,oldreference,oldvalue,referencetype,timetaken,type) VALUES(‘2007-07-30 12:21:57’,‘1’,NULL,NULL,‘1113091’,NULL,NULL,‘842058’,‘RT::Group’,NULL,NULL,NULL,‘0’,‘Create’);
INSERT INTO
Groups(description,domain,id,instance,name,type)
VALUES(NULL,‘RT::Ticket-Role’,‘842058’,‘228186’,NULL,‘Owner’);
INSERT INTO Principals(disabled,id,objectid,principaltype)
VALUES(‘0’,‘842058’,‘842058’,‘Group’);
INSERT INTO
CachedGroupMembers(disabled,groupid,id,immediateparentid,memberid,via) VALUES(‘0’,‘842059’,‘2483002’,‘842059’,‘842059’,‘2483002’);
INSERT INTO
Transactions(created,creator,data,field,id,newreference,newvalue,objectid,objecttype,oldreference,oldvalue,referencetype,timetaken,type) VALUES(‘2007-07-30 12:21:57’,‘1’,NULL,NULL,‘1113092’,NULL,NULL,‘842059’,‘RT::Group’,NULL,NULL,NULL,‘0’,‘Create’);
INSERT INTO
Groups(description,domain,id,instance,name,type)
VALUES(NULL,‘RT::Ticket-Role’,‘842059’,‘228186’,NULL,‘Cc’);
INSERT INTO Principals(disabled,id,objectid,principaltype)
VALUES(‘0’,‘842059’,‘842059’,‘Group’);
INSERT INTO
CachedGroupMembers(disabled,groupid,id,immediateparentid,memberid,via) VALUES(‘0’,‘842060’,‘2483003’,‘842060’,‘842060’,‘2483003’);
INSERT INTO
Transactions(created,creator,data,field,id,newreference,newvalue,objectid,objecttype,oldreference,oldvalue,referencetype,timetaken,type) VALUES(‘2007-07-30 12:21:57’,‘1’,NULL,NULL,‘1113093’,NULL,NULL,‘842060’,‘RT::Group’,NULL,NULL,NULL,‘0’,‘Create’);
INSERT INTO
Groups(description,domain,id,instance,name,type)
VALUES(NULL,‘RT::Ticket-Role’,‘842060’,‘228186’,NULL,‘AdminCc’);
INSERT INTO Principals(disabled,id,objectid,principaltype)
VALUES(‘0’,‘842060’,‘842060’,‘Group’);
INSERT INTO
Attachments(content,contentencoding,contenttype,created,creator,filename,headers,id,messageid,parent,subject,transactionid) VALUES(‘xxxx’,‘none’,‘text/plain’,‘2007-07-30 12:21:57’,‘1’,NULL,‘Content-Type: text/plain\nContent-Disposition: inline\nContent-Transfer-Encoding: binary\nMIME-Version: 1.0\nX-Mailer: MIME-tools 5.420 (Entity 5.420)\n’,‘621573’,’’,‘0’,’’,‘1113094’);
INSERT INTO
Transactions(created,creator,data,field,id,newreference,newvalue,objectid,objecttype,oldreference,oldvalue,referencetype,timetaken,type) VALUES(‘2007-07-30 12:21:57’,‘1’,NULL,NULL,‘1113094’,NULL,NULL,‘228186’,‘RT::Ticket’,NULL,NULL,NULL,‘0’,‘Create’);
INSERT INTO
Transactions(created,creator,data,field,id,newreference,newvalue,objectid,objecttype,oldreference,oldvalue,referencetype,timetaken,type) VALUES(‘2007-09-18 14:15:43’,‘22064’,NULL,‘Status’,‘1172242’,NULL,‘deleted’,‘228186’,‘RT::Ticket’,NULL,‘new’,NULL,‘0’,‘Status’);
INSERT INTO
Transactions(created,creator,data,field,id,newreference,newvalue,objectid,objecttype,oldreference,oldvalue,referencetype,timetaken,type) VALUES(‘2009-09-10 14:13:25’,‘22064’,NULL,‘Status’,‘2215411’,NULL,‘open’,‘228186’,‘RT::Ticket’,NULL,‘deleted’,NULL,‘0’,‘Status’);
INSERT INTO
Transactions(created,creator,data,field,id,newreference,newvalue,objectid,objecttype,oldreference,oldvalue,referencetype,timetaken,type) VALUES(‘2009-09-10 14:13:45’,‘22064’,NULL,‘Status’,‘2215414’,NULL,‘deleted’,‘228186’,‘RT::Ticket’,NULL,‘open’,NULL,‘0’,‘Status’);

Hi!On Tue, 2009-11-10 at 14:50 +0100, Brumm, Torsten / Kuehne + Nagel / Ham MI-ID wrote:

i remember this problem at our installation some years ago, a hint from Ruz was to check inside the link table for this ticket number and fix the problem directly here (hopefully i remember correctly)

yes this did the trick. I removed a entry in Links (the Target was
NULL) and afterwards shredder removed the rest of the ticket without
problems.

best regards and thanks to Torsten

sven