Hi Ken, Thanks for your response.
For the form which we are facing the issue, in the Base devleopment mode it shows its "overlaid", in the Best Practice Customization mode it shows "unmodified". Is this the issue? If so, how to overcome this? On Fri, Mar 13, 2015 at 2:52 AM, Ken Pritchard <[email protected]> wrote: > ** > > I’ve seen the unique index error occur when there is a form with and > without the __c designation. Seems like the system thinks they are two > different forms, but the same form. > > > > *From:* Action Request System discussion list(ARSList) [mailto: > [email protected]] *On Behalf Of *Grooms, Frederick W > *Sent:* Thursday, March 12, 2015 2:03 PM > > *To:* [email protected] > *Subject:* Re: ITSM Upgrade completed with warnings - In fact failed to > upgrade > > > > ** > > The SQL database operation failed.; Error - OCI_INVALID_HANDLE, 552 > > > > Sounds like your database had an error with connecting to it. I believe > there is an SQL log made during the upgrade. See if it has any more > information > > > > Look to see what the SQL was doing when you got the > > The value(s) for this entry violate a unique index that has been defined > for this form; , 382 > > > > That will tell you which forms tried to create duplicate records > > > > Fred > > > > *From:* Action Request System discussion list(ARSList) [ > mailto:[email protected] <[email protected]>] *On Behalf Of *Nagidi > Pavan > *Sent:* Thursday, March 12, 2015 12:52 PM > *To:* [email protected] > *Subject:* Re: ITSM Upgrade completed with warnings - In fact failed to > upgrade > > > > ** > > Hi William, > > Firstly, thanks for your response. > > Below was done prior to ITSM upgrade. > > > 1) We have upgraded AR Server from 7.6.04 to 8.1.02 without any issues. > 2) Ran BPCU in overlay mode to preserve our customizations > 3) Upgraded Atrium Core successfully from 7.6.03 to 8.1.02 > 4) Upgraded ITSM from 7.6.03 to 8.1.02 successfully after fixing issues > with field mappings using the option "Only copy CI attributes from CDM to > ITSM Foundation". > 5) Restarted upgrade once again with the option "Upgrade to 8.1.02 but don > not remove CI attributes from CDM". After 13 hours we got the results as > "BMC Remedy ITSM Suite 8.1.02 install completed with warnings." > > I believe I am going in the correct direction. Please advise. > > Thanks > > Pavan > > > > *From:* Action Request System discussion list(ARSList) [mailto: > [email protected]] *On Behalf Of *Nagidi Pavan > *Sent:* Thursday, March 12, 2015 12:14 PM > *To:* [email protected] > *Subject:* ITSM Upgrade completed with warnings - In fact failed to > upgrade > > > > ** > > Hello Experts, > > We tried to upgraded ITSM from 7.603 to 8.1.02, but it says completed with > warnings. From the logs we could find many def files failed to import. We > have sorted out issues related to Asset, incident and Problem Management. > But facing issues while importing the def files related to Change Module. > > We could see the below error messages while importing the file. > > The SQL database operation failed.; Error - OCI_INVALID_HANDLE, 552, > The following item was not imported; > CHG:ChangeImpactedAreaCIAssociation_Join, 55, > The following item was not imported; > CHG:Change-ImpactedAreasCIAssociation_outer_ApproverLookup, 55, > The following item was not imported; CHG:ChangeRelationshipInterface, 55 > > We have restarted Remedy services and tried importing that again. This > time we could find the below messages. > > The value(s) for this entry violate a unique index that has been defined > for this form; , 382, > The following item was not imported; > CHG:ChangeImpactedAreaCIAssociation_Join, 55, > The following item was not imported; > CHG:Change-ImpactedAreasCIAssociation_outer_ApproverLookup, 55, > The following item was not imported; CHG:ChangeRelationshipInterface, > 55, > > > > I have opened a ticket with BMC but as as usual very poor response in this > week. Any suggestions are highly appreciated. > > Thanks > > Pavan > > > > > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > _ARSlist: "Where the Answers Are" and have been for 20 years_ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
