Rt2-to-rt3 v1.15 import fails with errors

RT Users
1

syslog is spewing errors as I try to import my 15k tickets. Running with
v1.15.

I suspect I’ll end up with way less than 15k tickets.

Redhat 8, perl 5.8 (vendor supplied), mysql 4.0.14

A sample,

Jul 22 16:21:58 help2 RT: Use of uninitialized value in subtraction (-) at
/usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Record/Cachable.pm line
96. (/opt/rt3/lib/RT.pm:235)
Jul 22 16:21:59 help2 RT: Use of uninitialized value in subtraction (-) at
/usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Record/Cachable.pm line
96. (/opt/rt3/lib/RT.pm:235)

Jul 23 12:27:42 help2 RT: DBD::mysql::st execute failed: Column ‘Parent’
cannot be null at
/usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 410.
(/opt/rt3/lib/RT.pm:235)
Jul 23 12:27:42 help2 RT: RT::Handle=HASH(0x8d96de8) couldn’t execute the
query ‘INSERT INTO Attachments (ContentType, Parent, Subject, Headers,
Creator, Created, Content, ContentEncoding, TransactionId) VALUES (?, ?, ?,
?, ?, ?, ?, ?, ?)’ at
/usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 417.
(/opt/rt3/lib/RT.pm:235)

Jul 23 12:27:42 help2 RT: Couldn’t create attachment HASH(0x8d766e8) $VAR1 =
{ ‘Subject’ => ‘Test Ticket One’, ‘ContentType’ =>
‘text/plain’, ‘Created’ => ‘2002-02-09 03:50:29’,
‘Headers’ => 'Return-Path: matthew@velvet.org Delivered-To:
rt@boris.intelenet.net Received: from sumamail.com (ono.sumamail.com
[216.231.30.5]) ^Iby boris.intelenet.net (Postfix) with ESMTP id 193E4243E1
^Ifor rt@boris.intelenet.net; Fri, 8 Feb 2002 21:50:28 -0600 (CST)
Received: from [68.5.32.175] (HELO Desktop) by sumamail.com (CommuniGate
Pro SMTP 3.4.7) with ESMTP-TLS id 1123509 for rt@boris.intelenet.net; Fri,
08 Feb 2002 19:50:27 -0800 Message-Id:
00a701c1b11c$e9703490$0b16160a@Desktop From: “matthew zeier”
matthew@velvet.org To: rt@intelenet.net Subject: Test Ticket One Date:
Fri, 8 Feb 2002 19:50:26 -0800 MIME-Version: 1.0 Content-Type: text/plain;
^Icharset=“iso-8859-1” Content-Transfer-Encoding: 7bit X-Priority: 3
X-Msmail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.000

matthew zeier | “Nothing in life is to be feared.
InteleNet Communications, Inc. | It is only to be understood.”
(949) 784-7904 | - Marie Curie

2

syslog is spewing errors as I try to import my 15k tickets. Running with
v1.15.

Abort it. The “Parent” errors speak to something going wrong with the
new code in 1.15. A next rev of that code is somewhere on my today list.

Jul 23 12:27:42 help2 RT: DBD::mysql::st execute failed: Column ‘Parent’
cannot be null at
/usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 410.
(/opt/rt3/lib/RT.pm:235)
Jul 23 12:27:42 help2 RT: RT::Handle=HASH(0x8d96de8) couldn’t execute the
query ‘INSERT INTO Attachments (ContentType, Parent, Subject, Headers,
Creator, Created, Content, ContentEncoding, TransactionId) VALUES (?, ?, ?,
?, ?, ?, ?, ?, ?)’ at

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

3

Jesse,

I need to upgrade my production instance of RT from 2.x before Friday when
the old instance and the hardware and data center where it currently rests
is shuttered. It sounds like 1.15 of the importer needs to be avoided.
Will 1.16, or a release candidate for it, be ready by then? If not, would
you recommend I install 3.0.3, use 1.13 of the importer, then upgrade to
3.0.4?

Thanks,
Christian

Christian Gilmore
Technology Leader
GeT Support Application Development
IBM Software Group

Jesse Vincent jesse@bestpractical.com
Sent by: rt-users-admin@lists.fsck.com
07/23/03 02:53 PMTo: matthew zeier mrz@intelenet.net
cc: rt-users@lists.fsck.com
Subject: Re: [rt-users] rt2-to-rt3 v1.15 import fails with errors

syslog is spewing errors as I try to import my 15k tickets. Running
with
v1.15.

Abort it. The “Parent” errors speak to something going wrong with the
new code in 1.15. A next rev of that code is somewhere on my today list.

Jul 23 12:27:42 help2 RT: DBD::mysql::st execute failed: Column ‘Parent’
cannot be null at
/usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 410.
(/opt/rt3/lib/RT.pm:235)
Jul 23 12:27:42 help2 RT: RT::Handle=HASH(0x8d96de8) couldn’t execute
the
query ‘INSERT INTO Attachments (ContentType, Parent, Subject, Headers,
Creator, Created, Content, ContentEncoding, TransactionId) VALUES (?, ?,
?,
?, ?, ?, ?, ?, ?)’ at

Request Tracker... So much more than a help desk — Best Practical Solutions – Trouble Ticketing. Free.
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

4

Jesse,

I need to upgrade my production instance of RT from 2.x before Friday when
the old instance and the hardware and data center where it currently rests
is shuttered. It sounds like 1.15 of the importer needs to be avoided.
Will 1.16, or a release candidate for it, be ready by then? If not, would
you recommend I install 3.0.3, use 1.13 of the importer, then upgrade to
3.0.4?

Nothing in 3.0.4 breaks the old importer.

Known issues:

RT 3.0.0-3.0.4: on import, priority will not be set.
(The version of RT in aegis fixes this)

Importer 1.0-1.13:

If ticket watchers don't have email addresses, they won't be
imported. This was fixed in 1.15.

If tickets have attachments other than singlepart email messages,
those attachments might be attached to the wrong transactions.
This was fixed _for me_ in 1.15. Clearly it didn't work for
Matt. I suspect it's something on the order of a typo.

Thanks,
Christian

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