Problem running rt2-to-rt3-v1.13

RT Users
1

Hi list:

I did the upgrade today from 2.0.15 (very old, very old)
to 3.0.4, by installing 3.0.4 fresh, creating a new db,
and running upgrade script in rt2-to-rt3-v1.13.tar.gz.

rt-2.0-to-dumpfile works fine, and I got a few folders
(for the whole 4000+ tickets) as a result.

But the problem occurred when running dumpfile-to-rt-3.0.
Here’s the error msg:

[…]
Jul 22 16:58:12 mail5 RT: Resolver RT::URI::fsck_com_rt could not parse 4407
(/usr/local/rt3/lib/RT/URI.pm:121)
Jul 22 16:58:12 mail5 RT: Use of uninitialized value in concatenation (.) or
string at /usr/local/rt3/lib/RT/URI/fsck_com_rt.pm line 94.
(/usr/local/rt3/lib/RT.pm:235)
Jul 22 16:58:12 mail5 RT: Resolver RT::URI::fsck_com_rt could not parse 4407
(/usr/local/rt3/lib/RT/URI.pm:121)
Jul 22 16:58:12 mail5 RT: Use of uninitialized value in concatenation (.) or
string at /usr/local/rt3/lib/RT/URI/fsck_com_rt.pm line 94.
(/usr/local/rt3/lib/RT.pm:235)
Jul 22 16:58:12 mail5 RT: Resolver RT::URI::fsck_com_rt could not parse 4413
(/usr/local/rt3/lib/RT/URI.pm:121)
Jul 22 16:58:12 mail5 RT: Use of uninitialized value in concatenation (.) or
string at /usr/local/rt3/lib/RT/URI/fsck_com_rt.pm line 94.
(/usr/local/rt3/lib/RT.pm:235)
Jul 22 16:58:12 mail5 RT: Resolver RT::URI::fsck_com_rt could not parse 4413
(/usr/local/rt3/lib/RT/URI.pm:121)
[…]

Some more info:
[root@mail5 rt3]# perl -v
This is perl, v5.8.0 built for i686-linux
[…]

[root@mail5 rt3]# make testdeps
/usr/local/bin/perl ./sbin/rt-test-dependencies --with-mysql
MASON dependencies:
Params::Validate 0.02…found
Cache::Cache …found
Exception::Class …found
HTML::Mason 1.16…found
MLDBM …found
Errno …found
FreezeThaw …found
Digest::MD5 …found
CGI::Cookie 1.20…found
Storable …found
Apache::Session 1.53…found
MAILGATE dependencies:
HTML::TreeBuilder …found
HTML::FormatText …found
Getopt::Long …found
LWP::UserAgent …found
CLI dependencies:
Getopt::Long 2.24…found
CORE dependencies:
Digest::MD5 …found
DBI 1.18…found
Test::Inline …found
Class::ReturnValue 0.40…found
DBIx::SearchBuilder 0.86…found
Text::Template …found
File::Spec 0.8…found
HTML::Entities …found
Net::Domain …found
Log::Dispatch 2.0…found
Locale::Maketext 1.04…found
Locale::Maketext::Lexicon 0.25…found
Locale::Maketext::Fuzzy …found
MIME::Entity 5.108…found
Mail::Mailer 1.57…found
Net::SMTP …found
Text::Wrapper …found
Time::ParseDate …found
File::Temp …found
Term::ReadKey …found
Text::Autoformat …found
Text::Quoted …found
DEV dependencies:
Regexp::Common …found
Time::HiRes …found
Test::Inline …found
WWW::Mechanize …found
MYSQL dependencies:
DBD::mysql 2.1018…found

Could someone point me to the right direction?

Thanks so much
-Kittiwat

2

Kittiwat Manosuthi wrote:

But the problem occurred when running dumpfile-to-rt-3.0.

There have been a couple of problems with the 1.13 upgrade
tools and RT 3.0.4, which have come to light in the last
few days. Stay tuned for v.1.14 of the upgrade tools, which
should be out any day now.

3

Kittiwat Manosuthi wrote:

But the problem occurred when running dumpfile-to-rt-3.0.

There have been a couple of problems with the 1.13 upgrade
tools and RT 3.0.4, which have come to light in the last
few days. Stay tuned for v.1.14 of the upgrade tools, which
should be out any day now.

Grabbed the new upgrade tool (1.16), run it, and same problem.
Anyone could advise, or point me to the right direction?

Thanks a lot
-Kittiwat

