Thanks. We discovered the sequence problems but I will pass that to our DBAs.
We will have to repeat this process for our prod environment, so any suggestions or pointers to documentation for supported/better migration techniques would be welcomed. This document was the most detailed I found: http://requesttracker.wikia.com/wiki/MySQLToOracle LeAnn Spradling | Manager CAP EPA CAM | CGI Federal 2800 Meridian Pkwy, Durham, NC 27713 T: 919-294-3721 |M: 919-260-2750 | [email protected] -----Original Message----- From: rt-users [mailto:[email protected]] On Behalf Of Kevin Falcone Sent: Friday, November 21, 2014 5:41 PM To: [email protected] Subject: Re: [rt-users] Difficulties converting mySQL to Oracle On Thu, Nov 20, 2014 at 03:46:12PM +0000, Spradling, LeAnn wrote: > We did a mysqldump and imported using Oracle SQL Loader. Our DBAs > found a sequence error and corrected it, a number of MYSQL-type > delimiters were removed, but we are still getting stuff like the below. I have to start by saying this is not something we'd considered a 'supported migration technique'. Especially given your errors. > > [Thu Nov 20 15:34:33 2014] [crit]: Couldn't create a Principal on new > user create. Strange things are afoot at the circle K > (/public/server/apps/rt-home/ > sbin/../lib/RT/Group.pm:456) Your DBAs should compare https://github.com/bestpractical/rt/blob/maint/etc/schema.Oracle to what you have, you're missing or have incorrect sequences. -kevin
