[rt-users] Difficulties converting mySQL to Oracle

Spradling, LeAnn Spradling.LeAnn at epa.gov
Thu Nov 20 10:46:12 EST 2014

Hi All.

We are on 4.0.6 and tried to convert our mySQl database to Oracle. While we seem to be able to read from the database, and update old tickets in some cases, we can't create new tickets or users. Any tips appreciated.

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.

[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)
[Thu Nov 20 15:34:33 2014] [error]: Couldn't create a ticket group of type 'Requestor' for ticket 49782: Could not create group (/public/server/apps/rt-home/sbin/../lib/RT/Ticket.pm:1002)
[Thu Nov 20 15:34:33 2014] [crit]: Couldn't create ticket groups for ticket 49782. aborting Ticket creation. (/public/server/apps/rt-home/sbin/../lib/RT/Ticket.pm:522)
[Thu Nov 20 15:34:33 2014] [error]: WebRT: Ticket could not be created due to an internal error (/public/server/apps/rt-4.0.6_oracle_attempt_second_initialize/share/html/Elements/Error:82)


LeAnn Spradling | Manager
2800 Meridian Pkwy, Durham, NC 27713
T: 919-294-3721 |M: 919-260-2750 | spradling.leann at epa.gov

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20141120/2b3b24a7/attachment.htm>

More information about the rt-users mailing list