[rt-users] RE: dumpfile-to-rt-3.0 choking on attachment

[Robert Joost]

Dave Dennis wrote:

>Was upgrading to latest perl / RT what is needed to solve migration issues with
>migrate script failing?
>
Unfortunately, no. I ran cvsup on my FreeBSD 4.9 stable box, then did a 
portupgrade of perl to perl 5.8.4 and all the depedencies..then used the 
rt test script and all dependencies checked out fine..

then reran dumpfile-to-rt-3.0 and still the same behavior:
all users, queues, etc, are properly imported BUT the tickets are not..

i guess not many people have this problem, from the looks of the list 
because this isn't the kind of problem that would not be worked on if it 
were widespread on an open source project,
so my only assumption is that i have to look at the diffs.
the only diff i see is that i am running perl 5.8.4 and 5.8.3 was called 
for...strange
over time, i'll go over the table structural changes from one rt version 
to the next, then start combing the code, but i'm also am hoping that
this is indeed a wider spread problem and that some decent ideas will be 
coming our way.

this is particularly strange because there were no customizations/direct 
sql manipulations of the data at any point, so the tool doesn't work in 
some way.

....just  a few errors are listed here:

qFailed to create queue for$VAR1 = {
          'Creator' => '176',
          'LastUpdatedBy' => '192',
          'Disabled' => '1',
          'Created' => '2003-03-24 20:50:09+00',
          'Name' => 'wcs-bct-bug',
          'LastUpdated' => '2004-01-09 20:36:09+00'
        };
qFailed to create queue for$VAR1 = {
          'Creator' => '176',
          'LastUpdatedBy' => '192',
          'Disabled' => '1',
          'Created' => '2003-03-24 20:50:32+00',
          'Name' => 'wcs-bct-develop',
          'LastUpdated' => '2004-01-09 20:36:15+00'
        };

mporting tickets...t-17
[Fri Jun 18 20:04:05 2004] [crit]: Couldn't create a ticket 
(/usr/local/rt3/lib/RT/Ticket_Overlay.pm:513)
Couldn't create ticket HASH(0x8f78f04) $VAR1 = {
          'Status' => 'open',
          'Queue' => 'lcms-develop',
          'Started' => '2002-10-28 17:34:36+00',
          'Starts' => '1970-01-01 00:00:00+00',
          '_RecordTransaction' => '0',
          'id' => 17,
          'LastUpdated' => '2003-12-23 23:41:33+00',
          'Requestor' => [
                           'Peter Lenton'
                         ],
          'Cc' => [
                    'StudioDev at knowledgenet.com'
                  ],
          'Subject' => 'Drag and drop within a project to be cut/paste',
          'Creator' => '192',
          'Owner' => '50',
          'EffectiveId' => '17',
          'LastUpdatedBy' => '192',
          'Created' => '2002-10-23 23:29:50+00',
          'Priority' => '5000',
          'Due' => '1970-01-01 00:00:00+00'
        };
Couldn't create trans  68
$VAR1 = {
          'Type' => 'Create',
          'Ticket' => '17',
          'Created' => '2002-10-23 23:29:50+00',
          'id' => 68,
          'Creator' => '192',
          'ActivateScrips' => '0'
        };

>
>
>+-------------------------
>+ Dave Dennis
>+ Seattle, WA
>+ dmd at speakeasy.org
>+ http://www.dmdennis.com
>+-------------------------
>
>On Fri, 18 Jun 2004, Robert Joost wrote:
>
>  
>
>>RT is a great Open Source tool; unfortunately, if I can't upgrade
>>without paying thousands of dollars then I can't use it. I'm not asking
>>for help in customizing this tool; however, a decent Open Source tool
>>needs to be upgradable without pulling teeth.
>>I am decent with perl and databases and all the tools used with RT but I
>>don't have the time to dissect this tool and beg for help in terms of
>>doing a simple upgrade.
>>If my company needs to pay thousands of dollars to do things like
>>upgrading, then they'll get Remedy and be done with it.
>>
>>Otherwise, it was a great tool, a plus in Open Source.
>>Thanks,
>>Rob
>>
>>--
>>Rob Joost
>>Unix Administrator
>>
>>KnowledgeNet
>>14624 N. Scottsdale Road, #300
>>Scottsdale, AZ  85254
>>Phone:   (480) 315-4841
>>Cell:    (602) 920-6113
>>Email: rob.joost at knowledgenet.com
>>Web:   <http://www.knowledgenet.com/>
>>
>>Why KnowledgeNet? Listen and learn from top customers -- Cisco, US
>>Postal Service, and EMC, to name a few!
>><http://www.knowledgenet.com/onlineevents/>
>>
>>NOTICE: This communication may contain privileged or other confidential information. If you are not the intended recipient or believe that you may have received this communication in error, please reply to the sender indicating that fact and delete the copy you received. Thank you.
>>
>>
>>_______________________________________________
>>http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>>
>>RT Developer and Administrator training is coming to LA, DC and Frankfurt this spring and summer.
>>http://bestpractical.com/services/training.html
>>
>>Sign up early, as class space is limited.
>>
>>    
>>


-- 
Rob Joost
Unix Administrator

KnowledgeNet
14624 N. Scottsdale Road, #300
Scottsdale, AZ  85254
Phone:   (480) 315-4841
Cell:    (602) 920-6113
Email: rob.joost at knowledgenet.com
Web:   <http://www.knowledgenet.com/>

Why KnowledgeNet? Listen and learn from top customers -- Cisco, US
Postal Service, and EMC, to name a few!
<http://www.knowledgenet.com/onlineevents/>

NOTICE: This communication may contain privileged or other confidential information. If you are not the intended recipient or believe that you may have received this communication in error, please reply to the sender indicating that fact and delete the copy you received. Thank you.