[rt-devel] rt2 to rt3 db conversion problems

[justin m. clayton]

I got strange output during dump->rt3 conversion, and now it appears that
ticket content has been mixed up a bit (the ticket display page has the
correct body, but hitting "reply" indent-includes the wrong body from a
different ticket entirely). Here's the output of the conversion script:

Importing users
............................................................................................................................................................................................................................
Importing groups
[Tue May 13 22:42:31 2003] [crit]: 1
(/usr/local/pkgs/rt3/lib/RT/ACE_Overlay.pm:884)
[Tue May 13 22:42:31 2003] [crit]: Can't load a principal for id
(/usr/local/pkgs/rt3/lib/RT/ACE_Overlay.pm:885)
[Tue May 13 22:42:31 2003] [crit]: 1
(/usr/local/pkgs/rt3/lib/RT/ACE_Overlay.pm:884)
[Tue May 13 22:42:31 2003] [crit]: Can't load a principal for id
(/usr/local/pkgs/rt3/lib/RT/ACE_Overlay.pm:885)
# Repeat last 2 lines 54 times each #
Importing tickets...t-1
.t-2
.t-3
.t-4
.t-5
.t-6
# skip a bit, please
.t-1192
.t-1193
.t-1194
Importing links
Could not create scrip: On Status Notify AdminCcs with templateStatus Change inqueue0
Could not create scrip: On Create Autoreply To Requestors with templateV LS I  Autoreply in queue0
Could not create scrip: On Resolve Notify Requestors with templateV LS I Resolved in queue0

Those templates should be "VLSI Resolved", and so forth. It looks like
other things that didn't get imported properly include Keywords/Custom
Fields and Templates (and perhaps other things; I haven't taken a tour
yet).

Any help would be appreciated. Thanks,

Justin Clayton
VLSI Research System Administrator
University of Washington
Electrical Engineering Dept
justincl at u.washington.edu
206/543.2523  EE/CSE 307E