[rt-users] Difficulties converting mySQL to Oracle

[Spradling, LeAnn]

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)

thanks

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



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