Re: [rt-users] Error during make upgrade-database -- RTx::AssetTracker::Type

2012-12-24 Thread chirag.parikh
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



Re: [rt-users] Error during make upgrade-database -- RTx::AssetTracker::Type

2012-12-24 Thread Thomas Sibley
On 12/21/2012 09:40 AM, chirag.par...@thomsonreuters.com wrote:
 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!

The error you're seeing is because RTx-AssetTracker isn't loaded yet
there are records referencing it in the database.

Since AssetTracker is a third-party extension, I suggest tracking down
the AT team and seeing what they suggest.  Sometimes they respond on
rt-users, but not always.  I don't think AT is supported on RT 4, however.



Re: [rt-users] Error during make upgrade-database -- RTx::AssetTracker::Type

2012-12-24 Thread Joop
chirag.par...@thomsonreuters.com wrote:

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!
Remove AT temporarily from RT_Siteconfig.pm and retry the upgrade. Find AT on 
github for the latest version which does work with 4.0.x

Joop
 

-- 
Sent from my Android phone with K-9 Mail. Please excuse my brevity.


Re: [rt-users] Error during make upgrade-database -- RTx::AssetTracker::Type

2012-12-24 Thread chirag.parikh
Hi Joop,
Thanks for responding. I have already removed AT from RT_SiteConfig.pm, and 
still getting this error. I have also downloaded new AT from github which I 
plan to use after I can setup new RT successfullyi.e. if only I can get 
past this make upgrade-database to succeed somehow. It succeeded for the 
first half of the upgrade (from 3.4.5 to 3.7.87 once I commented out AT), but 
the after applying RT 3.8 schema upgrade queries (also successful), it fails on 
second half of upgrade-database (from 3.7.87 onwards). This is why its puzzling 
me that removing AT from Siteconfig worked for first half, but not the second 
half. Any advise?

Chirag.

-Original Message-
From: Joop [mailto:jvdw...@xs4all.nl] 
Sent: Monday, December 24, 2012 2:58 PM
To: Parikh, Chirag (FinancialRisk); rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Error during make upgrade-database -- 
RTx::AssetTracker::Type

chirag.par...@thomsonreuters.com wrote:

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!
Remove AT temporarily from RT_Siteconfig.pm and retry the upgrade. Find AT on 
github for the latest version which does work with 4.0.x

Joop
 

-- 
Sent from my Android phone with K-9 Mail. Please excuse my brevity.