[rt-users] Difficulties converting mySQL to Oracle

Kevin Falcone falcone at bestpractical.com
Fri Nov 21 17:41:24 EST 2014


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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 221 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20141121/8ac444c4/attachment.pgp>


More information about the rt-users mailing list