[rt-users] Post upgrade 3.8.5 to 4.0.12 Global->RT At A Glance error

[Thomas Sibley]

Thanks for the information, notes below.

On 05/09/2013 09:29 AM, Pete Beebe wrote:
>>>> Do you have any local customizations?
> 
> None that I'm aware of.  Only plugins I've currently go in place are:
> RT::Authen::ExternalAuth RT::Extension::ActivityReports
> 
>>>> Can you send us the output of running this SQL query?  select
>>>> id, Name, Description, ObjectType, ObjectId from Attributes
>>>> where ObjectType='RT::System';
> 
>>>> Could you also navigate to Configuration -> Tools -> System
>>>> Config in RT, save that page as HTML, and send the file?  Make
>>>> sure any sensitive data is redacted first.
> 
> Both the Select query and the system config HTML page and files have
> been included in the attached ZIP file.

Your system config page and SQL results reveal that you have duplicate
copies (3 total of each record) of certain global data.  This suggests
your migration from MySQL to Oracle was flawed.  How did you migrate,
exactly?

Your database may contain duplicate internal records in other areas too,
which are likely to lead to more problems (and potentially very subtle
ones).  What do these queries return?

select id, Name, Created, LastUpdated from Users where Name in
('RT_System', 'Nobody', 'root');

select id, Domain, Type, Created, LastUpdated from Groups where Type in
('Everyone', 'Privileged', 'Unprivileged');

> I'm unsure of how to reply to this and have it also update the forum
> thread so I've omitted the rt-users at lists.bestpractical.com address
> when sending the e-mail.

You reply by sending to rt-users at lists.bestpractical.com.  That sends to
the mailing list, and I'll read it since I'm subscribed.