RT at the University of West Bohemia

Hello,

on Jesse’s advice I forward my mail to this list and I hope someone could
help…

Petr,
I’m currently traveling and will be a very bad correspondent for quite a
while. Can you easily mail rt-users? I suspect one of my staff will have
useful comments.
Best,
Jesse

Hello Jesse,

← cutted personal paragraph →

Nowadays we are planning upgrade the really old RT 2.0.15 to
RT 3.6.x from Debian distribution. We want to keep all tickets from RT2
(more than65.000 tickets), but I have got a lot of problems with migration tool
(rt2-to-rt3-1.23). We wanted to migrate tickets to RDBS Oracle, but with
thistool I was able to migrate only users. See migration tool output:

---- output ----
…users were imported here…
.uCreating user ĞÄL’žL’žÂ¸A(´@test.com ← the last user
.
Importing groups
gggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr[Tue
Apr 17 10:50:40 2007] [crit]: 1
(/usr/share/request-tracker3.6/lib/RT/ACE_Overlay.pm:907)
[Tue Apr 17 10:50:40 2007] [crit]: Can’t load a principal for id
(/usr/share/request-tracker3.6/lib/RT/ACE_Overlay.pm:908)
rrrrrfqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqImporting
tickets…t-1
Couldn’t create trans 1
$VAR1 = {
‘Type’ => ‘Create’,
‘Ticket’ => ‘1’,
‘Created’ => ‘1999-03-15 11:21:57’,
‘id’ => 1,
‘Creator’ => ‘35863’,
‘ActivateScrips’ => ‘0’
};
---- output ----

When I deleted all transactions by hand after importing users then
I was able to migrate several hundreds of tickets. But, it ended with
this log:

— output ----
.t-1143
.t-1144
.t-1145
Couldn’t create trans 47054
$VAR1 = {
‘Type’ => ‘Comment’,
‘Ticket’ => ‘1145’,
‘Created’ => ‘2002-05-03 13:19:19’,
‘id’ => 47054,
‘Creator’ => undef,
‘Data’ => ‘No Subject’,
‘ActivateScrips’ => ‘0’
};
---- output ----

and exited the script.

When I tried to access the home page in RT it took more than 1 minute
(with those 1144 tickets). In DB I could see several million records
sent to the script. So I think the “limit” for the select is not working
properly in Oracle - OR - this happens due to interrupted migration. I
don’t know.

Then we decided to stay on MySQL platform - but there are similar
problems with Transactions which has to be deleted by hand before
tickets import. And - I don’t know if is it bug or feature - all
correspondence in tickets in RT3 are inserted by “RT system”. It means
the migration tool doesn’t save the identity of users who replied to
tickets.
The problem with ticket 1145 didn’t appear when converting the data
within MySQL. But from time to time there are some other errors in the
output:

---- output —
.t-16248
.t-16249
.t-16250
[Tue Apr 17 11:28:11 2007] [error]: Could not create a new user -
(/usr/share/request-tracker3.6/lib/RT/User_Overlay.pm:267)
[Tue Apr 17 11:28:16 2007] [crit]: Failed to create user
l(?žž¸ô@test.com: Could
not create user (/usr/share/request-tracker3.6/lib/RT/User_Overlay.pm:615)
[Tue Apr 17 11:28:16 2007] [error]: Could not load create a user with
the emailaddress ‘l(?žž¸ô@test.com’ to add as a watcher for ticket 16250
(/usr/share/request-tracker3.6/lib/RT/Ticket_Overlay.pm:1423)
.t-16251
[Tue Apr 17 11:28:16 2007] [error]: Could not create a new user -
(/usr/share/request-tracker3.6/lib/RT/User_Overlay.pm:267)
[Tue Apr 17 11:28:21 2007] [crit]: Failed to create user
l(?žž¸ô@test.com: Could not create user
(/usr/share/request-tracker3.6/lib/RT/User_Overlay.pm:615)
[Tue Apr 17 11:28:21 2007] [error]: Could not create a new user -
(/usr/share/request-tracker3.6/lib/RT/User_Overlay.pm:267)
[Tue Apr 17 11:28:26 2007] [crit]: Failed to create user
l(?žž¸ô@test.com: Could not create user
(/usr/share/request-tracker3.6/lib/RT/User_Overlay.pm:615)
[Tue Apr 17 11:28:26 2007] [error]: Could not load create a user with
the email address ‘l(?žž¸ô@test.com’ to add as a watcher for ticket 16251
(/usr/share/request-tracker3.6/lib/RT/Ticket_Overlay.pm:1423)
.t-16252
[Tue Apr 17 11:28:26 2007] [error]: Could not create a new user -
(/usr/share/request-tracker3.6/lib/RT/User_Overlay.pm:267)
[Tue Apr 17 11:28:31 2007] [crit]: Failed to create user
l(?žž¸ô@test.com: Could not create user
(/usr/share/request-tracker3.6/lib/RT/User_Overlay.pm:615)
[Tue Apr 17 11:28:32 2007] [error]: Could not create a new user -
(/usr/share/request-tracker3.6/lib/RT/User_Overlay.pm:267)
[Tue Apr 17 11:28:37 2007] [crit]: Failed to create user
l(?žž¸ô@test.com: Could not create user
(/usr/share/request-tracker3.6/lib/RT/User_Overlay.pm:615)
[Tue Apr 17 11:28:37 2007] [error]: Could not load create a user with
the email address ‘l(?žž¸ô@test.com’ to add as a watcher for ticket 16252
(/usr/share/request-tracker3.6/lib/RT/Ticket_Overlay.pm:1423)
.t-16253
.t-16254
.t-16255
.t-16256
---- output ----

In the README file of migration tool there is a sentence “This tool
migrates your RT2 instance to an RT 3.0 instance”. Couldn’t be this the
source of problems when I’m trying to migrate data to RT 3.6.x?

Would you know about any newer version of migration tool without such
problems? Even commercial/payed version? Or any ideas what could be
wrong and what should we focus on?

Thank you a lot for concerning our problem, best regards
Petr Grolmus

Petr Grolmus

Laboratory for Computer Science
University of West Bohemia
Univerzitni 20, 306 14 Pilsen Tel.: +420 377 632 851
Czech Republic E-mail: indy@civ.zcu.cz

In the README file of migration tool there is a sentence “This tool
migrates your RT2 instance to an RT 3.0 instance”. Couldn’t be this
the
source of problems when I’m trying to migrate data to RT 3.6.x?

Would you know about any newer version of migration tool without such
problems? Even commercial/payed version? Or any ideas what could be
wrong and what should we focus on?

Hi Petr

Can you try

This is a new release of the rt2-to-rt3 tool that works with 3.6.
We didn’t test on Oracle (we went mysql=>mysql) but this new release
fixed a number of bugs.

-kevin

Thank you, Kevin. I’ll try it! :wink:

-indy

In the README file of migration tool there is a sentence “This tool
migrates your RT2 instance to an RT 3.0 instance”. Couldn’t be this
the
source of problems when I’m trying to migrate data to RT 3.6.x?

Would you know about any newer version of migration tool without such
problems? Even commercial/payed version? Or any ideas what could be
wrong and what should we focus on?

Hi Petr

Can you try
RT-Extension-RT2toRT3-1.26 - This tool migrates your RT2 instance to an RT 3.x instance - metacpan.org

This is a new release of the rt2-to-rt3 tool that works with 3.6.
We didn’t test on Oracle (we went mysql=>mysql) but this new release
fixed a number of bugs.

-kevin

                                          Petr Grolmus

Petr Grolmus

Laboratory for Computer Science
University of West Bohemia
Univerzitni 20, 306 14 Pilsen Tel.: +420 377 632 851
Czech Republic E-mail: indy@civ.zcu.cz