Starr, We ran into the same problem upgrading from 6.3 to 7.1. The problem was as Russ suggested, you have a duplicate Login Name in the user_cache table, not User. Run SQL to search for the duplicate and remove through SQL. Afterwards, you may need to run arcache as it seems deleting the duplicate record corrupted user_cache.
Once we went through this process, the install proceeded. We have added
several fields to the User form so this isn't the problem. Also, be sure
that the schemaid on control is set to +1 greater than the last schemaid on
arschema. 7.1 will install new forms.
HTH
Marc
"Perkins, Starr"
<[EMAIL PROTECTED]
N.COM> To
arslist@ARSLIST.ORG
Sent by: "Action cc
Request System
discussion Subject
list(ARSList)" Re: 7.1 Patch 001 upgrade issue
<[EMAIL PROTECTED]
ORG>
Thu 02/21/2008
06:29 PM
Please respond to
[EMAIL PROTECTED]
RG
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"
(See attached file: C.htm)
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
| **
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. From: Action
Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Russ Grant Starr, Date: Thu, 14 Feb 2008 12:59:21
-0500 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___
|
