[rt-users] Re: [rt-devel] rt2 to rt3 db conversion problems

[justin m. clayton]

So, now I'm not getting the [crit] errors, but the condition is still
there. It's also worth noting that I've been creating new tickets through
the webui since the import, and they don't seem to have this problem,
further pointing to the dumpfile-rt3 script as the source of this issue.

--Justin Clayton
justincl at u.washington.edu

On Tue, 20 May 2003, justin m. clayton wrote:

> I haven't gotten a response regarding my conversion problems in a week's
> time, and I'm just wondering if it's something simple that is so obvious
> to everyone else that it isn't worth a response... :-)
>
> Here's some more info that may help:
>
> * Red Hat 7.3
> * mysql-3.23.54a-3.73 rpm
> * Ticket 1069, when reply or comment is clicked in the webui, appears to
> have the content of ticket 1078. This happens all over the place, though
> sometimes the text is "This ticket appears to have no content" on reply.
> * The exported text forms of the tickets appear to be correct.
> * I've tried re-importing, with the same result.
>
> I've noticed that the [crit] error with ACE_Overlay.pm seems to be a
> common issue with others on the list. Any help would be appreciated.
>
> --Justin Clayton
> justincl at u.washington.edu
>
> On Tue, 13 May 2003, justin m. clayton wrote:
>
> > 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
>
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users
>
> Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm
>

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