[rt-users] Difficulties converting mySQL to Oracle

[Spradling, LeAnn]

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 | spradling.leann at epa.gov



-----Original Message-----
From: rt-users [mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Kevin Falcone
Sent: Friday, November 21, 2014 5:41 PM
To: rt-users at lists.bestpractical.com
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