<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:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@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;}
/* 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;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@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"><span style="color:#1F497D">Hi,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">I was just wondering if anyone has any suggestions for my below issue. Anyone on database upgrade expert? I’m stuck on below mentioned step. Please help!<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Chirag.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal" style="margin-left:.5in"><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""> rt-users-bounces@lists.bestpractical.com [mailto:rt-users-bounces@lists.bestpractical.com]
<b>On Behalf Of </b>Parikh, Chirag (Financial&Risk)<br>
<b>Sent:</b> Friday, December 21, 2012 12:41 PM<br>
<b>To:</b> rt-users@lists.bestpractical.com<br>
<b>Subject:</b> [rt-users] Error during make upgrade-database -- RTx::AssetTracker::Type<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal" style="margin-left:.5in"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-left:.5in">Hello,<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in">I’m currently using RT 3.4.5 with AssetTracker extension and with Mysql 5 database. I want to setup new RT 4.0.8 on a new server with importing database from old server (generating mysqldump from old and populating
DB on new server). I’m able to use make upgrade for this purpose and follow steps in UPGRADING.mysql file upto “Item 7”. That is, run “make upgrade-database” and apply updates from 3.4.5 up to 3.7.87 (as suggested in UPGRADING.mysql file). Then I’m able to
apply RT 3.8 schema upgrades by generating and applying queries (upto Item 7). But, then in Item 8, I have to run make upgrade-database again to apply remaining updates (starting from 3.7.87). This is when I encounter below error and cannot proceed further.
Any help/suggestions on fixing this would be greatly appreciated. Please help!<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-left:.5in"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-left:.5in">[root@isupport rt-4.0.8]# make upgrade-database<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in">/usr/bin/perl -I/opt/rt4/local/lib -I/opt/rt4/lib sbin/rt-setup-database --action upgrade --prompt-for-dba-password<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in">In order to create or update your RT database, this script needs to connect to your mysql instance on localhost as root<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in">Please specify that user's database password below. If the user has no database<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in">password, just press return.<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-left:.5in">Password: <o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in">Working with:<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in">Type: mysql<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in">Host: localhost<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in">Name: rt<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in">User: rt<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in">DBA: root<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in">Enter RT version you're upgrading from: 3.7.87<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-left:.5in">Going to apply following upgrades:<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in">* 3.8.0<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in">* 3.8.1<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in">* 3.8.2<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in">* 3.8.3<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in">* 3.8.4<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in">* 3.8.6<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in">* 3.8.8<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in">* 3.8.9<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in">* 3.9.1<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in">* 3.9.2<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in">* 3.9.3<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in">* 3.9.5<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in">* 3.9.6<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in">* 3.9.7<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in">* 3.9.8<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in">* 4.0.0rc2<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in">* 4.0.0rc4<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in">* 4.0.0rc7<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in">* 4.0.1<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in">* 4.0.3<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in">* 4.0.4<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in">* 4.0.6<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-left:.5in">Enter RT version if you want to stop upgrade at some point,<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in"> or leave it blank if you want apply above upgrades:
<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-left:.5in">IT'S VERY IMPORTANT TO BACK UP BEFORE THIS STEP<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-left:.5in">Proceed [y/N]:y<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in">Processing 3.8.0<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in">Now inserting data.<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in">Processing 3.8.1<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in">Now inserting data.<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in">Processing 3.8.2<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in">Now inserting data.<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in">[Thu Dec 20 23:16:43 2012] [warning]: Going to add [OLD] prefix to all templates in approvals queue. If you have never used approvals, you can safely delete all the templates with the [OLD] prefix. Leave the new
Approval templates because you may eventually want to start using approvals. (./etc/upgrade/3.8.2/content:3)<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in">[Thu Dec 20 23:16:43 2012] [error]: That principal already has that right (/opt/download/rt-4.0.8/sbin/../lib/RT/Handle.pm:971)<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in">[Thu Dec 20 23:16:43 2012] [warning]: IMPORTANT: We're going to delete all scrips in Approvals queue and save them in 'rt-approvals-scrips-xml5' file. (./etc/upgrade/3.8.2/content:165)<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in">Processing 3.8.3<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in">Now inserting data.<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in">Processing 3.8.4<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in">Now inserting data.<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in">Processing 3.8.6<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in">Now inserting data.<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in">Processing 3.8.8<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in">Now inserting data.<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in">Couldn't finish 'upgrade' step.<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-left:.5in"><b><span style="color:red">ERROR: One of initial functions failed: Can't locate object method "new" via package "RTx::AssetTracker::Type" (perhaps you forgot to load "RTx::AssetTracker::Type"?) at /opt/download/rt-4.0.8/sbin/../lib/RT/ObjectCustomField.pm
line 148, <> line 1.<o:p></o:p></span></b></p>
<p class="MsoNormal" style="margin-left:.5in"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-left:.5in"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-left:.5in"><b><span style="color:red">make: *** [upgrade-database] Error 255<o:p></o:p></span></b></p>
<p class="MsoNormal" style="margin-left:.5in"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-left:.5in"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-left:.5in"><b><span lang="EN" style="font-size:10.0pt;color:#E36C0A">· · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · ·</span></b><span lang="EN" style="font-size:10.0pt;color:#F79646"><br>
</span><b><span lang="EN" style="color:#595959">Chirag Parikh</span></b><span lang="EN" style="font-size:10.0pt;color:#1F497D"><o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:.5in"><b><span lang="EN" style="font-size:10.0pt;color:#F79646">Thomson Reuters Financial & Risk<o:p></o:p></span></b></p>
<p class="MsoNormal" style="margin-left:.5in"><b><span lang="EN" style="font-size:10.0pt;color:#7F7F7F">195 Broadway, New York<o:p></o:p></span></b></p>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-size:10.0pt;font-family:Wingdings;color:#F79646">(</span><span style="font-size:10.0pt;color:#E36C0A">
</span><b><span style="font-size:10.0pt;color:#7F7F7F">(646) 822-3951</span></b><span style="font-size:10.0pt;color:#E36C0A"><o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:.5in"><b><span style="font-size:10.0pt;font-family:Wingdings;color:#F79646">*</span></b><b><span style="font-size:10.0pt;color:#F79646"> </span></b><b><span style="font-size:10.0pt;color:#E36C0A">
</span></b><a href="mailto:Chirag.Parikh@ThomsonReuters.com"><b><span style="font-size:10.0pt;color:#7F7F7F">Chirag.Parikh@ThomsonReuters.com</span></b></a><b><span lang="EN" style="font-size:10.0pt;color:#548DD4"><o:p></o:p></span></b></p>
<p class="MsoNormal" style="margin-left:.5in"><o:p> </o:p></p>
</div>
</body>
</html>