Hi Russ, Thanks for the suggestion but in our case it isn't the issue. We do not have any duplicate user names. (ran the command just to be absolutely sure) Per BMC support this issue occurred because we had added fields to the user form. I'll post again when we have decided what path we will take to resolve the issue. Thanks Again, Starr Perkins VeriSign, Inc. [EMAIL PROTECTED] ________________________________
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Russ Grant Sent: Friday, February 15, 2008 9:15 AM To: arslist@ARSLIST.ORG Subject: Re: 7.1 Patch 001 upgrade issue Starr, I believe the reason you are getting the unique index error is that you have duplicate user names in the user name form - which will prevent the new user form from being imported (since Remedy added a unique index to the user form on the Login Name field). You can run the query below in a query analyzer to identify the duplicates. In my case the upgraded errored out and rolled back to ARS 6.3, I was able to clean up the duplicates using the RUT, start the upgrade over and went forward with a clean install. HTH Russ select username, count(username) from user_cache group by username having count(username)>1 ________________________________ Date: Thu, 14 Feb 2008 12:59:21 -0500 From: [EMAIL PROTECTED] Subject: 7.1 Patch 001 upgrade issue To: arslist@ARSLIST.ORG ** Hello list, I attempted to upgrade my server version 7.1.00 Build 001RTDB280865278520200710272157 to 7.1.00 Patch 001 200711161033. Everything looked great - no issues during install. But much to my surprise I now have no user or group form. The install did not error. If I try to import either form from a back up I get a unique index. A look at the DB shows that the tables still exist and have the expected data in them. I would really like to avoid rebuilding this server from scratch again. Any suggestions? Has anyone else run into any issue with this upgrade? I have opened a case with BMC but fear they will just recommend that I rebuild since this same thing happened between my 7.1 to Server Version 7.1.00 Build 001 RTDB280865278520200710272157 upgrade and in the end we started over. Server Details: Server Version: 7.1.00 Patch 001 200711161033 Hardware: i686 OS: Linux 2.6.9-55.ELsmp Database: Oracle - installed on a remote server DB Version: 10.2.0.2.0 - 64bi TIA, Starr Perkins VeriSign, Inc. [EMAIL PROTECTED] __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
