Problems upgrading RT2 to RT3

RT Users
1

I’m trying to upgrade a RT 2.0.14 db to RT 3.2.2. Am using the rt2-to-rt3-1.23 scripts. The rt-2.0-to-dumpfile appeared to run ok, although the metadata looks like it’s incomplete… here’s what it has for all of the users:

      'User' => [
                  {
                    'id' => '64820'
                  },
                  {
                    'id' => '152146'
                  },
                  {
                    'id' => '156670'
                  },

…etc. No names or email addresses or any other info.

When I try to run the dumpfile-to-rt-3.0 script, though, it fails with this err:

.[Thu Jul 6 20:41:37 2006] [error]: Could not create a new user - (/opt/myrt3/lib/RT/User_Overlay.pm:260)
Failed to create user for$VAR1 = {
‘CryptedPassword’ => undef,
‘Name’ => ‘Unnamed user 46183’
};

Same error repeated thousands of times (one for every userid, I presume; I killed it after a few dozen screenfuls.)

Any advice on how to get this to work? I don’t suppose I can just copy the database info over directly from the rt2 db to rt3, can I?

Thanks,

– Jackie Hamilton
kira@lightsphere.com

2

Hi Jackie,

I’ve had the same problems.
Downgrading to DBIx-SearchBuilder-1.01 solved the problem for me.
After the migration you can upgrade again to newest version.

jodokOn Thu, 6 Jul 2006 16:11:56 -0500 Jackie Hamilton kira@lightsphere.com wrote:

I’m trying to upgrade a RT 2.0.14 db to RT 3.2.2. Am using the rt2-to-rt3-1.23 scripts. The rt-2.0-to-dumpfile appeared to run ok, although the metadata looks like it’s incomplete… here’s what it has fo

Jodok Ole Muellers | Verizon Business
Internet Software System Engineer | Sebrathweg 20
EMEA Server & Service Management | D-44149 Dortmund, Germany
phone: +49 (0)231 972 1432 | vnet : 317 1432
mail : jolemuel@eu.uu.net | fax : +49 231 972 2587
pgp : gpg --keyserver blackhole.pca.dfn.de --recv-keys 5A2A106E

3

I’ve had the same problems.
Downgrading to DBIx-SearchBuilder-1.01 solved the problem for me.
After the migration you can upgrade again to newest version.

Thanks for the tip. Out of curiousity, how long did the rt2-to-dumpfile take for you?

I’ve installed the 1.01 version of DBIx::SearchBuilder, and ran the script. or rather, started it… at around midnight last night. 11 hours later it wrote a 97 meg, 1.87-million line metadata file (which looks incomplete, actually). However it’s not begun writing out tickets yet (and it’s now 8pm).

Just wondering how many days this might take… :slight_smile:

– Jackie Hamilton
kira@lightsphere.com