<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","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;}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
{mso-style-priority:99;
mso-style-link:"Plain Text Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.5pt;
font-family:Consolas;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.PlainTextChar
{mso-style-name:"Plain Text Char";
mso-style-priority:99;
mso-style-link:"Plain Text";
font-family:Consolas;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
-->
</style>
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoPlainText">Hello all,</p>
<p class="MsoPlainText"> </p>
<p class="MsoPlainText">I tried again upgrading the db part and as you see no appearing
errors. Still we have errors when creating a ticket or assigning unassigned
tickets</p>
<p class="MsoPlainText"> </p>
<p class="MsoPlainText">Thanks!</p>
<p class="MsoPlainText"> </p>
<p class="MsoPlainText">Fadel</p>
<p class="MsoPlainText"> </p>
<p class="MsoPlainText">--upgrade begins--</p>
<p class="MsoPlainText"># ./sbin/rt-setup-database --action upgrade In order to
create or update your RT database, this script needs to connect to your
Oracle instance on x.x.x.x as rt Please specify that user's database password
below. If the user has no database password, just press return.</p>
<p class="MsoPlainText"> </p>
<p class="MsoPlainText">Password: </p>
<p class="MsoPlainText">Working with:</p>
<p class="MsoPlainText">Type: Oracle</p>
<p class="MsoPlainText">Host: x.x.x.x</p>
<p class="MsoPlainText">Name: rtdb</p>
<p class="MsoPlainText">User: rt</p>
<p class="MsoPlainText">DBA: rt</p>
<p class="MsoPlainText">Enter RT version you're upgrading from: 3.6.4</p>
<p class="MsoPlainText"> </p>
<p class="MsoPlainText">Going to apply following upgrades:</p>
<p class="MsoPlainText">* 3.7.1</p>
<p class="MsoPlainText">* 3.7.3</p>
<p class="MsoPlainText">* 3.7.10</p>
<p class="MsoPlainText">* 3.7.15</p>
<p class="MsoPlainText">* 3.7.19</p>
<p class="MsoPlainText">* 3.7.81</p>
<p class="MsoPlainText">* 3.7.82</p>
<p class="MsoPlainText">* 3.7.85</p>
<p class="MsoPlainText">* 3.7.86</p>
<p class="MsoPlainText">* 3.7.87</p>
<p class="MsoPlainText">* 3.8.0</p>
<p class="MsoPlainText">* 3.8.1</p>
<p class="MsoPlainText">* 3.8.2</p>
<p class="MsoPlainText">* 3.8.3</p>
<p class="MsoPlainText">* 3.8.4</p>
<p class="MsoPlainText">* 3.8.6</p>
<p class="MsoPlainText"> </p>
<p class="MsoPlainText">Enter RT version if you want to stop upgrade at some
point,</p>
<p class="MsoPlainText"> or leave it blank if you want apply above
upgrades:</p>
<p class="MsoPlainText"> </p>
<p class="MsoPlainText">IT'S VERY IMPORTANT TO BACK UP BEFORE THIS STEP</p>
<p class="MsoPlainText"> </p>
<p class="MsoPlainText">Proceed [y/N]:y</p>
<p class="MsoPlainText">Processing 3.7.1</p>
<p class="MsoPlainText">Now inserting data</p>
<p class="MsoPlainText">Processing 3.7.3</p>
<p class="MsoPlainText">Now populating database schema.</p>
<p class="MsoPlainText">Processing 3.7.10</p>
<p class="MsoPlainText">Now inserting data</p>
<p class="MsoPlainText">Processing 3.7.15</p>
<p class="MsoPlainText">Now inserting data</p>
<p class="MsoPlainText">Processing 3.7.19</p>
<p class="MsoPlainText">Now inserting data</p>
<p class="MsoPlainText">Added description to scrip #67</p>
<p class="MsoPlainText">Added description to scrip #22</p>
<p class="MsoPlainText">Added description to scrip #23</p>
<p class="MsoPlainText">Added description to scrip #1</p>
<p class="MsoPlainText">Added description to scrip #4</p>
<p class="MsoPlainText">Added description to scrip #7</p>
<p class="MsoPlainText">Added description to scrip #21</p>
<p class="MsoPlainText">Processing 3.7.81</p>
<p class="MsoPlainText">Now populating database schema.</p>
<p class="MsoPlainText">Processing 3.7.82</p>
<p class="MsoPlainText">Now inserting data</p>
<p class="MsoPlainText">Processing 3.7.85</p>
<p class="MsoPlainText">Now inserting data</p>
<p class="MsoPlainText">Processing 3.7.86</p>
<p class="MsoPlainText">Now inserting data</p>
<p class="MsoPlainText">Processing 3.7.87</p>
<p class="MsoPlainText">Now inserting data</p>
<p class="MsoPlainText">Processing 3.8.0</p>
<p class="MsoPlainText">Now inserting data</p>
<p class="MsoPlainText">Processing 3.8.1</p>
<p class="MsoPlainText">Now inserting data</p>
<p class="MsoPlainText">Processing 3.8.2</p>
<p class="MsoPlainText">Now inserting data</p>
<p class="MsoPlainText">[Tue Nov 9 19:50:54 2010] [warning]: Going to add
[OLD] prefix to all temlates in approvals queue. If you never used approvals
then you can delete all these templates with [OLD] prefix. Leave new there may
be you will want to use approvals some time. (./etc/upgrade/3.8.2/content:3)
[Tue Nov 9 19:50:56 2010] [warning]: IMPORTANT: We're going to delete all
scrips in Approvals queue and save them in 'rt-approvals-scrips-q3Mu' file.</p>
<p class="MsoPlainText">(./etc/upgrade/3.8.2/content:165)</p>
<p class="MsoPlainText">Processing 3.8.3</p>
<p class="MsoPlainText">Now inserting data</p>
<p class="MsoPlainText">Processing 3.8.4</p>
<p class="MsoPlainText">Now inserting data</p>
<p class="MsoPlainText">Processing 3.8.6</p>
<p class="MsoPlainText">Now inserting data</p>
<p class="MsoPlainText">Done.</p>
<p class="MsoPlainText">--upgrade ends--</p>
<p class="MsoPlainText"> </p>
<p class="MsoPlainText">Please note that the "rt-setup-database" script
was executed from the RT installation folder (NOT the installed folder in
/opt/rt3)</p>
<p class="MsoPlainText"> </p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D"> </span></p>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">
<a href="mailto:rt-users-bounces@lists.bestpractical.com">rt-users-bounces@lists.bestpractical.com</a>
[mailto:<a href="mailto:rt-users-bounces@lists.bestpractical.com">rt-users-bounces@lists.bestpractical.com</a>] <b>On Behalf Of </b>Kenneth
Crocker<br>
<b>Sent:</b> October 27, 2010 3:50 PM<br>
<b>To:</b> <a href="mailto:rt-users@lists.bestpractical.com">rt-users@lists.bestpractical.com</a><br>
<b>Subject:</b> Re: [rt-users] Couldn't create a ticket group of type
'Requestor'</span></p>
</div>
<p class="MsoNormal"> </p>
<p class="MsoNormal" style="margin-bottom:12.0pt">Fadel,<br>
<br>
You say you migrated the 3.6.4 database over. Did you run the UPGRADE to the
DataBase?<br>
<br>
There are instructions on this in the README for the upgrade.<br>
<br>
Kenn<br>
LBNL</p>
<div>
<p class="MsoNormal">On Wed, Oct 27, 2010 at 11:10 AM, Fadel Kamreddine <<a href="mailto:fadel.kamreddine@biond.net">fadel.kamreddine@biond.net</a>>
wrote:</p>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:11.0pt">Hi,<br>
<br>
Current setting is RT 3.6.4 using Oracle 11gr1 and it's running fine.<br>
<br>
We are migrating to RT 3.8.7 on a new server and new oracle version 11gr2<br>
<br>
We installed RT 3.8.7 and copied all the RT schema to the new database<br>
instance.<br>
<br>
We did a test by using new RT version on existing 11gr1 database and it<br>
worked fine - this proves that the RT installation is fine we presume.<br>
<br>
We can login fine and browse through existing tickets, update existing<span style="color:#1F497D"> </span>owned<span style="color:#1F497D"> </span>ticket
but having issues when we need to create , take/assign a ticket<span style="color:#1F497D"> </span>and<br>
we cant see the contents of a ticket when it's not assigned<br>
<br>
Errors in rt log:<br>
<br>
<br>
<br>
[Wed Oct 27 15:07:05 2010] [error]: Couldn't create a ticket group of type<br>
'Requestor' for ticket 79713: Could not create group<br>
(/opt/rt3/bin/../lib/RT/Ticket_Overlay.pm:989)<br>
<br>
[Wed Oct 27 15:07:05 2010] [crit]: Couldn't create ticket groups for<br>
ticket<br>
79713. aborting Ticket creation.<br>
(/opt/rt3/bin/../lib/RT/Ticket_Overlay.pm:509)<br>
<br>
[Wed Oct 27 15:07:05 2010] [error]: WebRT: Ticket could not be created due<br>
to an internal error (/opt/rt3/share/html/Elements/Error:82)<br>
<br>
<br>
Any ideas?<br>
<br>
Thanks!</span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;margin-bottom:12.0pt"> </p>
</div>
</div>
</div>
<p class="MsoNormal"> </p>
</div>
</body>
</html>