[rt-users] Problem running rt2-to-rt3-v1.13

[Jesse Vincent]

On Thu, Jul 24, 2003 at 11:22:44AM +0700, Kittiwat Manosuthi wrote:
> "Phil Homewood" <pdh at snapgear.com> wrote:
> 
> > Kittiwat Manosuthi wrote:
> > > But the problem occurred when running dumpfile-to-rt-3.0.
> >
> > There have been a couple of problems with the 1.13 upgrade
> > tools and RT 3.0.4, which have come to light in the last
> > few days. Stay tuned for v.1.14 of the upgrade tools, which
> > should be out any day now.
> 
> 
> Grabbed the new upgrade tool (1.16), run it, and same problem.
> Anyone could advise, or point me to the right direction?

You did a full fresh export with the 1.16 tool before doing the import?
Are there errors listed in your syslog or mysql log for the initial
import? It _sounds_ like you've got data corruption somewhere.



> 
> Thanks a lot
> -Kittiwat
> 
> 
> [...user creation finished...]
> Importing groups
> ggrrrrrrrrrrrrrrrrrrrrq[Thu Jul 24 03:16:25 2003] [warning]: Failed to
> create queue for$VAR1 = {
>           'LastUpdatedBy' => '866',
>           'CommentAddress' => 'rt-comment at localhost',
>           'Disabled' => '1',
>           'CorrespondAddress' => 'rt at localhost',
>           'Created' => '2002-08-19 10:36:04',
>           'Name' => 'general',
>           'LastUpdated' => '2002-10-30 07:54:48',
>           'Description' => 'The default queue',
>           'Creator' => '1'
>         };
>  (/usr/local/rt3/lib/RT.pm:235)
> q[Thu Jul 24 03:16:25 2003] [warning]: Failed to create queue for$VAR1 = {
>           'CorrespondAddress' => 'billing@@???.com',
>           'Creator' => '866',
>           'DefaultDueIn' => '2',
>           'CommentAddress' => 'billing-comment@@???.com',
>           'InitialPriority' => '10',
>           'LastUpdatedBy' => '866',
>           'Created' => '2002-10-30 05:48:03',
>           'Name' => '???_billing',
>           'LastUpdated' => '2002-10-30 05:48:03',
>           'Description' => '??? - Billing'
>         };
>  (/usr/local/rt3/lib/RT.pm:235)
> [Thu Jul 24 03:16:25 2003] [warning]: DBD::mysql::st execute failed: Column
> 'ObjectId' cannot be null at
> /usr/local/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 410.
>  (/usr/local/rt3/lib/RT.pm:235)
> [Thu Jul 24 03:16:25 2003] [warning]: RT::Handle=HASH(0x8af8784) couldn't
> execute the query 'INSERT INTO ACL (PrincipalId, DelegatedFrom, RightName,
> ObjectId, PrincipalType, DelegatedBy, ObjectType) VALUES (?, ?, ?, ?, ?, ?,
> ?)' at /usr/local/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm
> line 417.
>  (/usr/local/rt3/lib/RT.pm:235)
> [Thu Jul 24 03:16:25 2003] [warning]: DBD::mysql::st execute failed: Column
> 'ObjectId' cannot be null at
> /usr/local/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 410.
>  (/usr/local/rt3/lib/RT.pm:235)
> [Thu Jul 24 03:16:25 2003] [warning]: RT::Handle=HASH(0x8af8784) couldn't
> execute the query 'INSERT INTO ACL (PrincipalId, DelegatedFrom, RightName,
> ObjectId, PrincipalType, DelegatedBy, ObjectType) VALUES (?, ?, ?, ?, ?, ?,
> ?)' at /usr/local/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm
> line 417.
>  (/usr/local/rt3/lib/RT.pm:235)
> 
> _______________________________________________
> 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
> 

-- 
http://www.bestpractical.com/rt  -- Trouble Ticketing. Free.