Relations between reminder and ticket

RT Users
1

Hi anyone can tell me where RT keeps the relationship between a ticket and a reminder

Thanks and Regards

2

Hi I am trying find why this is hapening “Couldn’t find Ticket for reminder 2087. Please contact administrator.” since I have put the cleanup scripts and they workes when I do testing. But once in a while I get this error on the dash board. What I do is log in to the DB and make it resolved

I have been going through the DB and unable to find the relation between the ticks and treminders

Thanks and Best RegardsFrom: Asanka Gunasekera asanka_gunasekera@yahoo.co.uk
To: “rt-users@lists.bestpractical.com” rt-users@lists.bestpractical.com
Sent: Thursday, 20 September 2012, 14:14
Subject: [rt-users] relations between reminder and ticket

Hi anyone can tell me where RT keeps the relationship between a ticket and a reminder

Thanks and Regards

Final RT training for 2012 in Atlanta, GA - October 23 & 24
Training — Best Practical Solutions

We’re hiring! http://bestpractical.com/jobs

3

Asanka,

Reminders ARE Tickets, in that they reside in the TICKETS Table. The
difference is “Type”.

KennOn Tue, Sep 25, 2012 at 12:36 AM, Asanka Gunasekera < asanka_gunasekera@yahoo.co.uk> wrote:

Hi I am trying find why this is hapening “Couldn’t find Ticket for
reminder 2087. Please contact administrator.” since I have put the cleanup
scripts and they workes when I do testing. But once in a while I get this
error on the dash board. What I do is log in to the DB and make it resolved

I have been going through the DB and unable to find the relation between
the ticks and treminders

Thanks and Best Regards

From: Asanka Gunasekera asanka_gunasekera@yahoo.co.uk
To: “rt-users@lists.bestpractical.com” rt-users@lists.bestpractical.com

Sent: Thursday, 20 September 2012, 14:14
Subject: [rt-users] relations between reminder and ticket

Hi anyone can tell me where RT keeps the relationship between a ticket and
a reminder

Thanks and Regards

Final RT training for 2012 in Atlanta, GA - October 23 & 24
http://bestpractical.com/training

We’re hiring! Careers — Best Practical Solutions

Final RT training for 2012 in Atlanta, GA - October 23 & 24
http://bestpractical.com/training

We’re hiring! Careers — Best Practical Solutions

4