[…user creation finished…]
Importing groups
ggrrrrrrrrrrrrrrrrrrrrq[Thu Jul 24 03:16:25 2003] [warning]: Failed to
create queue for$VAR1 = {
‘LastUpdatedBy’ => ‘866’,
‘CommentAddress’ => ‘rt-comment@localhost’,
‘Disabled’ => ‘1’,
‘CorrespondAddress’ => ‘rt@localhost’,
‘Created’ => ‘2002-08-19 10:36:04’,
‘Name’ => ‘general’,
‘LastUpdated’ => ‘2002-10-30 07:54:48’,
‘Description’ => ‘The default queue’,
‘Creator’ => ‘1’
};
(/usr/local/rt3/lib/RT.pm:235)
q[Thu Jul 24 03:16:25 2003] [warning]: Failed to create queue for$VAR1 = {
‘CorrespondAddress’ => ‘billing@@???.com’,
‘Creator’ => ‘866’,
‘DefaultDueIn’ => ‘2’,
‘CommentAddress’ => ‘billing-comment@@???.com’,
‘InitialPriority’ => ‘10’,
‘LastUpdatedBy’ => ‘866’,
‘Created’ => ‘2002-10-30 05:48:03’,
‘Name’ => ‘???_billing’,
‘LastUpdated’ => ‘2002-10-30 05:48:03’,
‘Description’ => ‘??? - Billing’
};
(/usr/local/rt3/lib/RT.pm:235)
[Thu Jul 24 03:16:25 2003] [warning]: DBD::mysql::st execute failed: Column
‘ObjectId’ cannot be null at
/usr/local/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 410.
(/usr/local/rt3/lib/RT.pm:235)
[Thu Jul 24 03:16:25 2003] [warning]: RT::Handle=HASH(0x8af8784) couldn’t
execute the query ‘INSERT INTO ACL (PrincipalId, DelegatedFrom, RightName,
ObjectId, PrincipalType, DelegatedBy, ObjectType) VALUES (?, ?, ?, ?, ?, ?,
?)’ at /usr/local/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm
line 417.
(/usr/local/rt3/lib/RT.pm:235)
[Thu Jul 24 03:16:25 2003] [warning]: DBD::mysql::st execute failed: Column
‘ObjectId’ cannot be null at
/usr/local/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 410.
(/usr/local/rt3/lib/RT.pm:235)
[Thu Jul 24 03:16:25 2003] [warning]: RT::Handle=HASH(0x8af8784) couldn’t
execute the query ‘INSERT INTO ACL (PrincipalId, DelegatedFrom, RightName,
ObjectId, PrincipalType, DelegatedBy, ObjectType) VALUES (?, ?, ?, ?, ?, ?,
?)’ at /usr/local/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm
line 417.
(/usr/local/rt3/lib/RT.pm:235)

4

Kittiwat Manosuthi wrote:

But the problem occurred when running dumpfile-to-rt-3.0.

There have been a couple of problems with the 1.13 upgrade
tools and RT 3.0.4, which have come to light in the last
few days. Stay tuned for v.1.14 of the upgrade tools, which
should be out any day now.

Grabbed the new upgrade tool (1.16), run it, and same problem.
Anyone could advise, or point me to the right direction?

You did a full fresh export with the 1.16 tool before doing the import?
Are there errors listed in your syslog or mysql log for the initial
import? It sounds like you’ve got data corruption somewhere.

Thanks a lot
-Kittiwat

[…user creation finished…]
Importing groups
ggrrrrrrrrrrrrrrrrrrrrq[Thu Jul 24 03:16:25 2003] [warning]: Failed to
create queue for$VAR1 = {
‘LastUpdatedBy’ => ‘866’,
‘CommentAddress’ => ‘rt-comment@localhost’,
‘Disabled’ => ‘1’,
‘CorrespondAddress’ => ‘rt@localhost’,
‘Created’ => ‘2002-08-19 10:36:04’,
‘Name’ => ‘general’,
‘LastUpdated’ => ‘2002-10-30 07:54:48’,
‘Description’ => ‘The default queue’,
‘Creator’ => ‘1’
};
(/usr/local/rt3/lib/RT.pm:235)
q[Thu Jul 24 03:16:25 2003] [warning]: Failed to create queue for$VAR1 = {
‘CorrespondAddress’ => ‘billing@@???.com’,
‘Creator’ => ‘866’,
‘DefaultDueIn’ => ‘2’,
‘CommentAddress’ => ‘billing-comment@@???.com’,
‘InitialPriority’ => ‘10’,
‘LastUpdatedBy’ => ‘866’,
‘Created’ => ‘2002-10-30 05:48:03’,
‘Name’ => ‘???_billing’,
‘LastUpdated’ => ‘2002-10-30 05:48:03’,
‘Description’ => ‘??? - Billing’
};
(/usr/local/rt3/lib/RT.pm:235)
[Thu Jul 24 03:16:25 2003] [warning]: DBD::mysql::st execute failed: Column
‘ObjectId’ cannot be null at
/usr/local/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 410.
(/usr/local/rt3/lib/RT.pm:235)
[Thu Jul 24 03:16:25 2003] [warning]: RT::Handle=HASH(0x8af8784) couldn’t
execute the query ‘INSERT INTO ACL (PrincipalId, DelegatedFrom, RightName,
ObjectId, PrincipalType, DelegatedBy, ObjectType) VALUES (?, ?, ?, ?, ?, ?,
?)’ at /usr/local/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm
line 417.
(/usr/local/rt3/lib/RT.pm:235)
[Thu Jul 24 03:16:25 2003] [warning]: DBD::mysql::st execute failed: Column
‘ObjectId’ cannot be null at
/usr/local/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 410.
(/usr/local/rt3/lib/RT.pm:235)
[Thu Jul 24 03:16:25 2003] [warning]: RT::Handle=HASH(0x8af8784) couldn’t
execute the query ‘INSERT INTO ACL (PrincipalId, DelegatedFrom, RightName,
ObjectId, PrincipalType, DelegatedBy, ObjectType) VALUES (?, ?, ?, ?, ?, ?,
?)’ at /usr/local/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm
line 417.
(/usr/local/rt3/lib/RT.pm:235)

rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

Request Tracker... So much more than a help desk — Best Practical Solutions – Trouble Ticketing. Free.

5

Kittiwat Manosuthi wrote:

Grabbed the new upgrade tool (1.16), run it, and same problem.
Anyone could advise, or point me to the right direction?

You did a full fresh export with the 1.16 tool before doing the import?
Are there errors listed in your syslog or mysql log for the initial
import? It sounds like you’ve got data corruption somewhere.

Bingo! Did full fresh export, and it’s done.

Thanks Jesse.
-Kittiwat