Couldn't find Ticket for reminder XXXXX Please contact administrator. AFTER 3.8.1 to 4.2.5/6 upgrade

Hi,

I have been working on upgrading our production RT 3.8.1 install to RT
4.2.6 and am almost ready to deploy to production. The only issue I am
having is after the upgrade process, when I log in I am seeing missing
reminders.

As I posted earlier, I was originally trying to do some database cleanup
and pruning before the database upgrade but found it was not necessary
at this point. So the only things I have done, are move/rename the rt3
database to rt4 and run make upgrade-database.

While the errors do not seem to be show stoppers, I would like to know
if I can do something to fix these errors (recover the reminders) or do
something to clean the errors up so after the upgrade, our users are not
greeted with errors when they log in.

Thanks,

Dave

I have been working on upgrading our production RT 3.8.1 install to RT 4.2.6
and am almost ready to deploy to production. The only issue I am having is
after the upgrade process, when I log in I am seeing missing reminders.

An RT that old will have had a number of reminders bugs.
Generally it means that either a ticket moved queues but the reminder
didn’t, or you shredded with an old shredder that didn’t follow links
to reminders. In either case, you can use the id you elided from your
error message to look at the tickets and links tables and see what
needs updating or deleting.

rt-validator may also notice dangling links.

-kevin

Thanks for the info Kevin.

After poking around in the database, I saw where the status of the
reminders were still set as open. There were few enough orphaned
reminders such that I just opened the reminder via simple search and the
changed the status to resolved.

I don’t think this will be a wide spread issue, so I will just tell end
users to do the same once the new ticket system is brought online.

Thanks,

DaveOn 7/24/2014 10:15 AM, Kevin Falcone wrote:

On Mon, Jul 21, 2014 at 10:58:03AM -0500, Lists wrote:

I have been working on upgrading our production RT 3.8.1 install to RT 4.2.6
and am almost ready to deploy to production. The only issue I am having is
after the upgrade process, when I log in I am seeing missing reminders.
An RT that old will have had a number of reminders bugs.
Generally it means that either a ticket moved queues but the reminder
didn’t, or you shredded with an old shredder that didn’t follow links
to reminders. In either case, you can use the id you elided from your
error message to look at the tickets and links tables and see what
needs updating or deleting.

rt-validator may also notice dangling links.

-kevin