any one have came across this :(From: Asanka Gunasekera asanka_gunasekera@yahoo.co.uk
To: “rt-users@lists.bestpractical.com” rt-users@lists.bestpractical.com
Sent: Tuesday, 25 September 2012, 13:06
Subject: Re: [rt-users] relations between reminder and ticket

Hi I am trying find why this is hapening “Couldn’t find Ticket for reminder 2087. Please contact administrator.” since I have put the cleanup scripts and they workes when I do testing. But once in a while I get this error on the dash board. What I do is log in to the DB and make it resolved

I have been going through the DB and unable to find the relation between the ticks and treminders

Thanks and Best Regards

From: Asanka Gunasekera asanka_gunasekera@yahoo.co.uk
To: “rt-users@lists.bestpractical.com” rt-users@lists.bestpractical.com
Sent: Thursday, 20 September 2012, 14:14
Subject: [rt-users] relations between reminder and ticket

Hi anyone can tell me where RT keeps the relationship between a ticket and a reminder

Thanks and Regards

Final RT training for 2012 in Atlanta, GA - October 23 & 24
Training — Best Practical Solutions

We’re hiring! http://bestpractical.com/jobs

5

Hi I am getting this messages “Couldn’t find Ticket for reminder 2189. Please contact administrator.” though I am running this cleanup scripts, can some one tell me what is going on

This is not for all the reminders that I see this message, once in a while this would appear and I need to clean them up from the backend

Thanks and regardsFrom: Asanka Gunasekera asanka_gunasekera@yahoo.co.uk
To: “rt-users@lists.bestpractical.com” rt-users@lists.bestpractical.com
Sent: Monday, 8 October 2012, 22:42
Subject: Re: [rt-users] relations between reminder and ticket

any one have came across this :frowning:

From: Asanka Gunasekera asanka_gunasekera@yahoo.co.uk
To: “rt-users@lists.bestpractical.com” rt-users@lists.bestpractical.com
Sent: Tuesday, 25 September 2012, 13:06
Subject: Re: [rt-users] relations between reminder and ticket

Hi I am trying find why this is hapening “Couldn’t find Ticket for reminder 2087. Please contact administrator.” since I have put the cleanup scripts and they workes when I do testing. But once in a while I get this error on the dash board. What I do is log in to the DB and make it resolved

I have been going through the DB and unable to find the relation between the ticks and treminders

Thanks and Best Regards

From: Asanka Gunasekera asanka_gunasekera@yahoo.co.uk
To: “rt-users@lists.bestpractical.com” rt-users@lists.bestpractical.com
Sent: Thursday, 20 September 2012, 14:14
Subject: [rt-users] relations between reminder and ticket

Hi anyone can tell me where RT keeps the relationship between a ticket and a reminder

Thanks and Regards

Final RT training for 2012 in Atlanta, GA - October 23 & 24
Training — Best Practical Solutions

We’re hiring! http://bestpractical.com/jobs

6

Hi,

sounds like you deleted some rows directly in the database. You should use the Shredder to fully delete items in RT, rather than playing in the DB directly.

For now I would suggest you check out the docs for rt-validator, which may be able to help you find the orphaned rows.

Regards

Chris O’Kelly
Web Administrator

Minecorp Australia
37 Murdoch Circuit
Acacia Ridge QLD 4110
minecorp.com.auhttp://www.minecorp.com.au

P: 07 3723 1000
M: 0450 586 190
E: Chris.okelly@minecorp.com.aumailto:Chris.okelly@minecorp.com.au
S: chris.okelly.mvshttp://skype.com

[http://i.imgur.com/xYx0A.png]From: rt-users-bounces@lists.bestpractical.com [mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Asanka Gunasekera
Sent: Wednesday, 14 November 2012 3:13 PM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] relations between reminder and ticket

Hi I am getting this messages “Couldn’t find Ticket for reminder 2189. Please contact administrator.” though I am running this cleanup scripts, can some one tell me what is going on

This is not for all the reminders that I see this message, once in a while this would appear and I need to clean them up from the backend

Thanks and regards

From: Asanka Gunasekera asanka_gunasekera@yahoo.co.uk
To: “rt-users@lists.bestpractical.com” rt-users@lists.bestpractical.com
Sent: Monday, 8 October 2012, 22:42
Subject: Re: [rt-users] relations between reminder and ticket

any one have came across this :frowning:

From: Asanka Gunasekera asanka_gunasekera@yahoo.co.uk
To: “rt-users@lists.bestpractical.com” rt-users@lists.bestpractical.com
Sent: Tuesday, 25 September 2012, 13:06
Subject: Re: [rt-users] relations between reminder and ticket

Hi I am trying find why this is hapening “Couldn’t find Ticket for reminder 2087. Please contact administrator.” since I have put the cleanup scripts and they workes when I do testing. But once in a while I get this error on the dash board. What I do is log in to the DB and make it resolved

I have been going through the DB and unable to find the relation between the ticks and treminders

Thanks and Best Regards

From: Asanka Gunasekera asanka_gunasekera@yahoo.co.uk
To: “rt-users@lists.bestpractical.com” rt-users@lists.bestpractical.com
Sent: Thursday, 20 September 2012, 14:14
Subject: [rt-users] relations between reminder and ticket

Hi anyone can tell me where RT keeps the relationship between a ticket and a reminder

Thanks and Regards

Final RT training for 2012 in Atlanta, GA - October 23 & 24
Training — Best Practical Solutions

We’re hiring! http://bestpractical.com/jobs