What is the DB compatibility level of the ARSystem database that you want to upgrade? If below 80 I think it will be incompatible and may be the cause of those SQL errors?
If below 80 I would suggest that you upgrade that to 80 or above using the stored proceedure sp_dbcmptlevel. Assuming ARSystem is the name of your database, on your SQL prompt type sp_dbcmptlevel 'ARSystem' This will return a result such as: The current compatibility level is 80. The following are values for compatibility level for different versions of SQL.. 80 = SQL Server 2000 90 = SQL Server 2005 100 = SQL Server 2008 That being said you can run a lower version ie lets say 70 on SQL server 2000 by manipulating this using sp_dbcmptlevel.. If the level returned is below 80, you might have a problem. You will need to upgrade it using this same stored proceedure.. sp_dbcmptlevel ARSystem, 90 (to set it to 2005) OR sp_dbcmptlevel ARSystem, 100 (to set it to 2008 if thats your version of the SQL Server) You may need to run RECONFIGURE after running the above command and then possibly restart the SQL server.. Hope this helps.. Cheers Joe ________________________________ From: "Rodriguez, Rafael J x23718" <rafael.rodrig...@broadridge.com> To: arslist@ARSLIST.ORG Sent: Tuesday, May 26, 2009 4:27:31 PM Subject: Re: ARS 7.5 Install Issue ** SQL2005 SP3 ________________________________ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe DeSouza Sent: Tuesday, May 26, 2009 3:05 PM To: arslist@ARSLIST.ORG Subject: Re: ARS 7.5 Install Issue ** What database are you using when you get this error? Joe ________________________________ From: "Rodriguez, Rafael J x23718" <rafael.rodrig...@broadridge.com> To: arslist@ARSLIST.ORG Sent: Tuesday, May 26, 2009 12:45:40 PM Subject: Re: ARS 7.5 Install Issue Elry, you are correct! I still have this issue with 7.5 Patch 1 -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Elry Sent: Tuesday, May 26, 2009 12:13 PM To: arslist@ARSLIST.ORG Subject: Re: ARS 7.5 Install Issue Hi Guys... We did an upgrade recently in our development and staging environment much like what started this "thread". We found that: 1) 7.5 had installations issues - that were dealt with by using patch 1. 2) Even when using patch 1 - we found that we had to do a clean uninstall before trying again... 3) When you go to install the Clients - 7.5 has a completely different file structure than 7.1 4) If you install the Clients based on the install defaults - you will "wind up" with 7.1 & 7.5 on your system. 5) For a complete install of 7.5 without 7.1 - you will have to uninstall 7.1 before installing 7.5.. 6) Our Silent Install script no longer worked because 7.5 uses a different installer with different prompts... I am sure there are folks out there with similar insights.... On May 26, 9:40 am, Howard Richter <hbr4...@gmail.com> wrote: > Rafael, > > So it sounds like 7.5 should be a new install only. > > Howard > > On Tue, May 26, 2009 at 8:46 AM, Rodriguez, Rafael J x23718 < > > > > rafael.rodrig...@broadridge.com> wrote: > > ** Howard thanks for you reply, actually there were some issues with > > forms and workflow that did not exists. Funny that 7.0.1 Patch6 > > never through any exemptions and now on 7.5 there were errors all > > over the place. The worst part about it is the new suite install > > that only allow you to install it once. THIS IS A PAIN IN THE BUTT! > > > I got it resolved but had to literally unistall it and clean it out > > numerous times before it would take. > > > Rafael > > > ------------------------------ > > *From:* Action Request System discussion list(ARSList) [mailto: > > arsl...@arslist.org] *On Behalf Of *Howard Richter > > *Sent:* Friday, May 22, 2009 9:33 PM > > *To:* arsl...@arslist.org > > *Subject:* Re: ARS 7.5 Install Issue > > > ** Rafael, > > > Any issues with the database? > > > Howard > > > On Fri, May 22, 2009 at 3:30 PM, Rodriguez, Rafael J x23718 < > > rafael.rodrig...@broadridge.com> wrote: > > >> ** > > >> Hello list, > > >> WIN2003 Server > > >> SQL2005 > > >> I was attempting to upgrade my current dev environment remedy > >> installation from 7.0.1 patch 6 to 7.5 Patch 1 and I'm getting an > >> error during installation. The error appears in the event log but > >> there is no errors in the install_log: > > >> Event Type: Error > >> Event Source: AR System Monitor > >> Event Category: None > >> Event ID: 0 > >> Date: 05/22/2009 > >> Time: 1:45:48 PM > >> User: N/A > >> Computer: REM4DEV > >> Description: > >> 390600 : Failure during SQL operation to the database (ARERR 552) > > >> Any ideas? > > >> Rafael Rodriguez*|*Manager Remedy/Mid-Tier Enterprise*|*Broadridge > >> Financial Solutions > > >> 2 Journal Square Plaza*|*Jersey City, NJ 07306*|* 201.714.3718 p > > >> This message and any attachments are intended only for the use of > >> the addressee and may contain information that is privileged and > >> confidential. If the reader of the message is not the intended > >> recipient or an authorized representative of the intended > >> recipient, you are hereby notified that any dissemination of this > >> communication is strictly prohibited. If you have received this > >> communication in error, please notify us immediately by e-mail and delete > >> the message and any attachments from your system. > > >> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the > >> Answers Are"_ > > > -- > > Howard Richter > > Red Hat Certified Technician > > CompTIA Linux+ Certified > > ITIL Foundation Certified > > E-Mail = hbr4...@gmail.com > > LinkedIn Profile =http://www.linkedin.com/in/hbr4270 > > _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the > > Answers Are"_ > > > This message and any attachments are intended only for the use of > > the addressee and may contain information that is privileged and > > confidential. If the reader of the message is not the intended > > recipient or an authorized representative of the intended recipient, > > you are hereby notified that any dissemination of this communication > > is strictly prohibited. If you have received this communication in > > error, please notify us immediately by e-mail and delete the message and > > any attachments from your system. > > > _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the > > Answers Are"_ > > -- > Howard Richter > Red Hat Certified Technician > CompTIA Linux+ Certified > ITIL Foundation Certified > E-Mail = hbr4...@gmail.com > LinkedIn Profile =http://www.linkedin.com/in/hbr4270 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
