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

[Pete Beebe]

>>>>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?

As follows:
1. Created new OEL 6.4 x64 server running Apache/Mysqld from distrib packages.  Additionally installed a newer version of Perl and fought with character set issues between old and new server configurations.
2. mysqldump'd data from old server and imported into an empty rt4 mysql database on the new server
3. Upgraded mysql RT3 data to RT4 using make upgrade-database (4.0.12).
3. Prepped Oracle schema using RT 4.0.12 configuration and then truncated all tables from new schema as well as disabled constraints as prep for import.
4. Ran a perl script obtained from a user from this thread: http://requesttracker.8502.n7.nabble.com/mysql-to-oracle-migration-td34166.html.  Script pretty much copies records from their mysql tables into their respective Oracle tables
5. Re-created the Oracle sequences after import.
6. Re-enabled Oracle table constraints.

I could forward you a PDF of the actual upgrade steps however it's not for public digestion since it's replete with confidential data that'd be a PIA to scrub.

>>>What do these queries return? 

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

ID	NAME,CREATED,LASTUPDATED
10	Nobody,6-Sep-05,6-Sep-05
1	RT_System,6-Sep-05,6-Sep-05
12	root,6-Sep-05,	4-May-13

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

ID	DOMAIN,	TYPE,CREATED,LASTUPDATED
3	SystemInternal,Everyone,,		
4	SystemInternal,Privileged,,		
5	SystemInternal,Unprivileged,,



Disclaimer: This electronic message may contain information that is Confidential or legally privileged. It is intended only for the use of the individual(s) and entity named in the message. If you are not an intended recipient of this message, please notify the sender immediately and delete the material from your computer. Do not deliver, distribute or copy this message and do not disclose its contents or take any action in reliance on the information it contains.