<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal">Hi All.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">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.
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">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.
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">[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)<o:p></o:p></p>
<p class="MsoNormal">[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)<o:p></o:p></p>
<p class="MsoNormal">[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)<o:p></o:p></p>
<p class="MsoNormal">[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)<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black;background:white">thanks<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:red;background:white"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;color:black">LeAnn Spradling | Manager<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;color:black">CAP EPA CAM | CGI Federal<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;color:black">2800 Meridian Pkwy, Durham, NC 27713
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;color:black">T: 919-294-3721 |M: 919-260-2750 | spradling.leann@epa.gov</span><span style="font-size:10.0pt;color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;color:black"><br>
<br>
</span><span style="font-size:10.0pt;font-family:"Arial","sans-serif""><o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>