[rt-users] SOLVED: RE: Error when upgrading database from 3.8.9 to 3.9.1

[CB]

> On 11/05/2012 09:24 AM, CB wrote:
> > We're long time RT users and are in the process of upgrading from
> > 3.6.3 to
> > 4.0.8 and are following the instructions on
> > http://www.bestpractical.com/rt/docs/4.0/UPGRADING.mysql.html and
> > http://www.bestpractical.com/rt/docs/4.0/README.html. I upgraded to
> > 3.7.87, ran the extra queries and continued the upgrade however it
> > failed at the step of upgrading to 3.9.1.
> 
> Be sure to read the other UPGRADING documentation as well, for all
> versions between 3.6.3 and 4.0.8.
> 
> Your database contains rows in the ACL table which point to Principals
> that no longer exist.  Grep for the [error] lines "ACE NNNN couldn't
> load it's principal object".  This indicates that records were manually
> deleted from the database at some point, and done so incorrectly (as is
> almost always the case with manual deletes by folks not understanding
> the whole of the database).
> 
Turns out the data extract was incomplete.

Thanks for the help.