The biggest time eater we found going from 6.3 to 7.1 was that the script altered three fields in every table that had the 8 core fields. The problem was it didn't do one alter for three fields, it did three alters, one for each field. Big tables took a long time. Fortunately we were doing a database upgrade at the same time and built the new database in a second instance and altered the schema script to create the tables with the longer core fields. Then we moved the data. Turned a 12 hour DB upgrade into 6. Do they test these install scripts in a life-like environment?
On the up side, the 7.1 upgrade was the first time I didn't have to edit the install script. On Fri, Jan 8, 2010 at 10:09 AM, Jarl Grøneng <[email protected]>wrote: > That is not an option, the database is appox 80Gb and it woud take > ages to move the records... But, it goes forward, in small steps. > > But found it very timeconsuming doing the install over and over again. > It takes several hours each time the database has to be rolledback... > > -- > Jarl > > > > 2010/1/8 LJ Longwing <[email protected]>: > > I think the discussion is not 'upgrading' the server....but instead, > build a > > new server at 7.5 and then import a def of this application...which I > think > > will work... > > > > -----Original Message----- > > From: Action Request System discussion list(ARSList) > > [mailto:[email protected]] On Behalf Of Brittain, Mark > > Sent: Friday, January 08, 2010 9:41 AM > > To: [email protected] > > Subject: Re: Upgrade to 7.5, is it possible without any errors? > > > > Jarl, > > > > This was discussed on the list before but I can't find the emails. I > believe > > there is a white paper out that states you have to upgrade those server > to > > 6.3 before you can go to 7.5. can't go straight from 2.1, 3.2, 4.51 to > 7.5 > > > > Fellow Listers, if I am wrong or you have the link to the white paper, > > please jump in. > > > > Thanks > > Mark > > > > -----Original Message----- > > From: Action Request System discussion list(ARSList) > > [mailto:[email protected]] On Behalf Of Jarl Grøneng > > Sent: Friday, January 08, 2010 10:20 AM > > To: [email protected] > > Subject: Re: Upgrade to 7.5, is it possible without any errors? > > > > 7.01 is 7.0.1 > > > > But my issues when upgrading to 7.5 (patch 3) > > > > One of the server startet out as 2.1, the others as 3.2 and 4.51... > > > > -- > > Jarl > > > > > > 2010/1/8 Grooms, Frederick W <[email protected]>: > >> For 7.01 Are you talking about 7.0.1 or 7.1.0? > >> > >> We did the upgrade from 6.3.0 (patch 20) to 7.1.0 (patch 3) with no > >> errors on Sun 5.10 with Oracle 10g. This was on servers that started > >> out as 5.1.2 > >> > >> Fred > >> > >> -----Original Message----- > >> From: Action Request System discussion list(ARSList) > >> [mailto:[email protected]] On Behalf Of Jarl Grøneng > >> Sent: Friday, January 08, 2010 12:18 AM > >> To: [email protected] > >> Subject: Upgrade to 7.5, is it possible without any errors? > >> > >> Hi, > >> > >> I've done a few upgrades from 6.3 and 7.01 to 7.5. And none of them > >> installes without any errors.... > >> > >> - bin/arsystem (Unix startup file) contains errors, upgrade failes > >> when the installer restart the server > >> - armonitor.conf/armonitor.cfg does not get created > >> - database upgrade in 3 tablss failes due to illegal operation > >> (Oracle) > >> - addinng unique index on form AR System User Cental File failes > >> - serveradmin form does not contain any information > >> - Approval/Assignment-engine failes to install if the server does not > >> run when starting the installation-program > >> - Upgrade fails if you do not have a admin user named Demo > >> - tnsnames.ora need to have an SID entry containing the ip-adress, > >> with domain name is failes. > >> > >> All the upgrades has been done against servers installed prior to > >> version 6.3. Upgrading servers which where original installed as 6.3 > >> or 7.01 does not fail. > >> > >> > >> Opening a ticket with support did not give any value to the issues. > >> After 5-6 weeks, we fixed most of the issues (need to do a lot manual > >> work during the installation), and the response from support was; "Can > >> I close the ticket now?" They was not not intressting in how the > >> issues was solved. This answer ended up in my worst satisfaction > >> survey ever! > >> > >> Looking forward to the CMDB upgrade.... > >> > >> Regards, > >> Jarl > >> > >> ______________________________________________________________________ > >> _________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > >> Platinum > >> Sponsor:[email protected]<sponsor%[email protected]>ARSlist: > >> "Where the Answers Are" > >> > > > > > ____________________________________________________________________________ > > ___ > > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum > > Sponsor:[email protected] > > <sponsor%[email protected]>ARSlist: "Where the Answers Are" > > > > This e-mail is the property of NaviSite, Inc. It is intended only for the > > person or entity to which it is addressed and may contain information > that > > is privileged, confidential, or otherwise protected from disclosure. > > Distribution or copying of this e-mail, or the information contained > herein, > > to anyone other than the intended recipient is prohibited. > > > > > ____________________________________________________________________________ > > ___ > > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum > > Sponsor:[email protected] > > <sponsor%[email protected]>ARSlist: "Where the Answers Are" > > > > > _______________________________________________________________________________ > > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > > Platinum > > Sponsor:[email protected]<sponsor%[email protected]>ARSlist: > > "Where the Answers Are" > > > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum > Sponsor:[email protected]<sponsor%[email protected]>ARSlist: > "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
