Ok, thank you very much for the answer, Isabel. Now, I'm trying to do the upgrade in two steps:
- First, upgrade from 6.3 to 7.1 (Succeded!!!!) - Second, upgrade from 7.1 to 7.5 I didn't try the second step yet. I hope to send you good news when I have done it!!! Regards, Miguel 2009/9/9 Ross, Isabel (Access LLP) <isabel.r...@access.uk.com> > ** Miguel > > We have upgraded our training system from 6.3 to 7.5 and got there in the > end! I just sent a long reply to Kathy but it bounced so I'll keep this one > short in case it doesn't work either. > > We had a lot of different issues upgrading and were on the phone to our > support partners a LOT. We are on Solaris. I'd recommend looking at the > specific error messages and the files that are created > (arsystem_install_log.txt, > ARServer-RIKPostUpgrade.log etc). > > I had to delete our user preference and admin preference forms before it > would install cleanly. > > If you use archiving, there is a known error and a workaround to manually > amend the column archiveFromForm in the table schema_archive. > > I had to manually amend the behavior and permission columns in > FILTER_NOTIFY, changing the value from 0 to NULL before the upgrade and > changing it back afterwards. > > Regards > Isabel > ------------------------------ > *From:* Action Request System discussion list(ARSList) [mailto: > arsl...@arslist.org] *On Behalf Of *Miguel Suarez Gomez > *Sent:* Tuesday, September 08, 2009 8:59 PM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: Upgrade AR System from 7.0 to 7.5 > > ** I'm trying to upgrade from 6.3 to 7.5, getting unsuccessful results on > every time I do it. > > > The fact is that this kind of migration is supported by the installer > (confirmed in the install guide). > > Do you know any known issues or any tips about it? > > Regards, > > Miguel > > 2009/9/8 strauss <stra...@unt.edu> > >> ** >> >> Make darn sure that you have planned for recovery (back up db before each >> step, and make copies of all file directories before beginning), and have >> tested recovery procedures (restore db from backup, and deleting or renaming >> file folders for applications left behind by any failed install) for each >> step of the upgrade, ESPECIALLY for the AtriumCore installer which I have >> only seen succeed once in our environment with the minimum number of >> features. Some of the app installers had to be run a second time to clear >> all errors; not all of them will run more than once against the same file >> structure. I am waiting for the 7.5.00.003 patches to come out before I try >> any of this again. >> >> >> >> Known problems with AIE, if you have it installed, are that it must be >> patched to at least 7.1.00.004 before the upgrade, and if it fails it will >> delete not only the instance that you are upgrading but any other instances >> that are installed on the same server in the default directory. I don’t >> know what the prerequisites are if you are coming in from 7.0 instead of >> 7.1, but I would expect there to be some. >> >> >> >> If you have customized ANY forms or workflow, rehearse and script the >> restoration of those customizations as it is a good bet that the various 7.5 >> upgrade installers will overwrite them. Some, like searching for customers >> in ITSM 7.0, have been _*extensively*_ rewritten and that will break any >> customizations that you have made to the module. If you are just using ARS, >> not ITSM, the password management code changed a lot from 7.0 to 7.1 and >> again to 7.5. >> >> >> >> Suggestion: if you have any flashboards that are actively storing History, >> edit them to have a current start date and an expiration period, and still >> watch out for an explosion of data in the FB:History table. After upgrading >> from 7.1 to 7.5, and at the end of one month, our FB:History form suddenly >> gained 41 million records in two days. >> >> >> >> My last testing was in July with all patch 002 distributions on Windows >> x64 platforms, so your experience will be different but some of the pitfalls >> will be the same. >> >> >> >> Christopher Strauss, Ph.D. >> Call Tracking Administration Manager >> University of North Texas Computing & IT Center >> http://itsm.unt.edu/ >> >> ITSM 7.0.02.009 (Incident, Problem, Change Management); >> >> Remedy Knowledge Mgmt 7.2.00.002; Service Level Mgmt 7.1.00.01+, AIE >> 7.1.00.003+; >> >> Kinetic Request 4.0.3.3, Survey Lite 4.0.3.3, Calendar Lite 1.2+; >> >> on AR Server, Approval, Assignment, Mid-Tier, and Flashboards 7.1.00.002 >> (AREmail Patch 004 debug) >> >> on: Win2K3 Ent x64 Sp2 / SQL Server 2005 x64 Sp2 >> >> >> >> *From:* Action Request System discussion list(ARSList) [mailto: >> arsl...@arslist.org] *On Behalf Of *Kathy Morris >> *Sent:* Tuesday, September 08, 2009 9:48 AM >> *To:* arslist@ARSLIST.ORG >> *Subject:* Upgrade AR System from 7.0 to 7.5 >> >> >> >> ** >> >> Hello all - >> >> >> >> I am about to upgrade our system AR System from 7.0 to 7.5, and I was >> wondering what challenges, gotchas, tips, things to look out for, what have >> other developers experienced. Is this going to be painful.... uuugh.... >> >> >> >> We will be keeping our existing data, and workflows. >> >> >> >> >> >> >> >> >> ------------------------------ >> >> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers >> Are"_ >> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers >> Are"_ >> > > _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers > Are"_ > > ***Disclaimer**** > > This e-mail and any attachments are for the intended addressee(s) only and > may contain confidential and/or privileged material. If you are not a named > addressee, do not use, retain or disclose such information. This email is > not guaranteed to be free from viruses and does not bind Access in any > contract or obligation. > > > > SERVICE GLASGOW LLP trading as ACCESS Registered in Scotland. No: SO301705 > Registered Office:112 Ingram Street, Glasgow, G1 1ET > > > _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers > Are"_ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"