[rt-users] error running rt2-to-rt3 upgrade

[Jay Christopherson]

Can anyone tell me why some of the dumpfile script's attempts to import some 
ticket transactions is failing?  I put the pertinent information below.  If 
I should provide something else, please let me know.

I just attempted to upgrade from RT2 to RT3, following the README.  When 
running:

./dumpfile-to-rt3 rt2dump

It would error out at this line of the dumpfile script in import_tickets (I 
added the DEBUG stuff so that it would keep going):


unless ( $trans_obj->Id == $t->{'id'} ) {
        open DEBUG, ">>/tmp/rt3-foo";
        print DEBUG "Couldn't create trans  " . $t->{'id'} . "\n" . 
Dumper($t);
        close DEBUG;
        #exit;
}

This error occurred on 1,478 tickets out of a total of 23,498.  Basically, 
the end result was that the ticket was imported, but missing some history.

When I looked at a particular errored transaction, I could not find a reason 
why it would have caused a problem:
Couldn't create trans  140427
$VAR1 = {
          'OldValue' => '10',
          'Type' => 'Give',
          'Field' => 'Owner',
          'Ticket' => '20718',
          'Created' => '2004-12-31 00:04:28',
          'id' => 140427,
          'NewValue' => '1698',
          'Creator' => '1698',
          'ActivateScrips' => '0'
        };

RT2 Database Entry:
mysql> select * from Transactions where Ticket='20718';
+--------+-----------------+--------+-----------+--------+--------+----------+----------+------+---------+---------------------+
| id     | EffectiveTicket | Ticket | TimeTaken | Type   | Field  | OldValue 
| NewValue | Data | Creator | Created             |
+--------+-----------------+--------+-----------+--------+--------+----------+----------+------+---------+---------------------+
| 130616 |            NULL |  20718 |         0 | Create | NULL   | NULL     
| NULL     | NULL |       5 | 2004-10-29 03:04:29 |
| 140426 |            NULL |  20718 |         0 | Status | Status | new      
| resolved | NULL |       5 | 2004-12-31 00:04:28 |
| 140427 |            NULL |  20718 |         0 | Give   | Owner  | 2        
| 5        | NULL |       5 | 2004-12-31 00:04:28 |
+--------+-----------------+--------+-----------+--------+--------+----------+----------+------+---------+---------------------+
3 rows in set (0.00 sec)


RT3 Imported Version of the ticket:
mysql> select * from Transactions where ObjectId='20718' AND 
ObjectType='RT::Ticket';
+--------+------------+----------+-----------+--------+-------+----------+----------+---------------+--------------+--------------+------+---------+---------------------+
| id     | ObjectType | ObjectId | TimeTaken | Type   | Field | OldValue | 
NewValue | ReferenceType | OldReference | NewReference | Data | Creator | 
Created             |
+--------+------------+----------+-----------+--------+-------+----------+----------+---------------+--------------+--------------+------+---------+---------------------+
| 130616 | RT::Ticket |    20718 |         0 | Create | NULL  | NULL     | 
NULL     | NULL          |         NULL |         NULL |      |    1698 | 
2004-10-29 03:04:29 |
+--------+------------+----------+-----------+--------+-------+----------+----------+---------------+--------------+--------------+------+---------+---------------------+
1 row in set (0.00 sec)