<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal>I am in the mist of moving from RT 3.8.8 to 4.0. I run the update database script and I get the following error:<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>[warning]: DBD::mysql::st execute failed: Duplicate entry '0' for key 'PRIMARY' at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 509, <> line 1. (/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:509)<o:p></o:p></p><p class=MsoNormal>[warning]: RT::Handle=HASH(0xa10e3c0) couldn't execute the query 'INSERT INTO ACL (PrincipalType, PrincipalId, RightName, ObjectType, ObjectId) VALUES (?, ?, ?, ?, ?)' at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 522<o:p></o:p></p><p class=MsoNormal> DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0xa10e3c0)', 'INSERT INTO ACL (PrincipalType, PrincipalId, RightName, Objec...', 'Owner', 6, 'ExecuteCode', 'RT::System', 1) called at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 357<o:p></o:p></p><p class=MsoNormal> DBIx::SearchBuilder::Handle::Insert('RT::Handle=HASH(0xa10e3c0)', 'ACL', 'PrincipalType', 'Owner', 'PrincipalId', 6, 'RightName', 'ExecuteCode', 'ObjectType', ...) called at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle/mysql.pm line 36<o:p></o:p></p><p class=MsoNormal> DBIx::SearchBuilder::Handle::mysql::Insert('RT::Handle=HASH(0xa10e3c0)', 'ACL', 'PrincipalType', 'Owner', 'PrincipalId', 6, 'RightName', 'ExecuteCode', 'ObjectType', ...) called at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Record.pm line 1292<o:p></o:p></p><p class=MsoNormal> DBIx::SearchBuilder::Record::Create('RT::ACE=HASH(0xba17398)', 'PrincipalType', 'Owner', 'PrincipalId', 6, 'RightName', 'ExecuteCode', 'ObjectId', 1, ...) called at /opt/rt4/sbin/../lib/RT/Record.pm line 304<o:p></o:p></p><p class=MsoNormal> RT::Record::Create('RT::ACE=HASH(0xba17398)', 'PrincipalId', 6, 'PrincipalType', 'Owner', 'RightName', 'ExecuteCode', 'ObjectType', 'RT::System', ...) called at /opt/rt4/sbin/../lib/RT/ACE.pm line 291<o:p></o:p></p><p class=MsoNormal> RT::ACE::Create('RT::ACE=HASH(0xba17398)', 'RightName', 'ExecuteCode', 'Object', 'RT::System=HASH(0xa1a35c4)', 'PrincipalType', 'Owner', 'PrincipalId', 6, ...) called at /opt/rt4/sbin/../lib/RT/Principal.pm line 172<o:p></o:p></p><p class=MsoNormal> RT::Principal::GrantRight('RT::Principal=HASH(0xba0a734)', 'Right', 'ExecuteCode', 'Object', 'RT::System=HASH(0xa1a35c4)') called at ./etc/upgrade/3.9.1/content line 56<o:p></o:p></p><p class=MsoNormal> RT::Handle::__ANON__() called at /opt/rt4/sbin/../lib/RT/Handle.pm line 767<o:p></o:p></p><p class=MsoNormal> eval {...} called at /opt/rt4/sbin/../lib/RT/Handle.pm line 767<o:p></o:p></p><p class=MsoNormal> RT::Handle::InsertData('RT::Handle=HASH(0xa10e3c0)', './etc/upgrade/3.9.1/content', 'undef') called at /opt/rt4/sbin/rt-setup-database line 290<o:p></o:p></p><p class=MsoNormal> main::action_insert('datafile', 'undef', 'action', 'upgrade', 'datadir', './etc/upgrade/3.9.1', 'backcompat', 'ARRAY(0x8975f98)', 'dba', ...) called at /opt/rt4/sbin/rt-setup-database line 396<o:p></o:p></p><p class=MsoNormal> main::action_upgrade('action', 'upgrade', 'dba', 'root') called at /opt/rt4/sbin/rt-setup-database line 195 (/usr/lib/perl5/5.8.8/Carp.pm:272)<o:p></o:p></p><p class=MsoNormal>[warn]: Unable to grant ExecuteCode on principal 6: System error. Right not granted. (./etc/upgrade/3.9.1/content:62)<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Any thoughts or ideas would appreciated. Attempting to repair the database with rt-validator returns this error:<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Couldn’t load GM record #0 at ./rt-validator line 433 <o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Thanks in advance<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>===============<o:p></o:p></p><p class=MsoNormal>Alberto Dela Rosa<o:p></o:p></p><p class=MsoNormal>Director of Information Technology<o:p></o:p></p><p class=MsoNormal>School of Pharmacy and Pharmaceutical Sciences<o:p></o:p></p><p class=MsoNormal>351 Hochstetter Hall<o:p></o:p></p><p class=MsoNormal>Buffalo, NY 14260<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Tel: 716-645-2259<o:p></o:p></p><p class=MsoNormal>Fax: 716-645-3688<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p></div></body></html>