[rt-users] More rt2 -> rt3 conversion woes.

[Stegen Smith]

Hi Brian,

Thanks for the advice.  I went ahead and trimmed the Users table quite a bit,
and re ran the export.  It ran successfully, so I copied the export to the
new rt system and restarted the import.  I've done a dumpdb and 
initialize-database to have a fresh start on rt3.  Here's what went down.

<rerun>
rt2# ./dumpfile-to-rt-3.0 test
Importing users
... email addresses
.uCreating user stegen
... after email addresses
.
Importing groups
ggrrrr[Fri Mar 24 00:16:14 2006] [crit]: 1 (/usr/local/rt/lib/RT/ACE_Overlay.pm:906)
[Fri Mar 24 00:16:14 2006] [crit]: Can't load a principal for id  (/usr/local/rt/lib/RT/ACE_Overlay.pm:907)
rr[Fri Mar 24 00:16:14 2006] [crit]: 1 (/usr/local/rt/lib/RT/ACE_Overlay.pm:906)
[Fri Mar 24 00:16:14 2006] [crit]: Can't load a principal for id  (/usr/local/rt/lib/RT/ACE_Overlay.pm:907)
rrrrrrr[Fri Mar 24 00:16:14 2006] [crit]: 1 (/usr/local/rt/lib/RT/ACE_Overlay.pm:906)
[Fri Mar 24 00:16:14 2006] [crit]: Can't load a principal for id  (/usr/local/rt/lib/RT/ACE_Overlay.pm:907)
rr[Fri Mar 24 00:16:14 2006] [crit]: 1 (/usr/local/rt/lib/RT/ACE_Overlay.pm:906)
[Fri Mar 24 00:16:14 2006] [crit]: Can't load a principal for id  (/usr/local/rt/lib/RT/ACE_Overlay.pm:907)
rrrrrrr[Fri Mar 24 00:16:14 2006] [crit]: 1 (/usr/local/rt/lib/RT/ACE_Overlay.pm:906)
..... 
</rerun>

This didn't look good to me; however, I let the import finish, and decided
to check out one of the tickets.  The login, worked, the queues were there,
and tickets existed with subjects in the main home screen.  When I click on one
of the ticket links, I would see the following error

<error>

error:   	RT::Queue::TicketCustomFields Unimplemented in HTML::Mason::Commands. (/usr/local/rt/local/html/Ticket/Elements/ShowSummary line 56)
context:  	
...  	
492:  	else {
493:  	my ( $package, $filename, $line );
494:  	( $package, $filename, $line ) = caller;
495:  	
496:  	die "$AUTOLOAD Unimplemented in $package. ($filename line $line) \n";
497:  	}
498:  	
499:  	}
500:  	
...  	
code stack:  	/usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Record.pm:496
/usr/local/rt/local/html/Ticket/Elements/ShowSummary:56
/usr/local/rt/local/html/Ticket/Display.html:57
/usr/local/rt/share/html/autohandler:215
raw error
</error>

I was skeptical to even see what I saw after seeing so many errors, but it's 
a drag that the ticket content wasn't there.  Have you ever seen this error
before?  It's stumping me...

Thanks for the help!
stegen

Brian Kerr [kerrboy at gmail.com] wrote:
> On 3/22/06, Stegen Smith <stegen.smith at websidestory.com> wrote:
> > Hello All,
> >
> > So I've got another mucked up rt2 -> rt3 conversion issue.  I've searched
> > and read what I believe would be all the posts in regards to this, and
> > I've tried some of the things that they've told.
> >
> > Here's the tale.  We've got an rt instance with almost 200k users, and a
> > little over 300k tickets.  I've got some new hardware to put the latest
> > version of rt on.  So i've got the new system setup and ready to go for rt3.
> > No biggy.
> ...
> 
> Brutal, I went through this with a 800,000 ticket system - your pain
> is heartfelt!
> 
> > I downgraded the DBIx::SearchBuilder down to 0.61, and started an export.
> > It just churned, churned, and chuned some more before the perl process
> > took all memory and exited out.  Quirky, I thought.  I figured that this
> > must have to do with the amount of users that we have, since that's the
> > first stage of the export process.   I re-upgraded to 1.39 and ran an
> > export, to at least get the user data out.  I then massaged that data
> > with another script to populate the rest of the missing fields from the
> > database.
> 
> You need to prune the Users table - I suspect your system received a
> large number of spam emails at one point, or it truly has a large
> number of distinct Users.
> 
> At any rate, check this post:
> 
> http://lists.bestpractical.com/pipermail/rt-users/2004-September/025971.html
> 
> I basically pruned off all users older than 3 months in order to get
> the import to work.  It was smooth sailing after that point.
> 
> Hope this helps!
>