H692 is referenced by the view: SH_AR_System_Version_Control__ FWIW, there are no records in this table. Thanks
Brien On Tue, 2010-11-16 at 21:20 -0500, Joe Martin D'Souza wrote: > Just out of curiosity, what form is H692 related to? > > Query your database to find out.. > > select name from arschema where schemaid = 692; > > This error is an indication that the history table had more statuses than > the C7 column of the T table, and when the new statuses were added, the H > table gave a conflict.. > > Joe > > -----Original Message----- > From: Brien Dieterle > Sent: Tuesday, November 16, 2010 8:08 PM Newsgroups: > public.remedy.arsystem.general > To: [email protected] > Subject: 7.6.03 upgrade error FYI > > Was banging my head on an upgrade test from ARS 7.5p7 to 7.6.03. The AR > Service would hang on startup in the middle of the upgrade. I enabled debug > in ar.cfg and looked in the SQL logs and found a commit transaction error > because an ALTER TABLE command failed due to columns already existing. > > The table was H692, and the columns were T5,U5,T10,U10,T20 and U20. I > deleted these columns and then the service could start. I then reinstalled > 7.6.03 and the entire installation completed without error. Hope that helps > someone! > > Brien > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
