Hi,
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!
Chirag.
From: rt-users-boun...@lists.bestpractical.com
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Parikh, Chirag
(FinancialRisk)
Sent: Friday, December 21, 2012 12:41 PM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] Error during make upgrade-database --
RTx::AssetTracker::Type
Hello,
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!
[root@isupport rt-4.0.8]# make upgrade-database
/usr/bin/perl -I/opt/rt4/local/lib -I/opt/rt4/lib sbin/rt-setup-database
--action upgrade --prompt-for-dba-password
In order to create or update your RT database, this script needs to connect to
your mysql instance on localhost as root
Please specify that user's database password below. If the user has no database
password, just press return.
Password:
Working with:
Type: mysql
Host: localhost
Name: rt
User: rt
DBA:root
Enter RT version you're upgrading from: 3.7.87
Going to apply following upgrades:
* 3.8.0
* 3.8.1
* 3.8.2
* 3.8.3
* 3.8.4
* 3.8.6
* 3.8.8
* 3.8.9
* 3.9.1
* 3.9.2
* 3.9.3
* 3.9.5
* 3.9.6
* 3.9.7
* 3.9.8
* 4.0.0rc2
* 4.0.0rc4
* 4.0.0rc7
* 4.0.1
* 4.0.3
* 4.0.4
* 4.0.6
Enter RT version if you want to stop upgrade at some point,
or leave it blank if you want apply above upgrades:
IT'S VERY IMPORTANT TO BACK UP BEFORE THIS STEP
Proceed [y/N]:y
Processing 3.8.0
Now inserting data.
Processing 3.8.1
Now inserting data.
Processing 3.8.2
Now inserting data.
[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)
[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)
[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)
Processing 3.8.3
Now inserting data.
Processing 3.8.4
Now inserting data.
Processing 3.8.6
Now inserting data.
Processing 3.8.8
Now inserting data.
Couldn't finish 'upgrade' step.
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.
make: *** [upgrade-database] Error 255
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Chirag Parikh
Thomson Reuters Financial Risk
195 Broadway, New York
* (646) 822-3951
* chirag.par...@thomsonreuters.commailto:chirag.par...@thomsonreuters.com